| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 5 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 6 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 7 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 8 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 9 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 10 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 11 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 12 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 13 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 14 |
EMPLR_TAX_NUM_NLD |
Number(9,0) |
DECIMAL(9) NOT NULL |
Federal Employer Tax ID
|
| 15 |
GPNL_SOC_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security Number
|
| 16 |
GPNL_ZFW_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
ZFW Contribution Method
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No Employee/Employer
04=Private Health Insurance
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|
| 20 |
GPNL_TAX_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Table
0=No Tax
1=White Tax Table
2=Green Tax Table
|
| 21 |
GPNL_TAX_PERIOD |
Character(5) |
VARCHAR2(5) NOT NULL |
The tax period represents the compensation frequency used for applying the tax tables, e.g. monthly, weekly or daily.
|
| 22 |
GPNL_TAX_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credits
|
| 23 |
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
|
| 24 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
|
| 25 |
GPNL_SPCL_RT_TAX |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Percentage Special Adjustment
|
| 26 |
GPNL_SPCL_RT_DT |
Date(10) |
DATE |
Date Authorization for Percentage Special Tax Rate
|
| 27 |
GPNL_ANONYM_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous Rate
|
| 28 |
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
|
| 29 |
GPNL_COM_ALLOW |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Commute Allowance
|
| 30 |
GPNL_BSREG |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Regular
|
| 31 |
GPNL_BSNRG |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Non Regular
|
| 32 |
GPNL_SALARY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Salary
|
| 33 |
GPNL_INCOME |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Income
|
| 34 |
GPNL_INCOME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Income Code
|
| 35 |
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
|
| 36 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 37 |
GPNL_ZVW_CNTR_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
ZVW Contribution Method
00=No Premium
01=Employee/Total
02=No Employee/Total
03=No Employee/Employer
Default Value: 00
|
| 38 |
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
|
| 39 |
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)
|
| 40 |
GPNL_VAC_PAYM_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Declaration: Vacation Payment
|
| 41 |
GPNL_VAC_PAYM_ENT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Decalartion: Vacation Entitlement
|
| 42 |
GPNL_ADD_PAYM_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
An additional payment for the employee, like a 13th month payment
|
| 43 |
GPNL_ADD_PAYM_ENT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wag Tax Declaration: Additional Entitlement
|
| 44 |
GPNL_OVERTIME_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Declaration.
|
| 45 |
GPNL_NBR_HOURS |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Number of Hours
|
| 46 |
GPNL_CAR_TAX_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Taxable amount for the private use of a company car
|
| 47 |
GPNL_CAR_EE_DED |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Employee Contribution for private use of company car
|
| 48 |
GPNL_CHILDCARE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
The taxable amount for the employee due to childcare provided by the employer
|
| 49 |
GPNL_LIFECYCLE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
The amount that is saved for an employee under the Life Cycle Arrangement. This can be based on an employee- and an employer contribution
|
| 50 |
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
|
| 51 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 52 |
GPNL_SUPPL_AMT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Amount of paid allowance on top of a paid disability allowance.
|
| 53 |
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
Default Value: 0
|
| 54 |
GPNL_PREP_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
NLD Pre-Pension Reduction
A=Eligible/Applied
E=Eligible/Not Applied
N=Not Applicable
|