P 2 K_LR_COMPLAINTS
Back to current versionRestore this version

Alias:LCM#

Unique Keys:
Child Table:
Parent Table: This table contains date sensitive information pertinent to the definition of a unit and other descriptive text

Table Columns#

Column nameData Type / SizeDomainMand.Notes
ID Number(10)IDY
DEN_IDNumber(10)IDYLink to P2K_CM_ENTITIES
DDP_IDNumber(10)ID Link to P2K_CM_DEPARTMENTS
DLN_IDNumber(10)ID Link to P2K_CM_LOCATIONS
LDI_IDNumber(10)ID Link to P2K_LR_DISCIPLINARY_ISSUES
LGV_IDNumber(10)ID Link to P2K_LR_GRIEVANCES
EID_ID Number(10)ID Link to P2K_HR_IDENTITIES
LDT_ID Number(10)ID Link to P2K_LR_DISPUTE_TYPES
DUN_ID Number(10)ID Link to 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_DISPUTE_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

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