P 2 K_PR_PAY_LEAVE_ACCRUALS
Back to current versionRestore this version

Alias: PLA#

(P2K_PR_PAY_LEAVE_ACCRUALS)

Unique Keys:
Child Table:
Parent Table:
ERD:ERD-PR60


Pay Leave Accruals

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPH_IDNumber(10)IDYlink to P2K_PR_PAY_HEADERS
ALPT_IDNumber(10)IDYlink to P2K_AT_LEAVE_POLICY_TYPES
EVALUATION_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
LEAVE_POLICY_BASISVarchar2(2)X_TIME_BASISY
PRIOR_YEAR_TIME_ADJNumber(18)AMT12V6
PRIOR_YEAR_AMOUNT_ADJNumber(18)AMT12V6
CURR_YEAR_TIME_ENTITLEMENTNumber(18)AMT12V6
CURR_YEAR_AMOUNT_EARNEDNumber(18)AMT12V6
CURR_YEAR_TIME_TAKENNumber(18)AMT12V6
CURR_TIME_OWINGNumber(18)AMT12V6
CURR_AMOUNT_OWINGNumber(18)AMT12V6
TERMINATION_TIME_OWINGNumber(18)AMT12V6
TERMINATION_AMOUNT_OWINGNumber(18)AMT12V6
PRIOR_YEAR_TIME_OWINGNumber(18)AMT12V6
PRIOR_YEAR_AMOUNT_OWINGNumber(18)AMT12V6
CURR_TIME_EARNEDNumber(18)AMT12V6
CURR_TIME_USEDNumber(18)AMT12V6

User Fields: Allowed
Audit Logging: Not Allowed