| # |
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 |
CBS CAO Code.
Labour Agreement Code, delivered by a given administration services.
|
| 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
|