ARCH_SQL_LNG_VW

index back
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.
SELECT PSARCH_ID , RECNAME , PSARCH_PROCESS , PSARCH_FLAG , ARCH_LONG_FLAG , ARCH_SQL FROM PS_ARCH_SQL_LNG

PeopleSoft Field NameField TypeColumn TypeDescription
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
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
PSARCH_FLAGCharacter(1)VARCHAR2(1) NOT NULLArchive Flag
N=System Generated
P=PeopleSoft Delivered
Y=User Modified

Default: N

ARCH_LONG_FLAGCharacter(1)VARCHAR2(1) NOT NULLArch Long Flag
ARCH_SQLLong CharacterCLOBGenerated SQL Statement
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19