Alias: BACA #
Unique Keys: _Child Table: _
Parent Table: _
Date Sensitive Group information.
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | Y | Internal Unique identifier | |
| ACA_CATEGORY_CODE | Varchar2(16) | Y | Category Code | |
| 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 | |
| DEN_ID | Number(10) | Link to IDEN Entity | ||
| DSP_ID | Number(10) | Link to IDSP State | ||
| DUN_ID | Number(10) | Link to IDUN Unit | ||
| PEL_ID_HOURS | Number(10) | Link to IPPE Element for Hours | ||
| PEL_ID_WAGES | Number(10) | Link to IPPE Element for Wages | ||
| ACA_BARGAINING | Varchar2(2) | Lexicon: Bargaining / Non Bargaining Unit | ||
| ACA_HOURS_RULE | Varchar2(2) | Lexicon: Look Back / Monthly Measurement | ||
| ACA_PAYROLL | Varchar2(2) | Lexicon: Hourly / Salary | ||
| ACA_WAGE_RULE | Varchar2(2) | Lexicon: Federal Poverty Line / Rate of Pay / Form W2 Wages | ||
| ADMIN_PERIOD | Number(5) | May not be more than 3 (months) | ||
| DESCRIPTION | Varchar2(50) | |||
| INTERNAL_MEASUREMENT | Number(5) | Months for initial measurement period to determine employee full time status | ||
| LOOKBACK_MONTHS | Number(5) | Must be between 3 and 12. Mandatory if look back hours rule is selected | ||
| MEASURE_PERIOD_START | Date | |||
| SEASONAL_VARIABLE | Varchar2(1) | |||
| WEEKDAY | Varchar2(1) | |||
| PEL_ID_LEAVES | Number(10) | |||
| SERVICE_BREAK_RULE | Varchar2(2) | |||
| STABILITY_PERIOD | Number(5) |
User Fields: Allowed
Audit Logging: Allowed
Notes #
Page could not be found by the page provider.Screen 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