This is version 1 2 3 4 5 6 7 8 9 10 11 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias:LGV#

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

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

User Fields: Allowed
Audit Logging: Allowed