ARCH_CTRL_VW2

 index back

PS Archiving Control View

For copying parent's criteria to Arch Other Control table.
SELECT PSARCH_ID , RECNAME , PSARCH_MATCH_KEY , PSARCH_AND_OR , FIELDNAME , PSARCH_OPERAND , PSARCH_MATCHVAL , PSARCH_MATCHDT FROM PS_ARCH_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).

Prompt Table: ARCH_CTRL

PSARCH_MATCH_KEY Number(5,0) INTEGER NOT NULL Match Number

Default: 1

PSARCH_AND_OR Character(1) VARCHAR2(1) NOT NULL AND or OR
1=AND
2=OR
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: RECFIELD_VW

PSARCH_OPERAND Character(1) VARCHAR2(1) NOT NULL Operator
1==
2=<
3=>
4=<=
5=>=
6=<>
7=LIKE
8=NOT LIKE
PSARCH_MATCHVAL Character(30) VARCHAR2(30) NOT NULL Value to Match
PSARCH_MATCHDT Date(10) DATE Value to Match (Date)
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20