P 2 K_LR_DISCIPLINARY_ACTIVITIES
Back to current versionRestore this version

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)(Lexicon)Y
DISCIPLINARY_DECISIONVarchar2(2)(Lexicon)
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
User Fields: Allowed
Audit Logging: Allowed