| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
NL_TAX_EXCEPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception Tax
0=No Exception
1=Long Term Unemployment
1=Long Term Unemployment
2=No Employer Adjustment
2=No Employer Adjustment
3=Low Tax Rate/No Employer Adj
3=Low Tax Rate/No Employer Adj
A=No Tax/Premium Ded
B=Tax/No Premium Ded
C=Tax/Just AOW, ANW
D=Tax/Just AWBZ
E=No Tax/AOW, ANW
F=No Tax/AWBZ
K=No Tax/ANW
Default Value: 0
|
| 4 |
NL_TAX_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Table Type
0=No Tax
1=White Tax Table
2=Green Tax Table
Default Value: 1
|
| 5 |
NL_TAX_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Category
0=Tax Category 0
1=Tax Category 1
2=Tax Category 2
3=Tax Category 3
4=Tax Category 4
5=Tax Category 5
Default Value: 2
|
| 6 |
NL_SPCL_RT_OT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Percentage Special Adjustment
|
| 7 |
NL_SPCL_RT_TAX |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Percentage Special Tax Rate
|
| 8 |
NL_TAX_YR_EARNINGS |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Taxable Income
|
| 9 |
NL_TAX_TRAVEL_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Travel Data
0=N/A
1=Company Car
2=Carpooling
3=Employer Transport
Default Value: 0
|
| 10 |
CAR_NO_TAX_CD_NLD |
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
|
| 11 |
SAVINGS_PLAN_NLD |
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
|
| 12 |
EMPLR_TAX_RED_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
The employer could be eligible for a tax reduction, when making costs for the employees with a specific purpose.
1=Education - Common
5=Education - Qualification
7=Education - Trainee
8=Education - Competencies
|
| 13 |
NL_ANONYMOUS_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous Rate
Y/N Table Edit
Default Value: N
|
| 14 |
TAX_CREDITS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credits
Y/N Table Edit
Default Value: Y
|
| 15 |
RULE_30_PERC_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
30% Ruling
Y/N Table Edit
Default Value: N
|