GPNL_RED1_TMP

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GPNL_TAX_RED_KEY	Character(1)	VARCHAR2(1) NOT NULL	Tax Reduction Key 1=Low Wages 2=Former Unemployement 3=Education 5=Parental Leave
5	SEG_BGN_DT	Date(10)	DATE NOT NULL	Payee Process Segment's Begin Date
6	SEG_END_DT	Date(10)	DATE NOT NULL	Payee Process Segment's End Date
7	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
8	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
9	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
10	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
11	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
12	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
14	GPNL_INCOME	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Income
15	GPNL_NBR_HOURS	Signed Number(8,0)	DECIMAL(7) NOT NULL	Number of Hours
16	GPNL_STD_HOURS	Signed Number(8,0)	DECIMAL(7) NOT NULL	Standard Hours
17	GPNL_TAX_RED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax Reduction
18	END_DT	Date(10)	DATE	end date