GVT_DISP_E_LANG

(SQL Table)
Index Back

EE Disciplinary Action Events

GVT: Use GVT_DISP_EVENT to record the particular events involved in a disciplinary action taken against an employee. The high-level information on a disciplinary action is recorded in the parent record named DISCIPLIN_STEP. You can create more than one GVT_DISP_EVENT record for each disciplinary action taken against an employee. Related Language record for GVT_DISP_EVENT.

  • Related Language Record for GVT_DISP_EVENT
  • Parent record: DISCIPLIN_STEP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 DISCIPLINE_DT Date(10) DATE NOT NULL Reported Date
    3 DISCIPLINARY_TYPE Character(3) VARCHAR2(3) NOT NULL Disciplinary Type
    4 DISCIPLINARY_STEP Character(3) VARCHAR2(3) NOT NULL Disciplinary Step
    5 GVT_DISP_EVNT_NBR Number(3,0) SMALLINT NOT NULL Disciplinary Action Event Nbr
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 COMMENTS Long Character CLOB Comment