PSARCHRUNCNTL

index back

Data Archive Manager Run Cntl


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

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

Default: S

PSARCH_UNITOFWORK Character(1) VARCHAR2(1) NOT NULL Do Archiving as Unit of Work
N=Do Archiving Row by Row
Y=Do Archiving in a Run Unit

Default: N

PSARCH_ROWPROCESS Character(1) VARCHAR2(1) NOT NULL Row-based processing
E=Commit at End
N=Set-Based Processing
Y=Row-Based Processing

Default: N

PSARCH_COMMIT_ROWS Number(18,0) DECIMAL(18) NOT NULL Num of rows to commit after
PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

Prompt Table: PSARCHBATCH_SRC

PSARCH_SELECTQRY Character(30) VARCHAR2(30) NOT NULL Selection Query for Archiving

Prompt Table: PSARCHUSEQRYVW

PSARCH_QRYTYPE Number(1,0) SMALLINT NOT NULL Data Archive Manager - Archive Query Type

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

Default: 0

PSARCH_DEFINEBINDS Character(1) VARCHAR2(1) NOT NULL Define Query Bind Variables
PSARCH_COUNT_ROWS Character(1) VARCHAR2(1) NOT NULL Audit Row Count

Y/N Table Edit

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