GPAU_STP_EVTSTG

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