GPDE_SI_PN_CKVW

(SQL View)
 Index Back

Validation Pension Status

SI Data Check

SELECT DISTINCT GPDE_SI_PENS_APPLI FROM PS_GPDE_SI_PEN_CHK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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