PTSF_AUDIT_DEPO

(SQL Table)

# 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 PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name
Prompt Table: PTSF_SRCH_ENGN

5 PTSF_DEPLOYED_ID Number(5,0) INTEGER NOT NULL Deployed ID

6 PTSF_DEPLOYED_NAME Character(96) VARCHAR2(96) NOT NULL Deployed Name

7 PTSF_DPY_DISP_NAME Character(30) VARCHAR2(30) NOT NULL Deployed Display Name

#	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	PTSF_SRCH_ENG_INS	Character(30)	VARCHAR2(30) NOT NULL	Search Instance Name Prompt Table: PTSF_SRCH_ENGN
5	PTSF_DEPLOYED_ID	Number(5,0)	INTEGER NOT NULL	Deployed ID
6	PTSF_DEPLOYED_NAME	Character(96)	VARCHAR2(96) NOT NULL	Deployed Name
7	PTSF_DPY_DISP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Deployed Display Name