GPDE_SI_PEN_LNG

(SQL View)
 Index Back

Prompt Pension Status

Prompt Pension Status

SELECT A.GPDE_DV_SV_CODE , A.GPDE_SI_PENS_APPLI , X.LANGUAGE_CD , X.XLATLONGNAME FROM PS_GPDE_SI_PEN_VW A , PSXLATITEMLANG X WHERE X.FIELDVALUE = A.GPDE_SI_PENS_APPLI AND X.FIELDNAME = 'GPDE_SI_PENS_APPLI'

  • Related Language Record for GPDE_SI_PEN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description