ARCH_SQL_LNG

index back

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

Default: N

ARCH_LONG_FLAG Character(1) VARCHAR2(1) NOT NULL Arch Long Flag
ARCH_SQL Long Character CLOB Generated SQL Statement
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19