GPNL_EE_SOC_INS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	GPNL_DFLT_INS_GRP	Character(1)	VARCHAR2(1) NOT NULL	GPNL_S_OVR 0=No 1=Yes Default Value: 0
6	GPNL_S_INS_GRP	Character(3)	VARCHAR2(3) NOT NULL	Social Insurance Group Prompt Table: GPNL_S_INSGP_VW
7	GPNL_ZW_CNTR_MTHD	Character(2)	VARCHAR2(2) NOT NULL	GPNL_ZW_CNTR_MTHD 00=No Premium 01=Employee/Total 02=No Employee/Total 03=No EE/Employer Default Value: 01
8	GPNL_WAO_CNTR_MTHD	Character(2)	VARCHAR2(2) NOT NULL	GPNL_WAO_CNTR_MTHD 00=No Premium 01=Employee/Total 02=No Employee/Total 03=No Employee/ Employer Default Value: 01
9	GPNL_WW_CNTR_MTHD	Character(2)	VARCHAR2(2) NOT NULL	GPNL_WW_CNTR_MTHD 00=No Premium 01=Employee/Total 02=No Employee/Total 03=No Employee / Employer Default Value: 01
10	GPNL_ZFW_CNTR_MTHD	Character(2)	VARCHAR2(2) NOT NULL	ZFW Contribution Method 00=No Premium 01=Employee/Total 02=No Employee/Total 03=No Employee/Employer 04=Private Health Insurance Default Value: 01
11	GPNL_ZVW_CNTR_MTHD	Character(2)	VARCHAR2(2) NOT NULL	ZVW Contribution Method 00=No Premium 01=Employee/Total 02=No Employee/Total 03=No Employee/Employer Default Value: 01
12	GPNL_ZVW_CD	Character(1)	VARCHAR2(1) NOT NULL	Insurance Code for the ZVW A=Not Insured, No AWBZ B=Not Insured, Military Service C=Insured, Regular Rate D=Insured, Exception Sea-going E=Insured, Non-Regular Rate F=Insured, Multiple Rates J=Insured, Small-job Rule J=Insured, Small-job Rule Default Value: C
13	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_NHS_VW
15	GPNL_REGISTR_NUM	Character(20)	VARCHAR2(20) NOT NULL	Registration Number
16	GPNL_YEAR_END_CD	Character(2)	VARCHAR2(2) NOT NULL	Year End Reporting Code 01=Vouchers < 20 holidays 02=Vouchers for 20 or more 11=Shareholders not insured 20=Main Profession no Artist 25=WAO for all social insurances 26=WAO for WW,ZW & WAO 30=Prepensioners 35=Offic w/salary below max wage 36=On reduced pay, ZFW insured 60=Welfare payment 70=Tip-off Money