GPAU_STP_TMPXML

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
4	GPAU_STP_FILETYPE	Character(1)	VARCHAR2(1) NOT NULL	File Type determines the Type of STP File Generation P=Pay Event U=Update Event
5	GPAU_STP_UPDEVT_DT	Date(10)	DATE	Update Event Date
6	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
7	EMPL_COUNT	Number(12,0)	DECIMAL(12) NOT NULL	Employee Count
8	GPAU_STP_WPN	Number(11,0)	DECIMAL(11) NOT NULL	Withholding Payer Number - Single Touch Payroll Default Value: 0
9	GPAU_GROSS_PTD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	PAYEVNT consolidated PTD Gross Amount - Single Touch Payroll
10	GPAU_TAX_WHELD_PTD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	PayEvnt Tax Witholding PTD Amount - Single Touch Payroll
11	GPAU_EVNT_CSD_PAY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Child Support Deduction PTD of Employee - Single Touch Payroll
12	GPAU_EVNT_CSG_PAY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Child Support Garnishment PTD of Employee - Single Touch Payroll
13	GPAU_STP_BMS_ID	Character(200)	VARCHAR2(200) NOT NULL	Business Management System Identifier - Single Touch Payroll.
14	GPAU_PREV_BMS_ID	Character(200)	VARCHAR2(200) NOT NULL	Previous Business Management System Identifier - Single Touch Payroll.
15	PYMT_DT	Date(10)	DATE	Payment Date
16	GPAU_REGISTERED_NM	Character(200)	VARCHAR2(200) NOT NULL	This is the pay entity's registered name (company registered name).
17	GPAU_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
18	GPAU_ABN_BRANCH	Number(3,0)	SMALLINT NOT NULL	ABN Branch is issued by the ATO to payers that wush to sub-divide their activities. Valid values iare 001 - 999. Default value is 001.
19	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
20	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
21	ADDRESS_150	Character(150)	VARCHAR2(150) NOT NULL	Preparer's Address
22	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
23	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
24	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
25	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
26	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
27	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
28	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
29	GPAU_SIGNATORY	Character(40)	VARCHAR2(40) NOT NULL	This is the pay entity's signatory that will be on the payee's payment summary.
30	GPAU_STP_DECLARE	Character(1)	VARCHAR2(1) NOT NULL	Declaration for Reporting Party - Single Touch Payroll N=False Y=True
31	GPAU_STP_SIGN_DT	Date(10)	DATE	Single Touch Payroll - Declaration Date
32	PHONE2	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
33	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
34	EMAIL_ADDR2	Character(70)	VARCHAR2(70) NOT NULL	Email Address
35	GPAU_ABN2	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
36	GPAU_STP_TRANS_ID	Character(30)	VARCHAR2(30) NOT NULL	Submission ID - Single Touch Payroll
37	GPAU_STP_DECLARE1	Character(1)	VARCHAR2(1) NOT NULL	Declaration for Intermediary - Single Touch Payroll
38	GPAU_STP_SIGN_DT1	Date(10)	DATE	Declaration Date - Intermediary
39	GPAU_STP_TAN	Number(8,0)	INTEGER NOT NULL	Registered Agent Name - TFN Supplier Data
40	GPAU_FILE_REPLACE	Character(1)	VARCHAR2(1) NOT NULL	Full File Replacement Indicator - Single Touch Payroll
41	GPAU_STP_FINAL_PAY	Character(1)	VARCHAR2(1) NOT NULL	Final Event Indicator - Single Touch Payroll A=All Payees N=Not Applicable T=Terminated Payees Y=Active Payees
42	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
43	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp