GPNZ_IR348F_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	GPNZ_PAYE_TAX_1ST	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 amounts for the PAYE Tax First Half month
6	GPNZ_STUD_LOAN_1ST	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 student loan amounts for the First Half month
7	GPNZ_CHILD_SUP_1ST	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 child support amounts for the First Half month
8	GPNZ_SSCWT_1ST	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 SSCWT amounts for the First Half month
9	GPNZ_PAYE_TAX_2ND	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 amounts for the PAYE Tax First Half month
10	GPNZ_STUD_LOAN_2ND	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 student loan amounts for the Second Half month
11	GPNZ_CHILD_SUP_2ND	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 child support amounts for the Second Half month
12	GPNZ_SSCWT_2ND	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	IR 345/6 SSCWT amounts for the Second Half month
13	GPNZ_TAX_GROSS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Taxable Gross Amount from Taxable Gross MTD Accumulator
14	GPNZ_GROSS_NO_EP	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Gross Not Liable EP Amount from Retire/Redund MTD Accumulator
15	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
16	GPNZ_TAX_SCALE	Character(4)	VARCHAR2(4) NOT NULL	New Zealand Tax Scale
17	GPNZ_LUMP_SUM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	GPNZ Lump Sum Indicator 0=Lump Sum Off 1=Lump Sum On N=Lum Sum Off Y=Lump Sum On
18	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
19	GPNZ_YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Year code
20	GPNZ_MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month code 01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December
21	GPNZ_TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary flag
22	GPNZ_1HM_DT_BEGIN	Date(10)	DATE	Begin 1 Half Month Date for IR 348 Issued
23	GPNZ_1HM_DT_END	Date(10)	DATE	End 1st Half Month Date for IR 348 Issued
24	GPNZ_LAST_DAY_MTH	Date(10)	DATE	Last day of Month Date
25	GPNZ_2HM_DT_REFEND	Date(10)	DATE	Reference End 2nd Half Month Date for IR 348 Issued