GPNZ_PDR_EE_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	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
6	FROM_DT	Date(10)	DATE	From Date
7	TO_DT	Date(10)	DATE	To Date
8	GPNZ_PDR_FL_TYP	Character(4)	VARCHAR2(4) NOT NULL	PDR Employment File Run Control - File Type CSV=CSV XLS=XLS XML=XML
9	GPNZ_PDR_EEFT_AL	Character(1)	VARCHAR2(1) NOT NULL	PDR Employee File - File Type for xml
10	GPNZ_PDR_EEFT_CR	Character(1)	VARCHAR2(1) NOT NULL	PDR - RunControl Place Holder for Create File for xml
11	GPNZ_PDR_EEFT_UP	Character(1)	VARCHAR2(1) NOT NULL	PDR - RunControl Place Holder for Update File
12	GPNZ_PDR_EEFT_TE	Character(1)	VARCHAR2(1) NOT NULL	PDR - RunControl Place Holder for Update File for xml
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
15	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
16	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.
17	GPNZ_IRD_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	New Zealand IRD Number
18	GPNZ_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name char field for IR348 download. Contains 'firstname surname', without commas.
19	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Name Title
20	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
21	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
22	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
23	DATE_OF_BIRTH	Date(10)	DATE	Date of Birth
24	GPNZ_TAX_SCALE	Character(4)	VARCHAR2(4) NOT NULL	New Zealand Tax Scale
25	GPNZ_START_DT	Date(10)	DATE	Start Date for employees that have commenced employment during the month
26	GPNZ_FINISH_DT	Date(10)	DATE	Finish Date for employees terminated during the month
27	GPNZ_PDR_KIWI_ST	Character(22)	VARCHAR2(22) NOT NULL	PDR KIWI Status Description
28	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
29	GPNZ_PDR_MOB_CNTR	Character(30)	VARCHAR2(30) NOT NULL	PDR Mobile Phone
30	GPNZ_PDR_MOB_AC	Character(10)	VARCHAR2(10) NOT NULL	PDR Mobile Phone
31	GPNZ_PDR_MOB_NBR	Character(30)	VARCHAR2(30) NOT NULL	PDR Mobile PhoneNumber
32	GPNZ_PDR_MOB_EXT	Character(20)	VARCHAR2(20) NOT NULL	PDR Mobile PhoneExtn
33	GPNZ_PDR_DTPH_CNTR	Character(30)	VARCHAR2(30) NOT NULL	PDR DayTime Phone
34	GPNZ_PDR_DTPH_AC	Character(10)	VARCHAR2(10) NOT NULL	PDR DayTime Phone
35	GPNZ_PDR_DTPH_NBR	Character(30)	VARCHAR2(30) NOT NULL	PDR DayTime PhoneNumber
36	GPNZ_PDR_DTPH_EXT	Character(20)	VARCHAR2(20) NOT NULL	PDR DayTime PhoneExtn
37	GPNZ_PDR_UNIT_TYP	Character(50)	VARCHAR2(50) NOT NULL	PDR Employee File Unit Type
38	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
39	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
40	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
41	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
42	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
43	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
44	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
45	GPNZ_PDR_NM_PRFX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix for Pay Day Reporting New Zealand DR=Doctor MISS=Miss MR=Mr MRS=Mrs MS=Ms
46	GPNZ_PDR2_EFFDT	Date(10)	DATE	PDR2 Effective date