!!!Alias: ALPC
Unique Keys: _ _ _\\
Child Table: _ _ _\\
Parent Table: _ _ _\\
ERD: [ERD-AT02]\\
\\
Leave Policy Components

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[AAC_ID]|Number(10)|[ID]|Y|link to [P2K_AT_ATTENDANCE_COMPONENTS]
|[ALPD_ID]|Number(10)|[ID]|Y|link to [P2K_AT_LEAVE_POLICY_DETAILS]
|[AAR_ID]|Number(10)|[ID]|Y|link to [P2K_AT_AC_RULES]
|[PPC_ID]|Number(10)|[ID]| |link to [P2K_PR_PAY_COMPONENTS]
|[MUC_ID]|Number(10)|[ID]| |link to [P2K_AM_USER_CALCS]
|[PEL_ID]|Number(10)|[ID]| |link to [P2K_PR_ELEMENTS]
|[COMPONENT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[AC_ACTION]|Varchar2(2)|[X_AC_ACTION]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[FIELD_VALUE]|Varchar2(200)|[VARCHAR200|VARCHARnn]| |
|[ENTER_LEAVE_LINE]|Varchar2(1)|[TOGGLE]| |
|[ALLOW_VALUE_OVERRIDE]|Varchar2(1)|[TOGGLE]| |

User Fields: Allowed\\
Audit Logging: Allowed\\