GPNL_YER1_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
6	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
7	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
8	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
9	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
10	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	GPNL_COLUMN_2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 2
13	GPNL_COLUMN_3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 3
14	GPNL_COLUMN_4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 4
15	GPNL_COLUMN_5	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 5
16	GPNL_COLUMN_7	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 7
17	GPNL_COLUMN_9	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 9
18	GPNL_COLUMN_10	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 10
19	GPNL_COLUMN_11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 11
20	GPNL_COLUMN_13	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 13
21	GPNL_COLUMN_15	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 15
22	GPNL_COLUMN_16	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 16
23	GPNL_COLUMN_19	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Report Column 19 Life Cycle Tax Reduction "Levensloopverlofkorting"
24	GPNL_TAXLAB_RED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax Labor Reduction
25	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID