P 2 K_LR_GRIEVANCE_UNIT_RULES
Back to current versionRestore this version

Alias:LUR#

Unique Keys: LGR_ID (GRIEVANCE_CODE) + DUD_ID (UNIT_CODE+EFFECTIVE)
Parent Table: P2K_LR_GRIEVANCE_RULES; P2K_CM_UNIT_DETAILS

This table associates units (in a date sensitive manner) with grievance rules

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DUD_IDNumber(10)IDYLink to P2K_CM_UNIT_DETAILS
LGR_IDNumber(10)IDYLink to P2K_LR_GRIEVANCE_RULES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed