PTSF_AUDIT_DEPO

index back

PeopleSoft Field Name Field Type Column Type Description
AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
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
PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name

Prompt Table: PTSF_SRCH_ENGN

PTSF_DEPLOYED_ID Number(5,0) INTEGER NOT NULL Deployed ID
PTSF_DEPLOYED_NAME Character(96) VARCHAR2(96) NOT NULL Deployed Name
PTSF_DPY_DISP_NAME Character(30) VARCHAR2(30) NOT NULL Deployed Display Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19