The purpose of this view is for use with the ARCH_UTILS panel. It allows us to UpdateValue the ARCH_SQL without having to work around the existing PeopleCode. This is the only current reason for the use of this view.

ARCH_SQL_LNG_VW

(SQL View)
 Index Back

SELECT PSARCH_ID , RECNAME , PSARCH_PROCESS , PSARCH_FLAG , ARCH_LONG_FLAG , ARCH_SQL FROM PS_ARCH_SQL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 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
4 PSARCH_FLAG Character(1) VARCHAR2(1) NOT NULL Archive Flag
N=System Generated
P=PeopleSoft Delivered
Y=User Modified

Default Value: N

5 ARCH_LONG_FLAG Character(1) VARCHAR2(1) NOT NULL Arch Long Flag
6 ARCH_SQL Long Character CLOB Generated SQL Statement