Alias: ALA#

(P2K_AT_LEAVE_ACCRUALS)

Unique Keys:
Child Table:
Parent Table:

Leave Accruals

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
ALP_IDNumber(10)IDYlink to P2K_AT_LEAVE_POLICIES
ALPT_IDNumber(10)IDYlink to P2K_AT_LEAVE_POLICY_TYPES
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
LEAVE_POLICY_YEARNumber(5)NUMBER5Y
UNOFFICIALVarchar2(1)X_UNOFFICIALY
ALA_IDNumber(10)ID link to P2K_AT_LEAVE_ACCRUALS
CHANGE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_USERVarchar2(30)VARCHAR30Y
CREATE_DATEDate()DATEY
START_DATEDate()DATEY
END_DATEDate()DATEY
LEAVE_POLICY_STATUSVarchar2(2)X_LVPOL_STATUSY
EVALUATED_BYVarchar2(50)DESCRIPTION
EVALUATED_DATEDate()DATE
ENTITLEMENT_FROZENVarchar2(1)TOGGLE
LAST_PAYNO_PROCESSEDNumber(5)NUMBER5
SERVICE_EVALUATION_DATEDate()DATE
ENTITLEMENT_GIVEN_DATEDate()DATE

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

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page