HGA_EA_ABTYP_VW

(SQL View)
Index Back

Absence Type View

Absence Type View used for Fluid Extended Absence

SELECT DISTINCT A.PIN_NUM ,A.DESCR ,T.ABS_TYPE_OPTN ,T.DESCR ,'' FROM PS_GP_PIN A ,PS_GP_ABS_TAKE B ,PS_GP_ABS_TYPE T WHERE A.PIN_NUM=B.PIN_NUM AND A.USED_BY=T.USED_BY AND A.COUNTRY=T.COUNTRY AND B.ABS_TYPE_OPTN=T.ABS_TYPE_OPTN AND T.REQUEST_IND = 'Y' AND %EffdtCheck(GP_ABS_TAKE, B, %CurrentDateIn) AND T.EFF_STATUS = 'A'

  • Related Language Record: HGA_EA_ABTYP_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    2 ABS_NAME Character(40) VARCHAR2(40) NOT NULL Absence Name
    3 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr