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