The benefits star, enrollment daily

Two facts and five dimensions. The enrollment fact stores who is covered under what, with the premium split, every day. The invoice fact stores what carriers actually billed. Every report on this module is a join between them.

RuleSnapshot enrollment daily with the premium split on the row. Cost, reconciliation, and history all read from the same fact.

Nevermodel benefits from deduction records alone. Deductions show the employee share; the employer share, the larger money, never touches a payslip line.

Two facts, five dimensions. Reconciliation is the two facts joined on worker and plan; cost is the enrollment fact rolled to the ledger.

◆ The tablestwo facts, five dimensions, one join that finds the money.

Table	Grain	Feeds
fct_enrollment_day	One worker, one plan, one day, with employer and employee premium.	Benefit cost, open enrollment, coverage history.
fct_carrier_invoice	One billed line per carrier invoice: worker, plan, amount, period.	The carrier reconciliation.
dim_worker	Who. Shared with the Core HR star.	Every report's population.
dim_benefit_plan	Plan, coverage tier, and the premium split rules.	Cost and reconciliation by plan.
dim_carrier	Who sends the bill.	The reconciliation's other side.
dim_org	The department rollup, same as payroll's.	Cost by department that ties to the ledger.
dim_date	The calendar, shared with every module star.	As-of filters and trends.

◆ Why enrollment is a snapshotcoverage changes quietly, and history matters at audit.

Elections change at events and windows, dependents age in and out, and terminated workers linger on carrier files. The delivered views answer today; the daily snapshot, extracted on the extraction pattern, answers any date, which is what an audit of last year's coverage actually needs. Same discipline as absence balances and headcount, applied to coverage.

The employer premium share rides on every enrollment row, which is what lets benefit cost roll up to the ledger account payroll proves without a second derivation.

Use case

Problem

Coverage exists only as current state, employer cost is derived ad hoc, and the carrier bill has nothing structured to reconcile against.

What we build

A daily enrollment fact carrying the premium split, and a carrier invoice fact, on shared dimensions.

What you get

Coverage as of any date, cost that rolls to the ledger, and a reconciliation that names its findings.

Can you show who was covered under what, last March?

We ship the enrollment snapshot and both reconciliations on it.

Talk to us

Terms on this page

HR: Human resources. The Core HR star shares its dimensions with this one.
fact: A table of measured rows. Here, enrollment days and invoice lines.
grain: What one row means. One worker, one plan, one day.
premium split: The employer and employee shares of one premium.
coverage tier: Employee only, plus spouse, family: the tier pricing keys off.
snapshot: A dated copy of a state, kept so the past stays queryable.
dependent: A covered person who is not the worker. Ages in and out of eligibility.