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
