PSARCHRUNCNTL

Return to Index

Data Archive Manager Run Cntl

PeopleSoft Field NameDescription
OPRIDA user's ID

Prompt Table: PSOPRDEFN

RUN_CNTL_IDRun Control ID
PSARCH_IDArchive ID

Prompt Table: PSARCHTEMPLATE

PSARCH_PROCESSArchive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection (default)
PSARCH_UNITOFWORKDo Archiving as Unit of Work
N=Do Archiving Row by Row
Y=Do Archiving in a Run Unit (default)
PSARCH_ROWPROCESSRow-based processing
E=Commit at End
N=Set-Based Processing (default)
Y=Row-Based Processing
PSARCH_COMMIT_ROWSNum of rows to commit after
PSARCH_BATCHNUMArchive Batch Number

Prompt Table: PSARCHBATCH_SRC

PSARCH_SELECTQRYSelection Query for Archiving

Prompt Table: PSARCHUSEQRYVW

PSARCH_QRYTYPEData Archive Manager - Archive Query Type

1/0 Table Edit (1=True, 0=False)

Default: 0

PSARCH_DEFINEBINDSDefine Query Bind Variables
PSARCH_COUNT_ROWSAudit Row Count

Y/N Table Edit

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010