SRCHORDR_VW_LN

(SQL View)
 Index Back

Search Order Table Rel Lang

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.

SELECT A.SEARCH_ORDER_NBR , A1.LANGUAGE_CD , A1. DESCR FROM PS_SEARCH_ORDR_TBL A , PS_SRCHORDR_TBL_LN A1 WHERE A.SEARCH_ORDER_NBR = A1.SEARCH_ORDER_NBR

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