Alias:LDA#

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
IDNumber(10)IDY
LDI_IDNumber(10)IDYLink to P2K_LR_DISCIPLINARY_ISSUES
EAS_IDNumber(10)ID Link to 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>VARCHARnn
EMPLOYER_STATEMENTVarchar2(4000)VARCHAR4000>VARCHARnn
NEXT_ACTIVITY_DATEDate()DATE
NEXT_ACTIVITY_TEXTVarchar2(4000)VARCHAR4000>VARCHARnn
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30>VARCHARnn
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30>VARCHARnn

User Fields: Allowed
Audit Logging: Allowed
User Fields: Allowed
Audit Logging: Allowed