ARCH_EXP_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
4 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 Value: S

5 PSARCH_RECNUM Number(5,0) INTEGER NOT NULL Record Number
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 PSARCH_FILE_PATH Character(70) VARCHAR2(70) NOT NULL File Path