ARCH_AUDIT_RQST

index back

PS Archiving Report Request


PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN

RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

Prompt Table: ARCH_PROJ

ARCH_CLASS Character(30) VARCHAR2(30) NOT NULL Archive Operator Class
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
FROM_DT Date(10) DATE From Date
TO_DT Date(10) DATE To Date
PSARCH_PRINT_SQL Character(1) VARCHAR2(1) NOT NULL Print SQL?

Y/N Table Edit

Default: N

PSARCH_FILE_PATH Character(70) VARCHAR2(70) NOT NULL File Path
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19