Workday · Compensation · Data model
The Compensation star
One new dimension, no new facts. Targets ride the worker snapshot, changes ride the event fact, and every ratio is one join to dim_comp_grade.
Same two facts as Core HR, one new dimension in black. That is the entire cost of adding compensation analytics to the model.
◆ The module on one page— what carries what, and the pages that build and read it.
| Table | What compensation adds | Built on | Read by |
|---|---|---|---|
| fct_worker_snapshot | Annualized full-time-equivalent base, resolved bonus and other targets, and the comp range key, per worker per day. | Worker | Compa-Ratio & Range Penetration, Pay Mix & Total Compensation |
| fct_worker_event | Compensation changes with reason codes and old and new amounts. | Effective dating | Merit Cycle |
| dim_comp_grade | The new table: grades, profiles, ranges with refresh history. | Compensation Grade & Range | Every ratio in the module |
| dim_worker, dim_org, dim_job, dim_date | Nothing new. The Core HR dimensions, reused. | Core HR data model | All three reports |
◆ The proof: one story, four pages— a range refresh, a dip, a merit cycle, a recovery. Every number traces.
| What happened | Where it shows | The numbers |
|---|---|---|
| Range refresh, Mar 1 | Grade page sample rows | G07-US midpoint 114,000 → 120,000; old row closes, new row opens. |
| Ratios dip | Compa-Ratio, April | Average 0.96, nine workers below guideline. No pay changed; the anchor moved. |
| Merit cycle, May 1 | Merit Cycle | 145 eligible, the April headcount; 128 received; 2.4% average; 2.1% spend. |
| Ratios recover | Compa-Ratio, May | 0.96 × 1.021 = 0.98. The spend explains the recovery exactly. |
The mix table's 18 managers are the Span of Control report's 18, and the worker counts are the Core HR series. Two modules, one model, and every page explains the others. We build client models to reconcile the same way, against Workday, before go-live.
Want compensation analytics for the cost of one dimension?
dim_comp_grade, the resolved targets, and the three reports, reconciled against Workday, and you own every line.
Terms on this page
- star extension
- New columns and one dimension on existing facts. How modules grow the model.
- dim_comp_grade
- Grades, profiles, and ranges with refresh history. The module's one new table.
- resolved target
- Percent plans turned into money against their basis, landed as columns.
- reason code
- The classification on compensation changes. Merit's boundary.
- range refresh
- A new range version. Ratios move with no pay change.
- the tie
- Refresh, dip, cycle, recovery: each page's numbers derived from the others'.