!!!Alias: ALA
(P2K_AT_LEAVE_ACCRUALS)

Unique Keys: \\
Child Table: \\
Parent Table:\\
\\
Leave Accruals

!!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]
|[ALPT_ID]|Number(10)|[ID]|Y|link to [P2K_AT_LEAVE_POLICY_TYPES]
|[EEM_ID]|Number(10)|[ID]|Y|link to [P2K_HR_EMPLOYMENTS]
|[LEAVE_POLICY_YEAR]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[UNOFFICIAL]|Varchar2(1)|[X_UNOFFICIAL]|Y|
|[ALA_ID]|Number(10)|[ID]| |link to [P2K_AT_LEAVE_ACCRUALS]
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[START_DATE]|Date()|[DATE]|Y|
|[END_DATE]|Date()|[DATE]|Y|
|[LEAVE_POLICY_STATUS]|Varchar2(2)|[X_LVPOL_STATUS]|Y|
|[EVALUATED_BY]|Varchar2(50)|[DESCRIPTION]| |
|[EVALUATED_DATE]|Date()|[DATE]| |
|[ENTITLEMENT_FROZEN]|Varchar2(1)|[TOGGLE]| |
|[LAST_PAYNO_PROCESSED]|Number(5)|[NUMBER5|NUMBERn]| |
|[SERVICE_EVALUATION_DATE]|Date()|[DATE]| |
|[ENTITLEMENT_GIVEN_DATE]|Date()|[DATE]| |

!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_BALANCE_TO_DATE]
|[DRV_CURRENT_ENTITLEMENT]
|[DRV_CURRENT_ENTITLEMENT_CAPPED]
|[DRV_CURRENT_TAKEN]
|[DRV_PRIOR_YEAR_BAL]
|[DRV_TIME_BASIS]
|[DRV_TOTAL_PLANNED]
|[DRV_TOTAL_TIME_OWING]
|[DRV_UNACCRUED_GIVEN]
|[DRV_UNACCRUED_TAKEN]

!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_DDP_ID]
|[DRV_DJB_ID]
|[DRV_FILLED]
|[DRV_TWS_ID]
|[DRV_VACANT]

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


[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.P2K_AT_LEAVE_ACCRUALS] 	
[{InsertPage page='Internal.P2K_AT_LEAVE_ACCRUALS' default='Click to create a new discussion page'}] 	

}]