GP_ABSEA_TK_LV

(SQL View)
 Index Back

Related Lang Abs Takes in SS

Related Language Prompt view used to list absence take elements and take type available for Self Service

SELECT DISTINCT SS.COUNTRY , ELIG.ELIG_GRP , TK.ABS_TYPE_OPTN , SS.PIN_TAKE_NUM , ELIG.EFFDT , PIN.LANGUAGE_CD , PIN.PIN_NM , PIN.DESCR FROM PS_GP_PIN_LANG PIN , PS_GP_PIN PIN1 , PS_GP_ABS_TAKE TK , PS_GP_ABS_SS SS , PS_GP_ELEM_GRP_MBR ELEMM , PS_GP_ELEM_GRP ELEM , PS_GP_ELIG_GRP_MBR ELIGM , PS_GP_ELIG_GRP ELIG , PS_GP_ABS_TYPE TP WHERE PIN.PIN_NUM < 50000000 AND PIN.PIN_NUM = TK.PIN_NUM AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND TK.PIN_NUM = PIN1.PIN_NUM AND %EffdtCheck(GP_ABS_SS, SS,%CurrentDateIn) AND SS.EFF_STATUS = 'A' AND TP.REQUEST_IND = 'Y' AND PIN.PIN_NUM = ELEMM.PIN_ELEM_NUM AND ELEMM.PIN_NUM = ELEM.PIN_NUM AND ELEMM.EFFDT = ELEM.EFFDT AND %EffdtCheck(GP_ELEM_GRP, ELEM, %CurrentDateIn) AND ELEM.EFF_STATUS = 'A' AND ELEM.PIN_NUM = ELIGM.PIN_ELEM_GRP_NUM AND ELIGM.ELIG_GRP = ELIG.ELIG_GRP AND ELIGM.EFFDT = ELIG.EFFDT AND %EffdtCheck(GP_ABS_TAKE, TK, %CurrentDateIn) AND TK.EFF_STATUS = 'A' AND TP.COUNTRY = PIN1.COUNTRY AND TP.ABS_TYPE_OPTN = TK.ABS_TYPE_OPTN AND %EffdtCheck(GP_ABS_TYPE, TP, %CurrentDateIn)

  • Related Language Record for GP_ABSEA_TK_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 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    5 EFFDT Date(10) DATE Effective Date
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description