P 2 K_LR_GRIEVANCES

Alias:LGV#

(P2K_LR_GRIEVANCES)

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


This table identifies each grievance.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYFor P2K_CM_ENTITIES
DUN_IDNumber(10)IDYFor P2K_CM_UNITS
LDT_IDNumber(10)IDYFor P2K_LR_DISPUTE_TYPES
LGR_IDNumber(10)IDYFor P2K_LR_GRIEVANCE_RULES
DLN_IDNumber(10)ID About P2K_CM_LOCATIONS
LDI_IDNumber(10)ID Results in P2K_LR_DISCIPLINARY_ISSUES
DDP_IDNumber(10)ID About P2K_CM_DEPARTMENTS
EID_IDNumber(10)ID About P2K_HR_IDENTITIES
GRIEVANCE_CODEVarchar2(16)CODEY
GRIEVANCE_ISSUED_DATEDate()DATEY
GRIEVANCE_STATUSVarchar2(2)X_GRIEVANCE_STATUSY
GRIEVANCE_STAGEVarchar2(2)X_GRIEVANCE_STAGE
GRIEVANCE_SEVERITYVarchar2(2)X_GRIEVANCE_SEVERITY
DATE_OF_INCIDENTDate()DATE
INCIDENT_WITNESSESVarchar2(4000)VARCHAR4000
APPROVEDVarchar2(1)TOGGLE
DESCRIPTIONVarchar2(50)DESCRIPTION
GRIEVANCE_TEXTVarchar2(4000)VARCHAR4000
CONTRACT_REFERENCEVarchar2(4000)VARCHAR4000
UNION_REFERENCEVarchar2(4000)VARCHAR4000
GRIEVANCE_CLOSED_DATEDate()DATE
GRIEVANCE_DECISIONVarchar2(2)X_COMPLAINT_DECISION
SETTLEMENT_AMOUNTNumber(18)AMT12V6
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(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