SEARCH_ORDR_PRM

(SQL Table)
 Index Back

Search Order Parms

SEARCH_ORDR_PRM contains the processing parameters to be used based on the results of the Search/Match when one or multiple matches are found.

  • Parent record: SEARCH_ADD_PARM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: SEARCH_ADD_PARM.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: SEARCH_ADD_PARM.RUN_CNTL_ID

    Prompt Table: SEARCH_ADD_PARM

    3 SM_PARM_CD Character(15) VARCHAR2(15) NOT NULL Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
    4 SEARCH_ORDER_NBR Number(3,0) SMALLINT NOT NULL This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.

    Prompt Table: SEARCH_ORDR_TBL

    5 PER_UPDATE_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Update Criteri
    A=Add
    I=Ignore
    S=Suspend
    U=Update

    Default Value: U

    6 PER_MULTIPLE_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Multiples Crit
    A=Add
    I=Ignore
    S=Suspend
    U=Update

    Default Value: S