GP_AAT0_SS_LV

(SQL View)
 Index Back

Absence Takes in SS (LangVw)

Language view of prompt view used to list absence take elements available for Self Service

SELECT DISTINCT SS.COUNTRY , E.ELIG_GRP , SS.PIN_TAKE_NUM , LANG.LANGUAGE_CD , E.EFFDT , LANG.PIN_NM , LANG.DESCR FROM PS_GP_PIN PIN , PS_GP_PIN_LANG LANG , PS_GP_ABS_TAKE TK , PS_GP_ABS_SS SS , PS_GP_ELEM_GRP_MBR EGM , PS_GP_ELEM_GRP EG , PS_GP_ELIG_GRP_MBR EM , PS_GP_ELIG_GRP E WHERE PIN.PIN_NUM < 50000000 AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND PIN.PIN_NUM = LANG.PIN_NUM AND SS.REQUEST_IND = 'Y' AND PIN.PIN_NUM = EGM.PIN_ELEM_NUM AND EGM.PIN_NUM = EG.PIN_NUM AND EGM.EFFDT = EG.EFFDT AND %EffdtCheck(GP_ELEM_GRP, EG, %CurrentDateIn) AND EG.EFF_STATUS = 'A' AND EG.PIN_NUM = EM.PIN_ELEM_GRP_NUM AND EM.ELIG_GRP = E.ELIG_GRP AND EM.EFFDT = E.EFFDT AND PIN.PIN_NUM = TK.PIN_NUM AND %EffdtCheck(GP_ABS_TAKE, TK, %CurrentDateIn) AND TK.EFF_STATUS = 'A' AND SS.EFF_STATUS = 'A' AND %EffdtCheck(GP_ABS_SS, SS, %CurrentDateIn)

  • Related Language Record for GP_AAT0_SS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE Effective Date
    6 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description