DISCIPLIN_ACTN

(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: DISCIP_ACT_LNG

  • 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 PURGE_DT Date(10) DATE NOT NULL Purge Date
    5 DESCRLONG Long Character CLOB NOT NULL Long Description
    6 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Default Value: JOB_CURR_EFF_VW.SUPERVISOR_ID

    Prompt Table: PERSON_NAME

    7 GVT_OFFENSE_NR Character(1) VARCHAR2(1) NOT NULL Disciplinary Offense Number
    1=1st Offense
    2=2nd Offense
    3=3rd Offense
    4=4th Offense
    5=5th Offense
    8 FINAL_RESOLUTION Character(3) VARCHAR2(3) NOT NULL Final Resolution

    Prompt Table: RESLTN_TYPE_TBL

    9 RESLTN_COMM Character(254) VARCHAR2(254) NOT NULL Resolution Comments