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

Back to current versionRestore this version

Alias:LCM#

Unique Keys: DEN_ID (Entity) + COMPLAINT_CODE
Child Table: P2K_LR_COMPLAINT_PARTICIPANTS

This table contains information about each complaint noted within the system.

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
DDP_ID	Number(10)	ID		About P2K_CM_DEPARTMENTS
DLN_ID	Number(10)	ID		About P2K_CM_LOCATIONS
LDI_ID	Number(10)	ID		Results in P2K_LR_DISCIPLINARY_ISSUES
LGV_ID	Number(10)	ID		Elevated toP2K_LR_GRIEVANCES
EID_ID	Number(10)	ID		About P2K_HR_IDENTITIES
LDT_ID	Number(10)	ID		For P2K_LR_DISPUTE_TYPES
DUN_ID	Number(10)	ID		About P2K_CM_UNITS
COMPLAINT_CODE	Varchar2(16)	CODE	Y
COMPLAINT_ISSUED_DATE	Date()	DATE	Y
COMPLAINT_STATUS	Varchar2(2)	X_COMPLAINT_STATUS	Y
COMPLAINT_STAGE	Varchar2(2)	X_COMPLAINT_STAGE
COMPLAINT_SEVERITY	Varchar2(2)	X_COMPLAINT_SEVERITY
DATE_OF_INCIDENT	Date()	DATE
INCIDENT_WITNESSES	Varchar2(4000)	VARCHAR4000
DESCRIPTION	Varchar2(50)	DESCRIPTION
COMPLAINT_TEXT	Varchar2(4000)	VARCHAR4000
CONTRACT_REFERENCE	Varchar2(4000)	VARCHAR4000
UNION_REFERENCE	Varchar2(4000)	VARCHAR4000
COMPLAINT_CLOSED_DATE	Date()	DATE
COMPLAINT_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