ARCH_OTH_CTRL

(SQL Table)
 Index Back

PS Archiving Other Control

  • Parent record: ARCH_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 ARCH_SEQ Number(4,0) SMALLINT NOT NULL Archiving Number Sequence
    4 ARCH_UNIQ Number(4,0) SMALLINT NOT NULL Unique Recname Identifier
    5 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

    Prompt Table: RECDEFN_VW

    6 PSARCH_AND_OR1 Character(1) VARCHAR2(1) NOT NULL AND or OR 1

    Default Value: A

    7 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: ARCH_OTHFLD_VW

    8 PSARCH_OPERANDS1 Character(1) VARCHAR2(1) NOT NULL Operator 1
    1==
    2=<
    3=>
    4=<=
    5=>=
    6=<>
    7=LIKE
    8=NOT LIKE
    9 PSARCH_MATCHVAL1 Character(30) VARCHAR2(30) NOT NULL Value to Match 1
    10 PSARCH_MATCHDT1 Date(10) DATE Value to Match (Date) 1
    11 PSARCH_CHECK_FLAG Character(1) VARCHAR2(1) NOT NULL Check Flag