| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
GPNL_TAX_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Table
0=No Tax
1=White Tax Table
2=Green Tax Table
Default Value: 1
|
| 5 |
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
Default Value: 000
|
| 6 |
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
Default Value: 00
|
| 7 |
GPNL_SPCL_RT_TAX |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Percentage Special Adjustment
|
| 8 |
GPNL_SPCL_RT_DT |
Date(10) |
DATE |
Date Authorization for Percentage Special Tax Rate
|
| 9 |
GPNL_ANONYM_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous Rate
Y/N Table Edit
Default Value: N
|
| 10 |
GPNL_TAX_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credits
Y/N Table Edit
Default Value: Y
|
| 11 |
GPNL_RULE_30 |
Character(1) |
VARCHAR2(1) NOT NULL |
30% Ruling
Y/N Table Edit
Default Value: N
|
| 12 |
GPNL_ADVANTAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Advantage Rule
Y/N Table Edit
|
| 13 |
GPNL_PREP_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
NLD Pre-Pension Reduction
A=Eligible/Applied
E=Eligible/Not Applied
N=Not Applicable
Default Value: N
|
| 14 |
GPNL_HOURS_KND |
Character(1) |
VARCHAR2(1) NOT NULL |
Kind of Hours
1=Standard Hours
2=Real Hours
Default Value: 1
|
| 15 |
GPNL_INCOME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Income Code
Default Value: 15
|
| 16 |
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
|
| 17 |
GPNL_SAVINGS_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Savings plan: Save as You Earn or Life Cycle arrangement.
(Spaarloon / Levensloopregeling)
L=Life Cycle Arrangement
S=Save as You Earn
S=Save as You Earn
|