ARCH_AUDIT_RQST

index back

PS Archiving Report Request


PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN

RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).

Prompt Table: ARCH_PROJ

ARCH_CLASSCharacter(30)VARCHAR2(30) NOT NULLArchive Operator Class
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
FROM_DTDate(10)DATEFrom Date
TO_DTDate(10)DATETo Date
PSARCH_PRINT_SQLCharacter(1)VARCHAR2(1) NOT NULLPrint SQL?

Y/N Table Edit

Default: N

PSARCH_FILE_PATHCharacter(70)VARCHAR2(70) NOT NULLFile Path
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19