SEARCH_COMP_TBL (SQL Table)	Index Back
Search Component Table The SEARCH_COMP_TBL contains the record/field pairs which are to be used for searching and matching. It is assumed that data is present for all of the fields defined within the SEARCH_ORDR_NBR for the search to take place. Otherwise, that search will be skipped. 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.

SEARCH_COMP_TBL

(SQL Table)

Search Component Table

The SEARCH_COMP_TBL contains the record/field pairs which are to be used for searching and matching. It is assumed that data is present for all of the fields defined within the SEARCH_ORDR_NBR for the search to take place. Otherwise, that search will be skipped. 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.

Parent record: SEARCH_ORDR_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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

5 SM_USAGE Character(1) VARCHAR2(1) NOT NULL Search Match Usage field. This field controls the usage parameters for the Search Match Rule for Character fieldtypes.
B=Begins With
C=Contains
E=Equals
N=Not Used

6 COMPARE_START Number(3,0) SMALLINT NOT NULL Compare Start

7 SM_LENGTH Number(3,0) SMALLINT NOT NULL Search Match Length field. This field identifies the length of a substring search.

8 SM_REQUIRED Character(1) VARCHAR2(1) NOT NULL Search Match Required field. This field identifies a Search Match Rule element as being required or not.

9 SQL_BIND_NBR Character(4) VARCHAR2(4) NOT NULL SQL Bind Nbr

10 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

#	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	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	SM_USAGE	Character(1)	VARCHAR2(1) NOT NULL	Search Match Usage field. This field controls the usage parameters for the Search Match Rule for Character fieldtypes. B=Begins With C=Contains E=Equals N=Not Used
6	COMPARE_START	Number(3,0)	SMALLINT NOT NULL	Compare Start
7	SM_LENGTH	Number(3,0)	SMALLINT NOT NULL	Search Match Length field. This field identifies the length of a substring search.
8	SM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Search Match Required field. This field identifies a Search Match Rule element as being required or not.
9	SQL_BIND_NBR	Character(4)	VARCHAR2(4) NOT NULL	SQL Bind Nbr
10	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)