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 | Inernal 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 | 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(1) | |||
| STABILITY_PERIOD | Number(5) |
User Fields: Allowed
Audit Logging: Allowed
