P 2 K_LR_GRIEVANCE_STEPS
Back to current versionRestore this version

Alias:LGRS#

Unique Keys:
Child Table:
Parent Table

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LGR_IDNumber(10)IDYLink to P2K_LR_GRIEVANCE_RULES
GRIEVANCE_STEP_CODEVarchar2(16)CODEY
GRIEVANCE_STEP_SEQUENCENumber(5)NUMBER5Y
PARTICIPANT_TYPEVarchar2(2)(Lexicon)Y
GRIEVANCE_STATUSVarchar2(2)(Lexicon)
GRIEVANCE_STAGEVarchar2(2)(Lexicon)
DESCRIPTIONVarchar2(50)DESCRIPTION
TIME_WINDOW_VALUENumber(9)AMT5V4
TIME_WINDOW_BASISVarchar2(2)(Lexicon)
TIME_WINDOW_METHODVarchar2(2)(Lexicon)
GRIEVANCE_STEP_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed