!!!Alias: BACAM
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Date Sensitive Group information.

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)| |Y|Inernal Unique identifier
|[EEM_ID]| Number(10)| |Y| Link to IEEI Employment
|[BACA_ID]|Number(10)| |Y|Link to IBACA Category Code
|[MEX_ID]| Number(10)| |Y| Link to the UBACA Execution that created this data
|[YEAR]|Number(5)| |Y| The year this data applies to.
|[MONTH]| Number(5)| |Y| The month this data applies to
|[CREATE_USER]|Varchar2(30)| |Y|Internal audit field
|[CREATE_DATE]| Date| |Y|Internal audit field
|[CHANGE_USER]|Varchar2(30)| | Y|Internal audit field
|[CHANGE_DATE]|DATE | |Y |Internal audit field
|[BCG_ID_COVERED_BY]|Number(10)| | | Link to IBPN Coverage for minimum cost coverage 
|[BCG_ID_ENROLLED]|Number(10)| | | Link to IBPN Coverage the employee is actually enrolled in
|[ACA_PERIOD]|Varchar2(4)| | | Link to IBPN Coverage for minimum cost coverage
|[COVERAGE_RATE]|Number(18,6)| | | Rate of that selected Coverage Code
|[FINAL]|Varchar2(1)| | | A flag to indicate if a subsequent UBACA run can simply read this data rather than re-compute it
|[HOURS]|Number(7,2)| | | Hours worked this month
|[LINE14_CODE]|Varchar2(2)| | | A value from 1A to 1I corresponding to the appropriate 1095C coverage indicator
|[LINE16_CODE]|Varchar2(2)| | | A value from 2A to 2I corresponding to the appropriate 1095C employment indicator
|[WAGE_RATE]|Number(18,6)| | | Wage rate for this month
|[FULL_TIME]|Varchar2(1)| | | A toggle to indicate if the employee is considered full-time for this month.
|[BCG_ID]|Number(10)| | |
|[ACA_MONTH]|Varchar2(16)| | |
\\
User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_BE_ACA_MONTHLY_DATA] 	
[{InsertPage page='Internal.P2K_BE_ACA_MONTHLY_DATA’ default='Click to create a new notes page'}]