| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID
Prompt Table:
PERSON
|
| 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_VAC_DAYS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
GPNL_VAC_DAYS
|
| 5 |
GPNL_RED_HRS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
This field is used for the Netherlands to track Reduced Hours, known as 'ADV' hours.
|
| 6 |
GPNL_ABS_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Frequency.
D=Days
H=Hours
Default Value: H
|
| 7 |
GPNL_ABS_VAC_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Frequency.
D=Days
H=Hours
Default Value: D
|
| 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
Default Value: 1
|
| 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 |
GPNL_NATIONALITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Nationality code according to the NEN standards
Default Value: 0001
Prompt Table:
SSR_NATIONL_NLD
|
| 11 |
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
|
| 12 |
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
|
| 13 |
GPNL_REGULAR_WORK |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator for a Regular Work Schedule
Y/N Table Edit
Default Value: Y
|
| 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_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
|
| 16 |
END_DT |
Date(10) |
DATE |
end date
|
| 17 |
GPNL_EMPL_RCD_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override the Employment Nbr for reporting to the tax authority.
Y/N Table Edit
Default Value: N
|
| 18 |
GPNL_WD_EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Employment Number to be used in Wage Declaration. This will be EMPL_RCD + 1 as Tax Authority will not accept zero as the Employment Number.
|