P 2 K_LR_GRIEVANCE_RULES

Alias:LGR#

(P2K_LR_GRIEVANCE_RULES)

Unique Keys: GRIEVANCE_CODE
Child Table: P2K_LR_GRIEVANCE_UNIT_RULES; P2K_LR_GRIEVANCE_STEPS
ERD:ERD-LR04


This table identifies the grievance rules. The details of how they are used is found in the child tables.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
GRIEVANCE_RULE_CODEVarchar2(16)CODEY
DESCRIPTIONVarchar2(50)DESCRIPTION
GRIEVANCE_RULE_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page