ARCH_PROC_AET

index back

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
ARCH_AE_TMP Character(1) VARCHAR2(1) NOT NULL Arch Tmp Field
PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see 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_PREAE Character(12) VARCHAR2(12) NOT NULL Pre AE
PSARCH_POSTAE Character(12) VARCHAR2(12) NOT NULL Post AE
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
ARCH_COMMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Archive Commit Flag

Y/N Table Edit

Default: N

ARCH_COMMIT_ROWS Number(18,0) DECIMAL(18) NOT NULL Num rows to commit after
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
ARCH_PROC_FLAG Character(1) VARCHAR2(1) NOT NULL Archiving Process Flag

Y/N Table Edit

RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

Prompt Table: RECDEFN_VW

PSARCH_FLAG Character(1) VARCHAR2(1) NOT NULL Archive Flag
N=System Generated
P=PeopleSoft Delivered
Y=User Modified

Default: N

ARCH_SQL Long Character CLOB Generated SQL Statement
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20