Workday · Benefits
Benefits
One election fact, the deduction classification the Payroll module already carries, and a staged carrier invoice: enough to reconcile all three versions of what benefits cost, every month.
◆Reports
Benefit Cost & Deduction ReconciliationLive
Elections, deductions, and the carrier invoice per worker, with the timing signatures named and the pre-tax audit built in.
Open Enrollment TrackerLive
A fixed day-one denominator, the active-passive split, and the three queues that decide the last week.
◆The model
| Table | Grain | Role |
|---|---|---|
| fct_benefit_enrollment | One row per election version: plan, tier, both cost shares, effective dates. | The expected side. See the report. |
| fct_payroll_result | Unchanged. | The deducted side, through dim_pay_component's plan link. See Payroll Result. |
| stg_carrier_invoice | One row per invoice line per coverage month. | The invoiced side. Staged per carrier, not a star. |
Want benefit costs that reconcile every month?
The election fact and the three-way comparison, reconciled against Workday, and you own every line.