What a promotion pays
Six workers moved up a grade in May. Their combined base went from 720,000.00 to 790,560.00, an average increase of 9.8 percent, and every one landed inside its new band. The report shows each move against its destination range.
◆ The May movessix promotions, each priced against its new band.
| Grade move and department | Old base | New base | Increase % |
|---|---|---|---|
| G2 to G3, Support | 98,000.00 | 107,800.00 | 10.0 |
| G3 to G4, Technology Delivery | 112,000.00 | 122,304.00 | 9.2 |
| G3 to G4, Sales | 126,000.00 | 139,104.00 | 10.4 |
| G4 to G5, Technology Delivery | 130,000.00 | 141,700.00 | 9.0 |
| G3 to G4, Sales | 124,000.00 | 137,020.00 | 10.5 |
| G4 to G5, Sales | 130,000.00 | 142,632.00 | 9.7 |
| Six moves | 720,000.00 | 790,560.00 | 9.8 |
Every new base lands inside its destination band on the grade structure: the two G5 moves sit low in a 125,000.00 to 175,000.00 range, which is where a fresh promotion should sit. These six are the same six the change ledger counts for May. Sample values are illustrative, never client data.
◆ Why the destination range decidesthe increase is the output, not the input.
Pricing a promotion as a flat percentage produces new pay that ignores where the worker lands in the new band. Price against the destination range instead: low in band for a stretch move, nearer midpoint for a proven one. The percentage then falls out, and the spread above, nine to ten and a half, is the evidence of case-by-case pricing.
◆ The owned answerpromotions from the event fact, bands from the grade dimension.
A promotion is a pay change event with a grade move; the report joins each event to the destination range and computes position in band at landing.
Schema, grain, and joins live on the compensation star; this report is a straightforward read of those tables.
- promotion
- A grade move with a pay change, one event in the ledger.
- destination range
- The new grade’s minimum to maximum; the pricing frame.
- landing position
- Where the new base sits in the destination band.
- stretch move
- An early promotion, priced low in the new band on purpose.
- habit percentage
- A flat increase applied without looking at the band; the anti-pattern.