ARCH_AUDIT_VW

index back

Archiving Audit View


SELECT oprid , arch_event , arch_event_dt , arch_event_tm , PSARCH_ID , recname , PSARCH_PROCESS , PSARCH_FLAG , run_cntl_id , process_instance , arch_sql FROM ps_arch_audit

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
ARCH_EVENT Character(2) VARCHAR2(2) NOT NULL Archiving 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_DT Date(10) DATE Event Date
ARCH_EVENT_TM Time(15) TIMESTAMP Event 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
PSARCH_FLAG Character(1) VARCHAR2(1) NOT NULL Archive Flag
N=System Generated
P=PeopleSoft Delivered
Y=User Modified
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
ARCH_SQL Long Character CLOB Generated SQL Statement
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19