GPDE_SI_PN_K2VW (SQL View)	Index Back
Validation Pension Status SI Data Check

GPDE_SI_PN_K2VW

(SQL View)

Validation Pension Status

SI Data Check

SELECT DISTINCT GPDE_SI_PENS_APPLI , GPDE_SI_TYPE 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

2 GPDE_SI_TYPE Character(2) VARCHAR2(2) NOT NULL SI Coverage Type
01=Health Insurance
02=Nursing Care Insurance
03=Old Age Pension Insurance
04=Unemployment Insurance

#	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
2	GPDE_SI_TYPE	Character(2)	VARCHAR2(2) NOT NULL	SI Coverage Type 01=Health Insurance 02=Nursing Care Insurance 03=Old Age Pension Insurance 04=Unemployment Insurance