GPNZ_PDR_ER_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	GPNZ_PDR_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year code
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	PYMT_DT	Date(10)	DATE	Payment Date
5	GPNZ_PDR_RNTYP	Character(3)	VARCHAR2(3) NOT NULL	PDR Run Type AMD=Amendment NRM=Original OVR=Override Default Value: NRM
6	GPNZ_PDR_VERSION	Number(10,0)	DECIMAL(10) NOT NULL	New Field - Version added for PDR
7	GPNZ_PDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Issue status describes the level of the report.PDR Issued status 3=PDR File Generated 4=PDR Ready
8	GPNZ_IRD_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	New Zealand IRD Number
9	GPNZ_PDR_FINRET_ER	Character(1)	VARCHAR2(1) NOT NULL	PDR Employment File Run Control - Final Return Indicator
10	GPNZ_PDR_NILRET_ER	Character(1)	VARCHAR2(1) NOT NULL	PDR Employment File Run Control - Nil Return Indicator
11	GPNZ_PDR_IN_IRDNBR	Character(9)	VARCHAR2(9) NOT NULL	PDR Employment File Run Control - Intermediary IRD Number
12	GPNZ_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name char field for IR348 download. Contains 'firstname surname', without commas.
13	CONTACT_PHONE	Character(12)	VARCHAR2(12) NOT NULL	Contact Phone
14	CONTACTEMAIL	Character(70)	VARCHAR2(70) NOT NULL	Integration Server Business Entity Contact Email
15	GPNZ_PDR_TOT_EMPLN	Number(14,0)	DECIMAL(14) NOT NULL	New Field added for PDR
16	GPNZ_PAYE_TAX_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	PAYE Tax Amount from PAYE Tax MTD Accumulator
17	GPNZ_CHILD_SUP_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Child Support Amount from Child Support MTD Accumulator
18	GPNZ_STUD_LOAN_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
19	GPNZ_KIWI_EE_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD EE from KIWI DD EE MTD accumulator
20	GPNZ_KIWI_ER_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD ER from KIWI DD ER MTD accumulator
21	GPNZ_SSCWT_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	SSCWT Amount
22	GPNZ_PDR_TOT_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	New Field added for PDR
23	GPNZ_TX_CRDT_PG	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Field to hold the tax credit for payroll giving
24	GPNZ_FAM_ASST_AMT	Number(15,2)	DECIMAL(14,2) NOT NULL	Family Assist Amount
25	GPNZ_KIWI_ECST_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This field is used to capture ECST deduction made on the KiwiSaver Employer Contributions.
26	GPNZ_TAX_GROSS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Taxable Gross Amount from Taxable Gross MTD Accumulator
27	GPNZ_GROSS_NO_EP	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Gross Not Liable EP Amount from Retire/Redund MTD Accumulator
28	GPNZ_KIWI_ETC	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD ER from KIWI DD ER MTD accumulator
29	GPNZ_SLBOR_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
30	GPNZ_SLCIR_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
31	GPNZ_GROSS_ESS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Gross Not Liable EP Amount from ESS MTD Accumulator
32	GPNZ_PP_GRS_ADJ	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Prior Period Gross Adjustments
33	GPNZ_PP_PAYE_ADJ	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Prior Period Payee Adjustments
34	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
35	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp