P 2 K_LR_GRIEVANCES
Back to current versionRestore this version

Alias:LGV#

Unique Keys:
Child Table:
Parent Table

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYLink to P2K_CM_ENTITIES
DUN_IDNumber(10)IDYLink to P2K_CM_UNITS
LDT_IDNumber(10)IDYLink to P2K_LR_DISPUTE_TYPES
LGR_IDNumber(10)IDYLink to P2K_LR_GRIEVANCE_RULES
DLN_IDNumber(10)ID Link to P2K_CM_LOCATIONS
LDI_IDNumber(10)ID Link to P2K_LR_DISCIPLINARY_ISSUES
DDP_IDNumber(10)ID Link to P2K_CM_DEPARTMENTS
EID_IDNumber(10)ID Link to 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

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