PSARCHRUNCNTL

index back

Data Archive Manager Run Cntl


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: PSARCHTEMPLATE

PSARCH_PROCESSCharacter(1)VARCHAR2(1) NOT NULLArchive Process
D=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection

Default: S

PSARCH_UNITOFWORKCharacter(1)VARCHAR2(1) NOT NULLDo Archiving as Unit of Work
N=Do Archiving Row by Row
Y=Do Archiving in a Run Unit

Default: N

PSARCH_ROWPROCESSCharacter(1)VARCHAR2(1) NOT NULLRow-based processing
E=Commit at End
N=Set-Based Processing
Y=Row-Based Processing

Default: N

PSARCH_COMMIT_ROWSNumber(18,0)DECIMAL(18) NOT NULLNum of rows to commit after
PSARCH_BATCHNUMNumber(30,0)DECIMAL(30) NOT NULLArchive Batch Number

Prompt Table: PSARCHBATCH_SRC

PSARCH_SELECTQRYCharacter(30)VARCHAR2(30) NOT NULLSelection Query for Archiving

Prompt Table: PSARCHUSEQRYVW

PSARCH_QRYTYPENumber(1,0)SMALLINT NOT NULLData Archive Manager - Archive Query Type

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

Default: 0

PSARCH_DEFINEBINDSCharacter(1)VARCHAR2(1) NOT NULLDefine Query Bind Variables
PSARCH_COUNT_ROWSCharacter(1)VARCHAR2(1) NOT NULLAudit Row Count

Y/N Table Edit

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19