BENEFIT COST RULE Table
View exposing benefit cost rule detail including plan, age range, cost grouping, effective dates, cost amounts, factors, and wage type codes used to calculate employee and employer benefit costs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFIT_COST_GROUPING |
Benefit cost grouping as provided by the source. |
VARCHAR2 |
4 |
BENEFIT_COST_RULE_END_DATE |
Date associated with benefit cost rule end. |
DATE |
|
BENEFIT_COST_RULE_START_DATE |
Date associated with benefit cost rule start. |
DATE |
|
BENEFIT_COST_RULE_VARIANT |
Benefit cost rule variant as provided by the source. |
VARCHAR2 |
4 |
BENEFIT_FROM_AGE |
Benefit from age as provided by the source. |
VARCHAR2 |
2 |
BENEFIT_PLAN_CODE |
Code identifying benefit plan. |
VARCHAR2 |
4 |
BENEFIT_PLAN_NAME |
Benefit plan name as provided by the source. |
VARCHAR2 |
30 |
BENEFIT_THRU_AGE |
Benefit thru age as provided by the source. |
VARCHAR2 |
2 |
DIVIDER |
Divider as provided by the source. |
NUMBER |
|
EMPLOYEE_BENEFIT_FACTOR |
Employee benefit factor as provided by the source. |
NUMBER |
11,4 |
EMPLOYEE_COST_AMOUNT |
Employee cost amount as provided by the source. |
NUMBER |
17,2 |
EMPLOYEE_POSTTAX_WAGE_TYPE_CDE |
Employee posttax wage type cde as provided by the source. |
VARCHAR2 |
4 |
EMPLOYEE_PRETAX_WAGE_TYPE_CDE |
Employee pretax wage type cde as provided by the source. |
VARCHAR2 |
4 |
EMPLOYER_BENEFIT_FACTOR |
Employer benefit factor as provided by the source. |
NUMBER |
11,4 |
EMPLOYER_COST_AMOUNT |
Employer cost amount as provided by the source. |
NUMBER |
17,2 |
EMPLOYER_WAGE_TYPE_CDE |
Employer wage type cde as provided by the source. |
VARCHAR2 |
4 |
INSURANCE_INCREMENT |
Insurance increment as provided by the source. |
NUMBER |
17,2 |
PROVIDER_BENEFIT_FACTOR |
Provider benefit factor as provided by the source. |
NUMBER |
11,4 |
PROVIDER_COST_AMOUNT |
Provider cost amount as provided by the source. |
NUMBER |
17,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |