P 2 K_LR_COMPLAINTS

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

Derived Fields#

Column Name
DRV_PARTICIPANTS_LIST

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation