GPAU_AUD_STPRUN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
2	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
3	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
8	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT_SGPAU
9	GPAU_STP_FILETYPE	Character(1)	VARCHAR2(1) NOT NULL	File Type determines the Type of STP File Generation P=Pay Event U=Update Event Default Value: P
10	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPAU_CALGRP_VW
11	PYMT_DT	Date(10)	DATE	Payment Date
12	GPAU_TAX_YR_BGN_DT	Date(10)	DATE	Begin Date
13	GPAU_TAX_YR_END_DT	Date(10)	DATE	End Date
14	GPAU_STP_PRCS_IND	Character(1)	VARCHAR2(1) NOT NULL	Header - STP File Generation Process Y/N Table Edit Default Value: N
15	GPAU_RUN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Run Type for EOY Magnetic Type 10=Production 20=Test Default Value: 20
16	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GPAU_PYGRP_VW
17	GPAU_STP_DECLARE	Character(1)	VARCHAR2(1) NOT NULL	Declaration for Reporting Party - Single Touch Payroll N=False Y=True Default Value: Y
18	GPAU_STP_REP_PARTY	Character(1)	VARCHAR2(1) NOT NULL	Reporting Party of STP - Payer or Intermediary E=Payer/Employer I=Intermediary Default Value: E
19	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
20	END_DATE	Date(10)	DATE	End Date
21	GPAU_FILE_REPLACE	Character(1)	VARCHAR2(1) NOT NULL	Full File Replacement Indicator - Single Touch Payroll Y/N Table Edit Default Value: N
22	GPAU_STP_TRANS_ID	Character(30)	VARCHAR2(30) NOT NULL	Submission ID - Single Touch Payroll Prompt Table: GPAU_TRANSID_VW
23	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 Y/N Table Edit Default Value: N
24	GPAU_STP_FIRST_PAY	Character(1)	VARCHAR2(1) NOT NULL	First Payroll Event - Single Touch Payroll Y/N Table Edit Default Value: N
25	GPAU_STP_UPDEVT_DT	Date(10)	DATE	Update Event Date
26	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
27	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
28	GPAU_ACKNOWLEDGE	Character(1)	VARCHAR2(1) NOT NULL	Acknowledge Field for GPAU STP File Generation Run control. Y/N Table Edit Default Value: N
29	GPAU_RUNDTTM	DateTime(26)	TIMESTAMP	Field to capture Run DateTime Default Value: %datetime
30	DESCRLONG	Long Character	CLOB	Long Description