GPCH_SI_ADD_VW (SQL View)	Index Back
Additional Insurance View Additional Insurance View

GPCH_SI_ADD_VW

(SQL View)

Additional Insurance View

SELECT DISTINCT COMPANY , GPCH_SI_TYPE_ID , EFFDT , GPCH_SI_PROV_TYPE FROM PS_GPCH_SI_ADDTNL2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 GPCH_SI_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Insurance Type ID
010=010-UVG
030=030 UV CureCost
040=040 UV Special Risk
050=050 UV-Daily Pay 80%
060=060 UV Invalidity Fund
061=061 UV Invalidity Fund 100'000
070=070 Death Fund
071=071 Death Fund 10'000
080=080 Health Daily 80%
090=090 Health Base EE
100=100 Health Additional EE
110=110 Health Dependends
999=999 Additional Ins N/A
K00=Health Insurance 00
U00=Add. Accident Insurance 00

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
0=Identify
1=Others
2=UVG-LAA
3=KTG-AMC
4=UVGZ-LAAC
5=FAK-CAF
6=BVG-LPP
7=AHV-AVS
8=LAW-CDS
9=BFS-OFS
A=QST-IS
B=Write File
E=EO-APG
Prompt Table: GPCH_SI_ADDTNL1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	GPCH_SI_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Insurance Type ID 010=010-UVG 030=030 UV CureCost 040=040 UV Special Risk 050=050 UV-Daily Pay 80% 060=060 UV Invalidity Fund 061=061 UV Invalidity Fund 100'000 070=070 Death Fund 071=071 Death Fund 10'000 080=080 Health Daily 80% 090=090 Health Base EE 100=100 Health Additional EE 110=110 Health Dependends 999=999 Additional Ins N/A K00=Health Insurance 00 U00=Add. Accident Insurance 00
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	GPCH_SI_PROV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Provider Type 0=Identify 1=Others 2=UVG-LAA 3=KTG-AMC 4=UVGZ-LAAC 5=FAK-CAF 6=BVG-LPP 7=AHV-AVS 8=LAW-CDS 9=BFS-OFS A=QST-IS B=Write File E=EO-APG Prompt Table: GPCH_SI_ADDTNL1