PSAUDIT

index back

Field Level Audits


PeopleSoft Field NameField TypeColumn TypeDescription
AUDIT_OPRIDCharacter(30)VARCHAR2(30) NOT NULLThe OPRID of the user who made the changes audited on an audit record.
AUDIT_STAMPDateTime(26)TIMESTAMPDate and Time Stamp
AUDIT_ACTNCharacter(1)VARCHAR2(1) NOT NULLAudit 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
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
OLDVALUECharacter(65)VARCHAR2(65) NOT NULLOld Value
NEWVALUECharacter(65)VARCHAR2(65) NOT NULLNew Value
KEY1Character(65)VARCHAR2(65) NOT NULLFirst Key
KEY2Character(65)VARCHAR2(65) NOT NULLSecond Key
KEY3Character(65)VARCHAR2(65) NOT NULLThird Key
KEY4Character(65)VARCHAR2(65) NOT NULLFourth Key
KEY5Character(65)VARCHAR2(65) NOT NULLFifth Key
KEY6Character(65)VARCHAR2(65) NOT NULLSixth Key
KEY7Character(65)VARCHAR2(65) NOT NULLSeventh Key
KEY8Character(65)VARCHAR2(65) NOT NULLEighth Key
KEY9Character(65)VARCHAR2(65) NOT NULLNinth Key
KEY10Character(65)VARCHAR2(65) NOT NULLTenth Key
KEY11Character(65)VARCHAR2(65) NOT NULLEleventh Key
KEY12Character(65)VARCHAR2(65) NOT NULLTwelfth Key
KEY13Character(65)VARCHAR2(65) NOT NULLThirteenth Key
KEY14Character(65)VARCHAR2(65) NOT NULLFourteenth Key
KEY15Character(65)VARCHAR2(65) NOT NULLFifteenth Key
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19