GP_ABSHISTSS_LV

(SQL View)
 Index Back

Self Service Absence Hist Inqu

Self Service Absence History outer join with workflow status

SELECT DAT.TRANSACTION_NBR , DAT.EMPLID , DAT.EMPL_RCD , DAT.BGN_DT , DAT.PIN_TAKE_NUM , DAT.END_DT , PIN.LANGUAGE_CD , PIN.DESCR FROM PS_GP_ABS_SS_DAT DAT , PS_GP_ABS_EVENT AE , PS_GP_PIN_LANG PIN , PS_GP_ABS_SS SS WHERE AE.TRANSACTION_NBR = DAT.TRANSACTION_NBR AND AE.EMPLID = DAT.EMPLID AND AE.EMPL_RCD = DAT.EMPL_RCD AND AE.BGN_DT = DAT.ORIG_BEGIN_DT AND AE.PIN_TAKE_NUM = DAT.ORIG_PIN_TAKE_NUM AND AE.END_DT = DAT.ORIG_END_DT AND SS.COUNTRY = DAT.COUNTRY AND SS.PIN_TAKE_NUM = DAT.ORIG_PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, SS, %CurrentDateIn) AND PIN.PIN_NUM = DAT.ORIG_PIN_TAKE_NUM

  • Related Language Record for GP_ABSHISTSS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 BGN_DT Date(10) DATE NOT NULL Begin Date
    5 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

    Prompt Table: GP_PIN_ABSTK_VW

    6 END_DT Date(10) DATE NOT NULL end date
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description