P 2 K_LR_GRIEVANCE_STEPS

Alias:LGRS#

(P2K_LR_GRIEVANCE_STEPS)

Unique Keys: LGR_ID (Grievance) + GRIEVANCE_STEP_CODE
Parent Table: P2K_LR_GRIEVANCE_RULES
ERD: ERD-LR03


This table describes the sequence of steps to be followed in grievance resolution.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LGR_IDNumber(10)IDYPart of P2K_LR_GRIEVANCE_RULES
GRIEVANCE_STEP_CODEVarchar2(16)CODEY
GRIEVANCE_STEP_SEQUENCENumber(5)NUMBER5Y
PARTICIPANT_TYPEVarchar2(2)X_PARTICIPANT_TYPEY
GRIEVANCE_STATUSVarchar2(2)X_GRIEVANCE_STATUS
GRIEVANCE_STAGEVarchar2(2)X_GRIEVANCE_STAGE
DESCRIPTIONVarchar2(50)DESCRIPTION
TIME_WINDOW_VALUENumber(9)AMT5V4
TIME_WINDOW_BASISVarchar2(2)X_TIME_WINDOW_BASIS
TIME_WINDOW_METHODVarchar2(2)X_TIME_WINDOW_METHOD
GRIEVANCE_STEP_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

Derived Fields#

Column Name
DRV_ESTIMATED_INTERVAL

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page