| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 5 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 6 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 7 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 8 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 9 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 10 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 11 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 12 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 13 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 14 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 15 |
EMPLR_TAX_NUM_NLD |
Number(9,0) |
DECIMAL(9) NOT NULL |
Federal Employer Tax ID
|
| 16 |
GPNL_SOC_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security Number
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|
| 20 |
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
|
| 21 |
GPNL_TAX_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Table
0=No Tax
1=White Tax Table
2=Green Tax Table
|
| 22 |
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.
|
| 23 |
GPNL_TAX_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Credits
|
| 24 |
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
|
| 25 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
|
| 26 |
GPNL_SPCL_RT_TAX |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Percentage Special Adjustment
|
| 27 |
GPNL_SPCL_RT_DT |
Date(10) |
DATE |
Date Authorization for Percentage Special Tax Rate
|
| 28 |
GPNL_ANONYM_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous Rate
|
| 29 |
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
|
| 30 |
GPNL_COM_ALLOW |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Commute Allowance
|
| 31 |
GPNL_BSREG |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Regular
|
| 32 |
GPNL_BSNRG |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Base Non Regular
|
| 33 |
GPNL_SALARY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Salary
|
| 34 |
GPNL_INCOME |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Income
|
| 35 |
GPNL_INCOME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Income Code
|
| 36 |
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
|
| 37 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 38 |
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
|
| 39 |
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
|
| 40 |
GPNL_CBS_CAO_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
CBS CAO Code.
Labour Agreement Code, delivered by a given administration services.
|
| 41 |
GPNL_VAC_PAYM_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Declaration: Vacation Payment
|
| 42 |
GPNL_VAC_PAYM_ENT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Decalartion: Vacation Entitlement
|
| 43 |
GPNL_ADD_PAYM_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
An additional payment for the employee, like a 13th month payment
|
| 44 |
GPNL_ADD_PAYM_ENT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wag Tax Declaration: Additional Entitlement
|
| 45 |
GPNL_OVERTIME_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Declaration.
|
| 46 |
GPNL_NBR_HOURS |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Number of Hours
|
| 47 |
GPNL_CAR_TAX_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Taxable amount for the private use of a company car
|
| 48 |
GPNL_CAR_EE_DED |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Employee Contribution for private use of company car
|
| 49 |
GPNL_CHILDCARE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
The taxable amount for the employee due to childcare provided by the employer
|
| 50 |
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
|
| 51 |
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
|
| 52 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 53 |
GPNL_SUPPL_AMT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Amount of paid allowance on top of a paid disability allowance.
|
| 54 |
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
|
| 55 |
GPNL_PREP_RED |
Character(1) |
VARCHAR2(1) NOT NULL |
NLD Pre-Pension Reduction
A=Eligible/Applied
E=Eligible/Not Applied
N=Not Applicable
|
| 56 |
GP_CALC_TS |
DateTime(26) |
TIMESTAMP |
Indicates when something (a segment) was calculated
|