BENEFIT COST RULE Table
This table contains information about employee, employer, and provider costs for various plans, depending on coverage levels
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFIT_COST_GROUPING |
XXX |
VARCHAR2 |
4 |
BENEFIT_COST_RULE_END_DATE |
XXX |
DATE |
|
BENEFIT_COST_RULE_START_DATE |
XXX |
DATE |
|
BENEFIT_COST_RULE_VARIANT |
XXX |
VARCHAR2 |
4 |
BENEFIT_FROM_AGE |
XXX |
VARCHAR2 |
2 |
BENEFIT_PLAN_CODE |
XXX |
VARCHAR2 |
4 |
BENEFIT_PLAN_NAME |
XXX |
VARCHAR2 |
30 |
BENEFIT_THRU_AGE |
XXX |
VARCHAR2 |
2 |
DIVIDER |
XXX |
NUMBER |
|
EMPLOYEE_BENEFIT_FACTOR |
XXX |
NUMBER |
11,4 |
EMPLOYEE_COST_AMOUNT |
XXX |
NUMBER |
17,2 |
EMPLOYEE_POSTTAX_WAGE_TYPE_CDE |
XXX |
VARCHAR2 |
4 |
EMPLOYEE_PRETAX_WAGE_TYPE_CDE |
XXX |
VARCHAR2 |
4 |
EMPLOYER_BENEFIT_FACTOR |
XXX |
NUMBER |
11,4 |
EMPLOYER_COST_AMOUNT |
XXX |
NUMBER |
17,2 |
EMPLOYER_WAGE_TYPE_CDE |
XXX |
VARCHAR2 |
4 |
INSURANCE_INCREMENT |
XXX |
NUMBER |
17,2 |
PROVIDER_BENEFIT_FACTOR |
XXX |
NUMBER |
11,4 |
PROVIDER_COST_AMOUNT |
XXX |
NUMBER |
17,2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |