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 #
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