SEARCH_ORDR_TBL

(SQL Table)
 Index Back

Search Order Table

The SEARCH_ORDR_TBL defines the order in which the search/match components are to be evaluated. The check is done in increasing SEARCH_ORDER_NBR order (ie: lowest to highest number in this field). It is assumed that the lower the number, the more restrictive the search components specified are. The information in this table is used by two processes: - Online, when an Add of an individual takes place, and - Background, by all processes which need to make an Add/Update decision. Usage of this table provides consistency across the institution as to how Add/Update actions take place and what may consistute a duplicate entry.

  • Related Language Record: SRCHORDR_TBL_LN

  • Parent Record Of SEARCH_COMP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 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.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description