GPNZ_PDR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
5	GPNZ_PDR_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year code
6	PAYMENT_DT	Date(10)	DATE	Payment Date
7	PYMT_DT	Date(10)	DATE	Payment Date
8	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
9	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
10	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
11	GPNZ_PDR_PRC	Character(2)	VARCHAR2(2) NOT NULL	Process By field for PDR CG=Calendar Group ID EM=Employee ID GL=Group List PE=Pay Entity PG=Pay Group SL=Stream List Default Value: PE
12	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List Prompt Table: GP_GRP_LIST_VW
13	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
14	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
15	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
16	PRD_END_DT	Date(10)	DATE	Pay Period End Date
17	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
18	FROM_DT	Date(10)	DATE	From Date
19	TO_DT	Date(10)	DATE	To Date
20	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
21	GPNZ_TAX_SCALE	Character(4)	VARCHAR2(4) NOT NULL	New Zealand Tax Scale
22	GPNZ_TAX_GROSS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Taxable Gross Amount from Taxable Gross MTD Accumulator
23	GPNZ_GROSS_ESS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Gross Not Liable EP Amount from ESS MTD Accumulator
24	GPNZ_STLN_ESS_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount for ESS from Student Loan MTD Accumulator
25	GPNZ_GROSS_NO_EP	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Gross Not Liable EP Amount from Retire/Redund MTD Accumulator
26	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
27	GPNZ_PAYE_TAX_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	PAYE Tax Amount from PAYE Tax MTD Accumulator
28	GPNZ_TX_CRDT_PG	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Field to hold the tax credit for payroll giving
29	GPNZ_CHILD_SUP_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Child Support Amount from Child Support MTD Accumulator
30	GPNZ_CHILD_SUP_VAR	Character(1)	VARCHAR2(1) NOT NULL	Describes the variation key for child support A=Advance Pay C=Ceased Employment D=Deducted previously O=Other P=Protected Earnings S=Short Term Absence
31	GPNZ_STUD_LOAN_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
32	GPNZ_SLBOR_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
33	GPNZ_SLCIR_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan Amount from Student Loan MTD Accumulator
34	GPNZ_SLBOR_ESS_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan BOR Amount on ESS from Student Loan MTD Accumulator for ESS
35	GPNZ_SLCIR_ESS_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Student Loan CIR Amount for ESS from Student Loan MTD Accumulator
36	GPNZ_XE_ESS_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Extra Emolument on ESS from Extra Emolument on ESS MTD Accumulator
37	GPNZ_SSCWT_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	SSCWT Amount
38	GPNZ_KIWI_EE_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD EE from KIWI DD EE MTD accumulator
39	GPNZ_KIWI_ER_DED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD ER from KIWI DD ER MTD accumulator
40	GPNZ_KIWI_ETC	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	KIWI DD ER from KIWI DD ER MTD accumulator
41	GPNZ_START_DT	Date(10)	DATE	Start Date for employees that have commenced employment during the month
42	GPNZ_FINISH_DT	Date(10)	DATE	Finish Date for employees terminated during the month
43	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
44	GPNZ_ACUM_PIN_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number
45	GPNZ_CHILD_SUP_REG	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This field is used as a work field in the year end process
46	GPNZ_FAM_ASST_AMT	Number(15,2)	DECIMAL(14,2) NOT NULL	Family Assist Amount
47	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.
48	GPNZ_EE_LUMP_SUM	Number(15,2)	DECIMAL(14,2) NOT NULL	EE Lump Sum from EE Lump Sum Accumulator
49	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
50	GPNZ_IRD_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	New Zealand IRD Number
51	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
52	GPNZ_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name char field for IR348 download. Contains 'firstname surname', without commas.
53	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
54	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
55	GPNZ_PDR_RNTYP	Character(3)	VARCHAR2(3) NOT NULL	PDR Run Type AMD=Amendment NRM=Original OVR=Override Default Value: NRM
56	GPNZ_PDR_SQL_TEXT	Long Character	CLOB	To store SQL Text in AET during Application Engine Processing.
57	GPNZ_PDR_V2	Character(1)	VARCHAR2(1) NOT NULL	FIle Generation