GPAU_AUD_STPGEN (SQL Table)	Index Back
STP Pay Event File Gen Audit record for Run Control for STP Pay Event File Generation process.

GPAU_AUD_STPGEN

(SQL Table)

STP Pay Event File Gen

Audit record for Run Control for STP Pay Event File Generation process.

# 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 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing

7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GP_PYENT_SGPAU

8 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

9 GPAU_RUN_TYPE Character(2) VARCHAR2(2) NOT NULL Run Type for EOY Magnetic Type
10=Production
20=Test
Default Value: 20

10 GPAU_STP_DECLARE Character(1) VARCHAR2(1) NOT NULL Declaration for Reporting Party - Single Touch Payroll
N=False
Y=True
Default Value: Y

11 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

12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

14 GPAU_ACKNOWLEDGE Character(1) VARCHAR2(1) NOT NULL Acknowledge Field for GPAU STP File Generation Run control.
Y/N Table Edit
Default Value: N

15 GPAU_FULLNAME Character(100) VARCHAR2(100) NOT NULL STP Generation audit field to capture user full name

16 GPAU_EMAILADR Character(70) VARCHAR2(70) NOT NULL STP Generation audit field to capture user email address

17 DESCRLONG Long Character CLOB Long Description

#	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	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
7	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT_SGPAU
8	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
9	GPAU_RUN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Run Type for EOY Magnetic Type 10=Production 20=Test Default Value: 20
10	GPAU_STP_DECLARE	Character(1)	VARCHAR2(1) NOT NULL	Declaration for Reporting Party - Single Touch Payroll N=False Y=True Default Value: Y
11	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
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
14	GPAU_ACKNOWLEDGE	Character(1)	VARCHAR2(1) NOT NULL	Acknowledge Field for GPAU STP File Generation Run control. Y/N Table Edit Default Value: N
15	GPAU_FULLNAME	Character(100)	VARCHAR2(100) NOT NULL	STP Generation audit field to capture user full name
16	GPAU_EMAILADR	Character(70)	VARCHAR2(70) NOT NULL	STP Generation audit field to capture user email address
17	DESCRLONG	Long Character	CLOB	Long Description