P 2 K_LR_GRIEVANCE_UNIT_RULES

Alias:LUR#

(P2K_LR_GRIEVANCE_UNIT_RULES)

Unique Keys: LGR_ID (Grievance) + DUD_ID (Unit + Effective)
Parent Table: P2K_LR_GRIEVANCE_RULES; P2K_CM_UNIT_DETAILS
ERD:ERD-LR03


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)IDYFor P2K_CM_UNIT_DETAILS
LGR_IDNumber(10)IDYFor P2K_LR_GRIEVANCE_RULES
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