GPBR_STK_VW_LNG

(SQL View)
 Index Back

SEFIP Take language view

SEFIP Absence take language view

SELECT DISTINCT F.PIN_NM , B.PIN_NUM , E.LANGUAGE_CD , F.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_RSN_LANG E , PS_GP_ABS_TP_LANG D , PS_GP_PIN_LANG 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 E.LANGUAGE_CD = D.LANGUAGE_CD 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 for GPBR_SEF_TKE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GPBR_ABS_TAKE_DESC Character(30) VARCHAR2(30) NOT NULL Absence Take Description used to display a descriptive label.
    5 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    10=Vacations
    6 GPBR_ABS_RSN_DESC Character(30) VARCHAR2(30) NOT NULL Absence Reason Description used to display a descriptive label.
    7 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    8 GPBR_ABS_TYPE_DESC Character(30) VARCHAR2(30) NOT NULL Absence Type Description used to display a descriptive label.