!!!Alias: ALPD
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Leave Policy Details

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[ALP_ID]|Number(10)|[ID]|Y|link to [P2K_AT_LEAVE_POLICIES]
|[DTC_ID]|Number(10)|[ID]|Y|link to [P2K_CM_TIME_CODES]
|[PFQ_ID]|Number(10)|[ID]| |link to [P2K_PR_FREQUENCIES]
|[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS]
|[EFFECTIVE]|Date()|[EFFECTIVE]|Y|
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[LEAVE_POLICY_BASIS]|Varchar2(2)|[X_TIME_BASIS]|Y|
|[TIME_WARNING_RULE]|Varchar2(2)|[X_TIME_WARNING_RULE]|Y|
|[ACCRUAL_BEGIN_RULE]|Varchar2(2)|[X_ACCRUAL_BEGIN_RULE]|Y|
|[POLICY_START_DATE]|Date()|[DATE]|Y|
|[POLICY_END_DATE]|Date()|[DATE]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[SERVICE_TIME_BASIS]|Varchar2(2)|[X_TIME_BASIS]| |
|[LEAVE_REASON_REQUIRED]|Varchar2(1)|[TOGGLE]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CASCADE_RULE]|Varchar2(2)|[X_CASCADE_RULE]| |

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