ARCH_OTH_CTL_VW

index back

PS Archiving OtherCtrl View


SELECT PSARCH_ID , recname , arch_seq , arch_uniq , recname1 , PSARCH_AND_OR1 , fieldname1 , PSARCH_OPERANDS1 , PSARCH_MATCHVAL1 , PSARCH_MATCHDT1 , PSARCH_CHECK_FLAG FROM PS_ARCH_OTH_CTRL

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).
ARCH_SEQ Number(4,0) SMALLINT NOT NULL Archiving Number Sequence
ARCH_UNIQ Number(4,0) SMALLINT NOT NULL Unique Recname Identifier
RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

Prompt Table: RECDEFN_VW

PSARCH_AND_OR1 Character(1) VARCHAR2(1) NOT NULL AND or OR 1
FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
PSARCH_OPERANDS1 Character(1) VARCHAR2(1) NOT NULL Operator 1
1==
2=<
3=>
4=<=
5=>=
6=<>
7=LIKE
8=NOT LIKE
PSARCH_MATCHVAL1 Character(30) VARCHAR2(30) NOT NULL Value to Match 1
PSARCH_MATCHDT1 Date(10) DATE Value to Match (Date) 1
PSARCH_CHECK_FLAG Character(1) VARCHAR2(1) NOT NULL Check Flag
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19