Alias:LGV#

(P2K_LR_GRIEVANCES)

Unique Keys: DEN_ID (Entity) + GRIEVANCE_CODE
Child Table: P2K_LR_GRIEVANCE_ACTIVITIES; P2K_LR_GRIEVANCE_PARTICIPANTS
ERD: ERD-LR03

This table identifies each grievance.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DEN_ID	Number(10)	ID	Y	For P2K_CM_ENTITIES
DUN_ID	Number(10)	ID	Y	For P2K_CM_UNITS
LDT_ID	Number(10)	ID	Y	For P2K_LR_DISPUTE_TYPES
LGR_ID	Number(10)	ID	Y	For P2K_LR_GRIEVANCE_RULES
DLN_ID	Number(10)	ID		About P2K_CM_LOCATIONS
LDI_ID	Number(10)	ID		Results in P2K_LR_DISCIPLINARY_ISSUES
DDP_ID	Number(10)	ID		About P2K_CM_DEPARTMENTS
EID_ID	Number(10)	ID		About P2K_HR_IDENTITIES
GRIEVANCE_CODE	Varchar2(16)	CODE	Y
GRIEVANCE_ISSUED_DATE	Date()	DATE	Y
GRIEVANCE_STATUS	Varchar2(2)	X_GRIEVANCE_STATUS	Y
GRIEVANCE_STAGE	Varchar2(2)	X_GRIEVANCE_STAGE
GRIEVANCE_SEVERITY	Varchar2(2)	X_GRIEVANCE_SEVERITY
DATE_OF_INCIDENT	Date()	DATE
INCIDENT_WITNESSES	Varchar2(4000)	VARCHAR4000
APPROVED	Varchar2(1)	TOGGLE
DESCRIPTION	Varchar2(50)	DESCRIPTION
GRIEVANCE_TEXT	Varchar2(4000)	VARCHAR4000
CONTRACT_REFERENCE	Varchar2(4000)	VARCHAR4000
UNION_REFERENCE	Varchar2(4000)	VARCHAR4000
GRIEVANCE_CLOSED_DATE	Date()	DATE
GRIEVANCE_DECISION	Varchar2(2)	X_COMPLAINT_DECISION
SETTLEMENT_AMOUNT	Number(18)	AMT12V6
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y

Derived Fields#

Column Name
DRV_PARTICIPANTS_LIST

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page