GPDE_SI_PROV_ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_SI_PROV_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
2	GPDE_SI_ORG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Organisation Type 01=SI Insurance Provider 02=Receiver Institute 03=Forwarding Institute 04=Pension Fund Provider 05=Pension Fund Receiver
3	EFFDT	Date(10)	DATE	Effective Date
4	GPDE_SI_PROV_ID_SU	Character(8)	VARCHAR2(8) NOT NULL	Provider ID Sucuessor Institution
5	EXPIRATN_DT	Date(10)	DATE	Expiration Date
6	GPDE_DV_RCVER_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
7	GPDE_DV_FWD_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
8	GPDE_DV_DEC_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID of decoding institution for DEUEV reports
9	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
10	DESCR100_GER	Character(100)	VARCHAR2(100) NOT NULL	Description 100 Characters
11	DESCR100_2_GER	Character(100)	VARCHAR2(100) NOT NULL	Description 100 Characters
12	DESCR100_3_GER	Character(100)	VARCHAR2(100) NOT NULL	Description 100 Characters
13	ADDRESS100	Character(100)	VARCHAR2(100) NOT NULL	Address 1
14	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
15	CITY50	Character(50)	VARCHAR2(50) NOT NULL	City
16	ADDRESS100_OTHER	Character(100)	VARCHAR2(100) NOT NULL	Address
17	POSTAL_OTHER	Character(12)	VARCHAR2(12) NOT NULL	Postal Other
18	CITY50_OTHER	Character(50)	VARCHAR2(50) NOT NULL	City
19	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
20	GPDE_SI_FTAM_ID	Character(50)	VARCHAR2(50) NOT NULL	FTAM Address
21	GPDE_AL_PROV_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Provider Type 00=Private 01=AOK 02=BKK 03=IKK 04=VDAK 05=Sailors' Fund 06=Miners' Fund 07=LKK 08=Pens Prov for Professional Cls
22	BGN_DT	Date(10)	DATE	Begin Date