ARCH_CTRL

index back

PS Archiving Control


  • Parent record: 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: 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

    Default: A

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: ARCH_RECFLD_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 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19