!!!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]|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|Edit:Internal.P2K_BE_ACA_CATEGORIES] [{InsertPage page='Internal. P2K_BE_ACA_CATEGORIES’ default='Click to create a new notes page'}]