GPDE_SI_PEN_VW

(SQL View)
 Index Back

Prompt Pension Status

Prompt Pension Status

SELECT A.GPDE_SI_STATUS %Concat C.GPDE_SI_STATUS %Concat D.GPDE_SI_STATUS %Concat B.GPDE_SI_STATUS , A.GPDE_SI_PENS_APPLI , X.XLATLONGNAME FROM PS_GPDE_SI_PEN_CHK A , PS_GPDE_SI_PEN_CHK B , PS_GPDE_SI_PEN_CHK C , PS_GPDE_SI_PEN_CHK D , PSXLATITEM X WHERE A.GPDE_SI_TYPE = '01' AND B.GPDE_SI_TYPE = '02' AND C.GPDE_SI_TYPE = '03' AND D.GPDE_SI_TYPE = '04' AND B.GPDE_SI_PENS_APPLI = A.GPDE_SI_PENS_APPLI AND C.GPDE_SI_PENS_APPLI = A.GPDE_SI_PENS_APPLI AND D.GPDE_SI_PENS_APPLI = A.GPDE_SI_PENS_APPLI AND X.FIELDVALUE = A.GPDE_SI_PENS_APPLI AND X.FIELDNAME = 'GPDE_SI_PENS_APPLI'

  • Related Language Record: GPDE_SI_PEN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPDE_DV_SV_CODE Character(4) VARCHAR2(4) NOT NULL DEUEV Contribution Group Code
    2 GPDE_SI_PENS_APPLI Character(1) VARCHAR2(1) NOT NULL Pension Type
    0=No Pension Applic'n/Payments
    1=Pension Application
    2=Partial Disability Pension
    3=General Disability Pension
    4=Retirement Pension
    5=Old Age Part Time Pension
    6=Widow/Orphan Pension
    7=Educational Pension
    8=Miners' Pension
    9=Farmers' Retirement Pension

    Default Value: 0

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description