Alias: ASL#

(P2K_AT_SERVICE_LEVELS)

Unique Keys:
Child Table:
Parent Table:

Service Levels

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
ALPD_IDNumber(10)IDYlink to P2K_AT_LEAVE_POLICY_DETAILS
SERVICE_TIME_UPTONumber(5)NUMBER5Y
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
ENTITLEMENTNumber(18)AMT12V6
ENTITLEMENT_BASISVarchar2(2)X_PERIOD_BASIS
SERVICE_PRORATE_FACTORNumber(5)PERCENT
ROLLING_CAPNumber(18)AMT12V6
YEAR_END_CAPNumber(18)AMT12V6
ANNUAL_ENTITLEMENT_CAPNumber(18)AMT12V6
REG_EARNINGS_PERCENTNumber(5)PERCENT
LEGAL_EARNINGS_PERCENTNumber(5)PERCENT
ABS_EARNINGS_PERCENTNumber(5)PERCENT
SUPPL_EARNINGS_PERCENTNumber(5)PERCENT
SPECIAL_EARNINGS_PERCENTNumber(5)PERCENT
TIME_WORKED_PERCENTNumber(5)PERCENT
USER1_PERCENTNumber(5)PERCENT
USER2_PERCENTNumber(5)PERCENT
USER3_PERCENTNumber(5)PERCENT

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page