ARCH_OTH_CTRL

index back

PS Archiving Other Control


  • Parent record: ARCH_TBL
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    ARCH_SEQNumber(4,0)SMALLINT NOT NULLArchiving Number Sequence
    ARCH_UNIQNumber(4,0)SMALLINT NOT NULLUnique Recname Identifier
    RECNAME1Character(15)VARCHAR2(15) NOT NULLRecord Name 1

    Prompt Table: RECDEFN_VW

    PSARCH_AND_OR1Character(1)VARCHAR2(1) NOT NULLAND or OR 1

    Default: A

    FIELDNAME1Character(18)VARCHAR2(18) NOT NULLField Name 1

    Prompt Table: ARCH_OTHFLD_VW

    PSARCH_OPERANDS1Character(1)VARCHAR2(1) NOT NULLOperator 1
    1==
    2=<
    3=>
    4=<=
    5=>=
    6=<>
    7=LIKE
    8=NOT LIKE
    PSARCH_MATCHVAL1Character(30)VARCHAR2(30) NOT NULLValue to Match 1
    PSARCH_MATCHDT1Date(10)DATEValue to Match (Date) 1
    PSARCH_CHECK_FLAGCharacter(1)VARCHAR2(1) NOT NULLCheck Flag
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19