| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPNL_WD_MSG_ID |
Character(32) |
VARCHAR2(32) NOT NULL |
WALVIS
|
| 2 |
GPNL_EMPLR_TAX_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Unique ID for the Employer assigned within the Wage Declaration, composed out of the Employer Tax Number + Suffix (e.g. "L01")
|
| 3 |
PRD_BGN_DT |
Date(10) |
DATE NOT NULL |
Period Begin Date
|
| 4 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 5 |
GPNL_WD_EMPL_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
Wage Tax Declaration Employment ID.
|
| 6 |
BEGIN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
|
| 7 |
GPNL_INCOME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Income Code
|
| 8 |
GPNL_EMPL_CLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Employee Classification, with values used for the Wage Declaration, to determine the appropriate social insurances.
This field is associated to the EMPL_CLASS field used in HR, but has the exact codes used for the reporting.
1=Employment Contract
10=Social Employment Worker
11=Agency/Temp
12=Temporary Hire
13=Government Worker
14=Top Sportsman
17=Early Retirement
18=Public Assignment
19=Termination Payment
2=Contractor
3=Director Cooperative Society
4=Parttime Fisherman
5=Draftee
5=Draftee
6=Musician/Artist
7=Trainee
78=Independent Worker
79=Freelance Worker
8=Homeworker
80=Sex Worker with Fictitious Emp
9=Salesman
|
| 9 |
GPNL_INS_EXCEP_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Insurance Exception code used to identify exceptional criteria that influence the insurance for the social insurances.
Used for the Wage Declaration:
CdInvlVpl - Code invloed verzekeringsplicht
A=Family of Owner
B=Previous Owner
C=Director/Shareholder
D=Standby EE without Obligation
E=Standby EE with Obligation
F=Premium waiver Small-jobs
F=Premium waiver Small-jobs
|
| 10 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 11 |
GPNL_REGULAR_WORK |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator for a Regular Work Schedule
|
| 12 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 13 |
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)
|
| 14 |
GPNL_HANDICAP_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
Code to indicate whether a reduction due to a handicap may be applied.
0=Not Applicable
1=New Hire Young-handicapped
1=New Hire Young-handicapped
2=Replacement Young-handicapped
2=Replacement Young-handicapped
3=New Hire Handicapped
3=New Hire Handicapped
4=Replacement Handicapped
4=Replacement Handicapped
5=Handicapped
6=New Hire 50+ out of Welfare
7=Age of 62, 63 or 64
7=Age of 62, 63 or 64
8=New Hire 50+ with Handicap
8=New Hire 50+ with Handicap
9=Age of 62-64 with Handicap
9=Age of 62-64 with Handicap
A=Handicap with Dispensation
B=New Hire <27 out of Welfare
|
| 15 |
GPNL_ELDR_EMP_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
Premium Elderly employment Indicator
|
| 16 |
GPNL_ELDR_HIR_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
Premium Hire Elderly employment indicator
|
| 17 |
GPNL_CAR_NO_TAX_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for not having a fiscal contribution for a company car.
1=Employer Arrangement
2=Personal Arrangement
3=Other Evidence
4=Company Van no Private Use
4=Company Van no Private Use
5=Alternately use Company Van
6=0% Tax on Car w/o CO2 Emission
7=Exclusive Business use Van
|
| 18 |
GPNL_TAX_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credits
|
| 19 |
GPNL_PREP_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
NLD Pre-Pension Reduction
A=Eligible/Applied
E=Eligible/Not Applied
N=Not Applicable
|
| 20 |
GPNL_TRAVEL_DATA |
Character(2) |
VARCHAR2(2) NOT NULL |
Travel Data
00=N/A
01=Company Car or Van
02=Arrangement Tax Authority
03=Employer Transportation
04=Travel Allowance for Commute
04=Travel Allowance
05=Carpool Rules Applicable
05=Carpool Rules Applicable
06=Private Use Company Van 10%
06=Private Use Company Van 10%
07=Private Use Company Van 2.5%
07=Private Use Company Van 2.5%
08=Special Tax Company Van
08=Special Tax Company Van
|
| 21 |
GPNL_TAX_EXCEPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Exception Tax
000=No Exception Rules
003=NI Premiums/No Tax
005=Tax/No NI Premiums
006=Tax/Premiums for AOW-ANW
007=Tax/Premium AWBZ
226=No Tax/Premium AWBZ
227=No Tax/Premium ANW
228=No Tax /Premium AOW-ANW
|
| 22 |
GPNL_TAX_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Table
0=No Tax
1=White Tax Table
2=Green Tax Table
|
| 23 |
GPNL_TAX_EXCEP_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Exceptional situations that influence the taxation and need to be reported within the Wage Declaration.
210=Contractor or Homeworker
220=National Artist/Sportsman
221=Foreign Artist/Sportsman Red
224=Foreign Artists/Sportsmen
225=Foreign Artists/Sportsmen Red
250=Allowance Welfare Perc
950=52% Rate due to Negative Costs
|
| 24 |
GPNL_ANONYM_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous Rate
|
| 25 |
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
|
| 26 |
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
|
| 27 |
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
|
| 28 |
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
|
| 29 |
GPNL_SPCL_TAX_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Special Tax Code
|
| 30 |
GPNL_WD_IND_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator used in the Wage Declaration Interface for the Dutch payroll
|
| 31 |
GPNL_WD_IND_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator used in the Wage Declaration Interface for the Dutch payroll
|
| 32 |
GPNL_WD_IND_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator used in the Wage Declaration Interface for the Dutch payroll
|
| 33 |
GPNL_WD_IND_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator used in the Wage Declaration Interface for the Dutch payroll
|
| 34 |
GPNL_INC_RED_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Incidental Income Reduction Code
B=Maternity Leave
B=Maternity Leave
O=Unpaid Leave of Absence
Z=Illness
|
| 35 |
GPNL_ALLOW_SUPPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indication for a Supplement on an Allowance being included in the compensation.
Y/N Table Edit
Default Value: N
|
| 36 |
GPNL_WAO_PMA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Marginal Employment Indicator
Default Value: N
|