ARCH_RQST_PARM

(SQL Table)
 Index Back

PS Archiving Rqst Parameters

  • Parent record: ARCH_RQST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    5 PSARCH_PARMNAME Character(30) VARCHAR2(30) NOT NULL Parameter Field Name
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    7 PSARCH_OPERAND Character(1) VARCHAR2(1) NOT NULL Operator
    1==
    2=<
    3=>
    4=<=
    5=>=
    6=<>
    7=LIKE
    8=NOT LIKE
    8 PSARCH_MATCHVAL Character(30) VARCHAR2(30) NOT NULL Value to Match