GP_ABSEA_TYP_LV

(SQL View)
 Index Back

Related Lang Ext Abs Types

Related Language Prompt view used to list extended absence take types .

SELECT DISTINCT SS.COUNTRY , ELIG.ELIG_GRP , T.ABS_TYPE_OPTN , SS.PIN_TAKE_NUM , ELIG.EFFDT , TL.LANGUAGE_CD , TL.DESCR FROM PS_GP_ABS_TAKE TK , PS_GP_PIN PIN , 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 T , PS_GP_ABS_TP_LANG TL WHERE TK.PIN_NUM < 50000000 AND TK.PIN_NUM = SS.PIN_TAKE_NUM AND TK.PIN_NUM = PIN.PIN_NUM AND %EffdtCheck(GP_ABS_SS, SS, %CurrentDateIn) AND SS.EFF_STATUS = 'A' AND TK.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 T.EFF_STATUS = 'A' AND T.REQUEST_IND = 'Y' AND T.ABS_TYPE_OPTN = TK.ABS_TYPE_OPTN AND T.COUNTRY = PIN.COUNTRY AND T.ABS_TYPE_OPTN = TL.ABS_TYPE_OPTN AND T.USED_BY = TL.USED_BY AND T.COUNTRY = TL.COUNTRY AND T.ABS_TYPE_OPTN = TL.ABS_TYPE_OPTN AND T.EFFDT = TL.EFFDT AND %EffdtCheck(GP_ABS_TYPE, T, %CurrentDateIn)

  • Related Language Record for GP_ABSEA_TYP_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

    Default Value: %date

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description