GPNL_ESTAB_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPNL_SOC_NUM	Character(20)	VARCHAR2(20) NOT NULL	Social Security Number
4	GPNL_S_INS_GRP	Character(3)	VARCHAR2(3) NOT NULL	Social Insurance Group Prompt Table: GPNL_S_INSGP_VW Set Control Field: GPNL_INS_GRP
5	GPNL_A_INS_GRP	Character(3)	VARCHAR2(3) NOT NULL	GPNL Additional Insurance Group Prompt Table: GPNL_A_INSGP_VW Set Control Field: GPNL_INS_GRP
6	GPNL_BS_SOC_D	Character(1)	VARCHAR2(1) NOT NULL	GPNL_BS_SOCS_D 1=Average Days 2=Calendar Days Default Value: 2
7	GPNL_CUM_CLC_MTH	Character(1)	VARCHAR2(1) NOT NULL	GPNL_CUM_CLC_MTH 1=Non Cumulative 2=Cumulative Default Value: 2
8	GPNL_CNPY_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	GPNL_CNPY_PCT Default Value: 100
9	GPNL_WAIT_DAYS	Number(2,0)	SMALLINT NOT NULL	Waiting Days
10	GPNL_CNPY_PCT_W_D	Number(6,2)	DECIMAL(5,2) NOT NULL	GPNL_CNPY_PCT
11	GPNL_VAC_DAYS	Number(7,2)	DECIMAL(6,2) NOT NULL	GPNL_VAC_DAYS
12	GPNL_ABS_VAC_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency. D=Days H=Hours Default Value: D
13	GPNL_RED_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	This field is used for the Netherlands to track Reduced Hours, known as 'ADV' hours.
14	GPNL_ABS_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Frequency. D=Days H=Hours Default Value: H
15	GPNL_CBS_IDENT	Character(12)	VARCHAR2(12) NOT NULL	CBS Identification Number. Identification/Registration Code, delivred by a given administration services.
16	GPNL_CBS_CAO_CD	Character(6)	VARCHAR2(6) NOT NULL	CBS CAO Code. Labour Agreement Code, delivered by a given administration services.
17	GPNL_CNPY_PCT2	Number(6,2)	DECIMAL(5,2) NOT NULL	Continuous Payment Percentage 2, used for the Dutch payroll for assigning the payment percentage for the 2nd year of illness Default Value: 70