Alias: IVBEN#
The INF_CV_ENROLLMENTS table is used to import the list of benefit plans and coverage’s that an employee has elected to participate in into the software data structures. The Plan, Coverage and Benefit Components must be defined in the benefit module before loading in ENROLLMENT recordsTable Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ENTITY_CODE | Varchar2(16) | CODE | Y | |
| PERSON_CODE | Varchar2(16) | CODE | Y | |
| EMPLOYMENT_TYPE | Varchar2(30) | VARCHAR30 | ||
| HIRE_DATE | Date() | DATE | ||
| PLAN_CODE | Varchar2(16) | CODE | Y | |
| EFFECTIVE | Date() | EFFECTIVE | Y | |
| EXPIRY | Date() | EXPIRY | Y | |
| CHANGE_CODE | Varchar2(16) | CODE | ||
| COVERAGE_CODE | Varchar2(16) | CODE | ||
| FREQUENCY_CODE | Varchar2(16) | CODE | ||
| PARTICIPATION_RULE | Varchar2(30) | VARCHAR30 | ||
| COVERAGE_STEP_CODE | Varchar2(16) | CODE | ||
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| UNOFFICIAL | Varchar2(30) | VARCHAR30 | ||
| ENROLLMENT_STATUS | Varchar2(30) | VARCHAR30 | ||
| ELIGIBILITY_START_DATE | Date() | DATE | ||
| ELIGIBILITY_END_DATE | Date() | DATE | ||
| PREMIUM_START_DATE | Date() | DATE | ||
| PREMIUM_END_DATE | Date() | DATE | ||
| PLAN_REG_NUMBER | Varchar2(50) | VARCHAR50 | ||
| EVIDENCE_OF_INSURANCE | Varchar2(4) | VARCHAR4 | ||
| PERCENTAGE | Number(5) | PERCENT | ||
| BC_CODE | Varchar2(16) | CODE | ||
| AMOUNT | Number(18) | AMT12V6 | ||
| AMOUNT_OVERRIDE | Number(18) | AMT12V6 | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
