GPNZ_RCN_EE_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	GPNZ_PDR_RNTYP	Character(3)	VARCHAR2(3) NOT NULL	PDR Run Type AMD=Amendment NRM=Original OVR=Override Default Value: NRM
4	GPNZ_PDR_VERSION	Number(10,0)	DECIMAL(10) NOT NULL	New Field - Version added for PDR
5	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
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	GPNZ_RCN_RW_TYP	Character(1)	VARCHAR2(1) NOT NULL	Reconciliation Row Type P=Payroll Register R=PDR
8	PYMT_DT	Date(10)	DATE	Payment Date
9	GPNZ_TAX_GROSS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Taxable Gross Amount from Taxable Gross MTD Accumulator
10	GPNZ_PAYE_TAX_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	PAYE Tax Amount from PAYE Tax MTD Accumulator
11	GPNZ_CHILD_SUP_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Child Support Amount from Child Support MTD Accumulator
12	GPNZ_STUD_LOAN_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
13	GPNZ_SSCWT_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	SSCWT Amount
14	GPNZ_KIWI_EE_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD EE from KIWI DD EE MTD accumulator
15	GPNZ_KIWI_ER_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD ER from KIWI DD ER MTD accumulator
16	GPNZ_SLBOR_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
17	GPNZ_SLCIR_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
18	GPNZ_GROSS_ESS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Gross Not Liable EP Amount from ESS MTD Accumulator
19	GPNZ_FAM_ASST_AMT	Number(15,2)	DECIMAL(14,2) NOT NULL	Family Assist Amount