!!!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|PLAN_CODE]|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|COVERAGE_CODE]|Varchar2(16)|Y*|If provided, must be a coverage under the PLAN CODE COVERED provided.
|[PLAN_CODE_ENROLLED|PLAN_CODE]|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|COVERAGE_CODE]|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|Edit:Internal.INF_CV_ACA_MONTHLY_DATA] 	
[{InsertPage page='Internal.INF_CV_ACA_MONTHLY_DATA' default='Click to create a new notes page'}]