ABS_TYPE_VW

(SQL View)
Index Back

Absence Type View - BEL

Absence Type View used for Belgium specifc functionality to enable the user to prompt on a previous absence for tracking absence recurrence.

select A.EMPLID ,A.EMPL_RCD ,A.BEGIN_DT ,B.SETID ,A.ABSENCE_TYPE ,B.DESCR from PS_ABSENCE_HIST A ,PS_ABS_TYPE_TBL B where A.ABSENCE_TYPE = B.ABSENCE_TYPE

  • Related Language Record: ABS_TYPVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ORIG_EMPL_RCD_BEL Number(3,0) SMALLINT NOT NULL Employment Record Nbr
    3 ORIG_BEGIN_DT_BEL Date(10) DATE Original Start Date
    4 ORIG_SETID_BEL Character(5) VARCHAR2(5) NOT NULL Original SetID
    5 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description