PSAUDIT

index back

Field Level Audits


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
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value
KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
KEY3 Character(65) VARCHAR2(65) NOT NULL Third Key
KEY4 Character(65) VARCHAR2(65) NOT NULL Fourth Key
KEY5 Character(65) VARCHAR2(65) NOT NULL Fifth Key
KEY6 Character(65) VARCHAR2(65) NOT NULL Sixth Key
KEY7 Character(65) VARCHAR2(65) NOT NULL Seventh Key
KEY8 Character(65) VARCHAR2(65) NOT NULL Eighth Key
KEY9 Character(65) VARCHAR2(65) NOT NULL Ninth Key
KEY10 Character(65) VARCHAR2(65) NOT NULL Tenth Key
KEY11 Character(65) VARCHAR2(65) NOT NULL Eleventh Key
KEY12 Character(65) VARCHAR2(65) NOT NULL Twelfth Key
KEY13 Character(65) VARCHAR2(65) NOT NULL Thirteenth Key
KEY14 Character(65) VARCHAR2(65) NOT NULL Fourteenth Key
KEY15 Character(65) VARCHAR2(65) NOT NULL Fifteenth Key
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19