P 2 K_LR_COMPLAINTS
Back to current versionRestore this version

Alias:LCM#

(P2K_LR_COMPLAINTS)

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


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

Table Columns#

Column nameData Type / SizeDomainMand.Notes
ID Number(10)IDY
DEN_IDNumber(10)IDYFor P2K_CM_ENTITIES
DDP_IDNumber(10)ID About P2K_CM_DEPARTMENTS
DLN_IDNumber(10)ID About P2K_CM_LOCATIONS
LDI_IDNumber(10)ID Results in P2K_LR_DISCIPLINARY_ISSUES
LGV_IDNumber(10)ID Elevated toP2K_LR_GRIEVANCES
EID_IDNumber(10)ID About P2K_HR_IDENTITIES
LDT_IDNumber(10)ID For P2K_LR_DISPUTE_TYPES
DUN_IDNumber(10)ID About P2K_CM_UNITS
COMPLAINT_CODE Varchar2(16)CODEY
COMPLAINT_ISSUED_DATEDate()DATEY
COMPLAINT_STATUS Varchar2(2)X_COMPLAINT_STATUSY
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_DATEDate()DATE
COMPLAINT_DECISION Varchar2(2)X_COMPLAINT_DECISION
SETTLEMENT_AMOUNT Number(18)AMT12V6
CREATE_DATE Date()DATEY
CREATE_USER Varchar2(30)VARCHAR30Y
CHANGE_DATE Date()DATEY
CHANGE_USER Varchar2(30)VARCHAR30Y

User Fields: Allowed
Audit Logging: Allowed