Workday · Absence
Absence
Balances that derive instead of disagree, and a time-off liability finance can sign. One line-grain fact, the enterprise dimensions, no new stars.
◆Reports
Time-Off Balances & LiabilityLive
Why balance reports disagree, the per-plan rules, and the liability priced and reconciled like the balance-sheet number it is.
Workers on LeaveLive
Leaves as intervals, the overdue follow-up list, and effect flags per leave type.
◆The model
| Table | Grain | Role |
|---|---|---|
| fct_time_off | One row per accrual, usage, or adjustment line, per worker, plan, and period. | Balances derive from it, per plan year, never extracted. See the report. |
| dim_worker, dim_org, dim_cost_center, dim_date | Unchanged. | The enterprise dimensions, reused. See the enterprise model. |
Want time-off liability live in 10 days?
The line-grain fact and the balance walk, reconciled against Workday, and you own every line.