P 2 K_LR_DISCIPLINARY_ACTIVITIES
Back to current versionRestore this version

Alias:LDA#

Unique Keys: None
Parent Table: P2K_LR_DISCIPLINARY_ISSUES

This table contains information on activities related to each disciplinary issue.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
LDI_IDNumber(10)IDYPart of P2K_LR_DISCIPLINARY_ISSUES
EAS_IDNumber(10)ID Reviewed by P2K_HR_ASSIGNMENTS
DISCIPLINARY_ACTIVITY_DATEDate()DATEY
DISCIPLINARY_ACTIVITY_STATUSVarchar2(2)X_DISCIPLINARY_ACTIVITY_STATUSY
DISCIPLINARY_DECISIONVarchar2(2)X_DISCIPLINARY_DECISION
DECISION_ACTION_DATEDate()DATE
DESCRIPTIONVarchar2(50)DESCRIPTION
EMPLOYEE_STATEMENTVarchar2(4000)VARCHAR4000
EMPLOYER_STATEMENTVarchar2(4000)VARCHAR4000
NEXT_ACTIVITY_DATEDate()DATE
NEXT_ACTIVITY_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30

User Fields: Allowed
Audit Logging: Allowed