Workday · Payroll
Payroll
The module where Workday meets the ledger. One line-grain fact with two period keys, one small classification dimension, and the reconciliation that joins people cost to the ERP, the report the cross-platform model exists for.
◆Reports
Payroll Cost Trend & VarianceLive
The earned-for trend, one-time lines named, and a two-factor bridge that sums to the delta exactly.
Payroll Cost & GL ReconciliationLive
Both systems in one query on the mapped cost center dimension, run per commit so close holds no surprises.
◆Objects behind the reports
Payroll ResultLive
The gross-to-net grain, retro pay's two periods, and the component classification that powers every payroll metric.
Cost Center & CompanyLive
The mapped dimension both sides of the reconciliation join on.
◆The model
| Table | Grain | Role |
|---|---|---|
| fct_payroll_result | One row per committed result line, with paid-in and earned-for period keys. | The cost fact. Cash view and labor-cost view from one table. See Payroll Result. |
| dim_pay_component | One row per earning or deduction code. | Three classes, two flags: gross, fully loaded, and net all derive from it. |
| dim_cost_center | One row per cost center, both systems' codes. | The reconciliation join. Shared with the Core HR model and the SAP model. |
| dim_worker, dim_org, dim_date | Unchanged. | The enterprise dimensions, reused. See the enterprise model. |
Want payroll cost joined to your ledger in 10 days?
The fact, the classification, the mapped dimension, and the per-commit control, reconciled on both sides, and you own every line.