P 2 K_SH_TIME_LOST_DETAILS
Back to current versionRestore this version

Alias: #

Unique Keys:
Child Table:
Parent Table:

This table contains date sensitive information @@@

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
HHI_IDNumber(10)IDYLink to P2K_SH_HEALTH_ISSUES
PPL_IDNumber(10)ID Link to P2K_PR_PAY_LINES
AAL_IDNumber(10)ID Link to P2K_AT_LEAVE_LINES
EAS_IDNumber(10)IDYLink to P2K_HR_ASSIGNMENTS
TIME_CODEVarchar2(16)CODEY
START_DATEDate()DATEY
TIME_VALUENumber(9)AMT5V4
TIME_BASISVarchar2(2)(Lexicon)
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
REFERENCE_INFOVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed