Alias: IVBACAM#
(INF_CV_ACA_MONTHLY_DATA)The INF_CV_ACA_MONTHLY_DATA table is used to import Monthly data for employee ACA reporting purposes into the correct data structures, using UVACAMONTHLY
Tables loaded: P2K_BE_ACA_MONTHLY_DATA
Table Columns#
| Column name | Data Type / Size | Mand. | Notes |
|---|---|---|---|
| ID | Number(10) | Used internally to define a unique identification for the record. This field would not be loaded. | |
| CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| ENTITY_CODE | Varchar2(16) | Y | Validation: Must be a valid entity code defined on P2K_CM_ENTITIES |
| PERSON_CODE | VARCHAR2(16) | Y | Must exist in IEID |
| EMPLOYMENT_TYPE | Varchar2(30) | If not provided, “Employee” will be used | |
| HIRE_DATE | DATE | If not provided, the latest hire date in IEEI will be used. | |
| ACA_CATEGORY_CODE | Varchar2(16) | Y | Must be defined in IBACA |
| YEAR | NUMBER(5,0) | Y | |
| MONTH | NUMBER(5,0) | Y | Between 1-12 inclusive |
| PLAN_CODE_COVERED | Varchar2(16) | If provided, must be defined in IBPN either for the specified entity, or for all entities. If this is provided, then COVG_CODE_COVERED is mandatory* | |
| COVG_CODE_COVERED | Varchar2(16) | Y* | If provided, must be a coverage under the PLAN CODE COVERED provided. |
| PLAN_CODE_ENROLLED | Varchar2(16) | If provided, must be defined in IBPN either for the specified entity, or for all entities. If this is provided, then COVG_CODE_ENROLLED is mandatory* | |
| COVG_CODE_ENROLLED | Varchar2(16 | Y* | If provided, must be a coverage under the PLAN CODE ENROLLED provided. |
| COVERAGE_RATE | NUMBER(18,6) | The cost to the employee for the coverage. | |
| ACA_PERIOD | Varchar2(4 | If provided, must be one of these values that define the employee’s status: ADM – Administration Period INIT – Initial Period NON – Non-assessment period STAB – Stability Period STD – Standard Measure Period | |
| HOURS | NUMBER(7,2) | The number of hours the employee worked in the month | |
| LINE_14_CODE | Varchar2(2) | Y | Must be one of the codes '1A', '1B', '1C', '1D', '1E', '1F', '1G', '1H', '1I', '1J', '1K' |
| LINE_16_CODE | Varchar2(2) | Y | Must be one of the codes '2A', '2B', '2C', '2D', '2E', '2F', '2G', '2H' |
| WAGE_RATE | NUMBER(18,6) | The rate of pay for the employee (documentary field only) | |
| FULL_TIME | Varchar2(1) | A flag to indicate if the employee is Full Time or not. Any value in here other than 0, N or NO will result in the employee being set to Full Time. |
