GPNL_EMPLRCD_VW (SQL View)	Index Back
Wage Declaration Empl_Rcd This is a view contains the appropriate wage declaration employee rcd depending on the override in the GPNL_PAYEE_ADD recrod. This is used in the annual wage declaration app engine

GPNL_EMPLRCD_VW

(SQL View)

Wage Declaration Empl_Rcd

This is a view contains the appropriate wage declaration employee rcd depending on the override in the GPNL_PAYEE_ADD recrod. This is used in the annual wage declaration app engine

SELECT EMPLID , EMPL_RCD , EFFDT , GPNL_VAC_DAYS , GPNL_RED_HRS , GPNL_ABS_FREQ , GPNL_ABS_VAC_FREQ , GPNL_EMPL_CLASS , GPNL_INS_EXCEP_CD , GPNL_NATIONALITY , GPNL_ALLOW_SUPPL , GPNL_INC_RED_CD , GPNL_REGULAR_WORK , GPNL_HANDICAP_RED , GPNL_TAX_EXCEP_CD , END_DT , GPNL_EMPL_RCD_OVRD , %Coalesce(( SELECT A.GPNL_WD_EMPL_RCD FROM PS_GPNL_PAYEE_ADD A WHERE A.EMPLID = GPNL.EMPLID AND A.EMPL_RCD = GPNL.EMPL_RCD AND A.EFFDT = GPNL.EFFDT AND A.GPNL_EMPL_RCD_OVRD = 'Y'), GPNL.EMPL_RCD+1) FROM PS_GPNL_PAYEE_ADD GPNL

Parent record: PERSON

# 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 Rcd Nbr

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.

#	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 Rcd Nbr
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.