Benefit and Time Off facts

Company Cost

The cost of benefits to both the company (Company Cost) and the employee (Employee Cost) are stored in F_BENEFIT, along with the Number of Participants, associated with each employee.

Fact: Company Cost

Comment: None

Definition:

Expression	Mapping Method	Source Table Name
CO_COST_AMT	Automatic	F_BENEFIT_QTR

Employee Cost

The cost of benefits to both the company (Company Cost) and the employee (Employee Cost) are stored in F_BENEFIT, along with the Number of Participants, associated with each employee.

Fact: Employee Cost

Comment: None

Definition:

Expression	Mapping Method	Source Table Name
EMP_COST_AMT	Automatic	F_BENEFIT_QTR

Number of Participants

The cost of benefits to both the company (Company Cost) and the employee (Employee Cost) are stored in F_BENEFIT, along with the Number of Participants, associated with each employee.

Fact: Number of Participants

Comment: None

Definition:

Expression	Mapping Method	Source Table Name
N_PARTICIPANTS	Automatic	F_BENEFIT_QTR

Number of Accrued Days

Facts relevant to Benefit Type with the Time Off value are stored in the fact table F_TIME_OFF.

Fact: Number of Accrued Days

Comment: None

Definition:

Expression	Mapping Method	Source Table Name
N_ACCRUED_DAYS	Automatic	F_TIME_OFF

Number of Used Days

Facts relevant to Benefit Type with the Time Off value are stored in the fact table F_TIME_OFF.

Fact: Number of Used Days

Comment: None

Definition:

Expression	Mapping Method	Source Table Name
N_USED_DAYS	Automatic	F_TIME_OFF