ARCH_PROC_AET

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
ARCH_AE_TMPCharacter(1)VARCHAR2(1) NOT NULLArch Tmp Field
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see 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_PREAECharacter(12)VARCHAR2(12) NOT NULLPre AE
PSARCH_POSTAECharacter(12)VARCHAR2(12) NOT NULLPost AE
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
ARCH_COMMIT_FLAGCharacter(1)VARCHAR2(1) NOT NULLArchive Commit Flag

Y/N Table Edit

Default: N

ARCH_COMMIT_ROWSNumber(18,0)DECIMAL(18) NOT NULLNum rows to commit after
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
ARCH_PROC_FLAGCharacter(1)VARCHAR2(1) NOT NULLArchiving Process Flag

Y/N Table Edit

RECNAME1Character(15)VARCHAR2(15) NOT NULLRecord Name 1

Prompt Table: RECDEFN_VW

PSARCH_FLAGCharacter(1)VARCHAR2(1) NOT NULLArchive Flag
N=System Generated
P=PeopleSoft Delivered
Y=User Modified

Default: N

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