GPDE_SI_RT04_VW (SQL View)	Index Back
SI Rates Unemployment SI Rates Unemployment

GPDE_SI_RT04_VW

(SQL View)

SI Rates Unemployment

SELECT DISTINCT EFFDT , GPDE_SI_REGION , GPDE_SI_MINER , GPDE_SI_TYPE FROM PS_GPDE_SI_RATES WHERE GPDE_SI_TYPE = '04'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 GPDE_SI_REGION Character(1) VARCHAR2(1) NOT NULL Region
0=General
1=East
2=West

3 GPDE_SI_MINER Character(1) VARCHAR2(1) NOT NULL Miners' Social Insurance
G=Not Applicable
N=No
Y=Yes
Default Value: G

4 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
Default Value: 04

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	GPDE_SI_REGION	Character(1)	VARCHAR2(1) NOT NULL	Region 0=General 1=East 2=West
3	GPDE_SI_MINER	Character(1)	VARCHAR2(1) NOT NULL	Miners' Social Insurance G=Not Applicable N=No Y=Yes Default Value: G
4	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 Default Value: 04