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. |
Notes #
Click to create a new notes pageScreen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation