DISCIP_ACT_LNG

(SQL Table)
Index Back

EE Disciplinary Actions

Use DISCIPLIN_ACTN to record high-level data about disciplinary actions taken against an employee. The detailed disciplinary steps are recorded in a subordinate record named DISCIPLIN_STEP. You can create more than one DISCIPLIN_ACTN record for an employee.

  • Related Language Record for DISCIPLIN_ACTN
  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 DISCIPLINE_DT Date(10) DATE NOT NULL Reported Date

    Default Value: %date

    3 DISCIPLINARY_TYPE Character(3) VARCHAR2(3) NOT NULL Disciplinary Type

    Prompt Table: DISCIP_TYPE_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRLONG Long Character CLOB NOT NULL Long Description
    6 RESLTN_COMM Character(254) VARCHAR2(254) NOT NULL Resolution Comments