AUDIT_PRXY_TXN

#	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_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
3	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	SCC_DA_PRXY_ID	Number(16,0)	DECIMAL(16) NOT NULL	Proxy ID
6	SCC_DA_TXN_CD	Character(50)	VARCHAR2(50) NOT NULL	Transaction Code
7	SCC_START_DTTM	DateTime(26)	TIMESTAMP	Last Run Date Time
8	SCC_DA_EXP_DTTM	DateTime(26)	TIMESTAMP	The date the file was created
9	SCC_DA_TXN_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Transaction Status
10	SCC_END_DTTM	DateTime(26)	TIMESTAMP	Txn End Date Time
11	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
12	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
13	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
14	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time