GPBR_SEF_TKE_VW

(SQL View)
 Index Back

SEFIP Take view

SEFIP Take view

SELECT DISTINCT F.PIN_NM , B.PIN_NUM , B.DESCR , E.ABSENCE_REASON , E.DESCR , A.ABS_TYPE_OPTN , D.DESCR FROM PS_GP_ABS_TAKE A , PS_GP_ABSTAKE_SRCH B , PS_GP_ABS_REASON E , PS_GP_ABS_TYPE D , PS_GP_PIN F WHERE A.PIN_NUM = B.PIN_NUM AND F.PIN_NUM = A.PIN_NUM AND A.ABS_TYPE_OPTN = E.ABS_TYPE_OPTN AND A.ABS_TYPE_OPTN = D.ABS_TYPE_OPTN AND (B.COUNTRY = 'BRA' OR B.COUNTRY = 'BRA') AND E.COUNTRY = B.COUNTRY AND D.COUNTRY = B.COUNTRY AND A.EFFDT IN ( SELECT MAX(F.EFFDT) FROM PS_GP_ABS_TAKE F WHERE F.PIN_NUM = A.PIN_NUM) AND E.EFFDT IN ( SELECT MAX(G.EFFDT) FROM PS_GP_ABS_REASON G WHERE G.ABS_TYPE_OPTN = E.ABS_TYPE_OPTN AND (G.COUNTRY = 'BRA' OR G.COUNTRY = 'BRA'))

  • Related Language Record: GPBR_STK_VW_LNG

  • Parent Record Of GPBR_SEFIP_ABSP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    2 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    3 GPBR_ABS_TAKE_DESC Character(30) VARCHAR2(30) NOT NULL Absence Take Description used to display a descriptive label.
    4 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    10=Vacations
    5 GPBR_ABS_RSN_DESC Character(30) VARCHAR2(30) NOT NULL Absence Reason Description used to display a descriptive label.
    6 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    7 GPBR_ABS_TYPE_DESC Character(30) VARCHAR2(30) NOT NULL Absence Type Description used to display a descriptive label.