Alias: IVBEN#
(INF_CV_ENROLLMENTS)Enrollment Details
Table 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 |
