GP_ABS_TYPE2_LV

(SQL View)
 Index Back

Langview for GP_ABS_TYPE2_VW

Search view that returns Country specific or Country ALL absence types

SELECT C.COUNTRY , TK.ABS_TYPE_OPTN , LANG.LANGUAGE_CD , TK.EFFDT , LANG.DESCR FROM PS_GP_ABS_TYPE TK , PS_GP_ABS_TP_LANG LANG , PS_GP_COUNTRY C WHERE (TK.USED_BY = 'A' OR TK.COUNTRY = C.COUNTRY) AND TK.USED_BY = LANG.USED_BY AND TK.COUNTRY = LANG.COUNTRY AND TK.ABS_TYPE_OPTN = LANG.ABS_TYPE_OPTN AND TK.EFFDT = LANG.EFFDT

  • Related Language Record for GPAU_AB_TYPE_VW GP_ABS_TYPE2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY

    2 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description