GPDE_SI_RVPR2VW (SQL View)	Index Back
SI Prov for Voluntary Pens Ins SI Providers that can be selected for EE Pension Insurance if the coverage type is voluntary. As yet these are only the ones for Doctors and Architects (Provider Type 08).

GPDE_SI_RVPR2VW

(SQL View)

SI Prov for Voluntary Pens Ins

SI Providers that can be selected for EE Pension Insurance if the coverage type is voluntary. As yet these are only the ones for Doctors and Architects (Provider Type 08).

SELECT GPDE_SI_PROV , EFFDT , EFF_STATUS , DESCR FROM PS_GPDE_SI_PROV WHERE GPDE_AL_PROV_TYPE = '08'

Related Language Record: GPDE_SI_RVP2LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_SI_PROV Character(8) VARCHAR2(8) NOT NULL Social Insurance Provider

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

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_SI_PROV	Character(8)	VARCHAR2(8) NOT NULL	Social Insurance Provider
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description