PSARCHAUDIT

index back

Archive Audit


PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PSARCH_EVENT Character(2) VARCHAR2(2) NOT NULL Archiving Event
PSARCH_EVENTDTTM DateTime(26) TIMESTAMP Event Date/Time
PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PSARCH_PROCESS Character(1) VARCHAR2(1) NOT NULL Archive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
PSARCH_NUMOFROWS Signed Number(19,0) DECIMAL(18) NOT NULL Number of Rows
PSARCH_SQL Long Character CLOB SQL Statement
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19