GPDE_SI_RVP2LNG (SQL View)	Index Back
SI Prov for Voluntary Pens Ins Related Language Record for 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_RVP2LNG

(SQL View)

SI Prov for Voluntary Pens Ins

Related Language Record for 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 A.GPDE_SI_PROV , B.LANGUAGE_CD , A.EFFDT , B.DESCR FROM PS_GPDE_SI_RVPR2VW A , PS_GPDE_SI_PRO_LNG B WHERE B.GPDE_SI_PROV = A.GPDE_SI_PROV AND B.EFFDT = A.EFFDT

Related Language Record for GPDE_SI_RVPR2VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description