ARCH_AUDIT

index back

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
ARCH_EVENTCharacter(2)VARCHAR2(2) NOT NULLArchiving Event
AE=Archive Edit SQL
AI=Archive Import SQL
AR=Archive Run SQL
AV=Archive Events
AX=Archive Export SQL
BF=Batch Flat File Process
BH=Batch History Process
BI=Batch Import Process
BP=Batch AE Process
UC=Copy Archive ID
UD=Delete Archive ID
UG=Generate DM Script
UR=Rename Archive ID
UV=Utility Events
ARCH_EVENT_DTDate(10)DATEEvent Date
ARCH_EVENT_TMTime(15)TIMESTAMPEvent Time
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PSARCH_PROCESSCharacter(1)VARCHAR2(1) NOT NULLArchive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection
PSARCH_FLAGCharacter(1)VARCHAR2(1) NOT NULLArchive Flag
N=System Generated
P=PeopleSoft Delivered
Y=User Modified
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
ARCH_SQLLong CharacterCLOBGenerated SQL Statement
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19