ARCH_TBL_VW

index back

PS Archiving Tables View


SELECT PSARCH_ID , recname , hist_recname , PSARCH_ROW_COPY , parentrecname FROM ps_arch_tbl

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).

Prompt Table: RECDEFN_VW

HIST_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
PSARCH_ROW_COPY Character(1) VARCHAR2(1) NOT NULL Copy Parent Criteria
PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19