GPNL_ESTAB_TBL (SQL Table)	Index Back
Establishment Table NLD Setup of the Establishment table with payroll specific data for the Netherlands

GPNL_ESTAB_TBL

(SQL Table)

Establishment Table NLD

Setup of the Establishment table with payroll specific data for the Netherlands

Parent record: 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 CAO Code "Collective Labour Agreement Code" The code is a 4 Numeric value. The list of valid codes is published by the Ministry of Social Affairs and Employment. The code is included within the Wage Declaration and used by the UWV (Social Security) and CBS (Bureau of Statistics)

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

#	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	CAO Code "Collective Labour Agreement Code" The code is a 4 Numeric value. The list of valid codes is published by the Ministry of Social Affairs and Employment. The code is included within the Wage Declaration and used by the UWV (Social Security) and CBS (Bureau of Statistics)
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