SEARCH_ORDR_SQL (SQL Table)	Index Back
Search Order SQL The SEARCH_ORDR_SQL table contains the SQL_GENERATED field from SEARCH_ORDR_TBL broken down into 80 character sections.

SEARCH_ORDR_SQL

(SQL Table)

Search Order SQL

The SEARCH_ORDR_SQL table contains the SQL_GENERATED field from SEARCH_ORDR_TBL broken down into 80 character sections.

# 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 SEARCH_SQL_TYPE Character(1) VARCHAR2(1) NOT NULL Search SQL Type
C=COBOL
O=On Line
S=SQR
Default Value: C

4 SEARCH_SEQ_NO Number(3,0) SMALLINT NOT NULL Search Sequence Number

5 SQL_TEXT Character(80) VARCHAR2(80) NOT NULL SQL Text

#	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	SEARCH_SQL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search SQL Type C=COBOL O=On Line S=SQR Default Value: C
4	SEARCH_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	Search Sequence Number
5	SQL_TEXT	Character(80)	VARCHAR2(80) NOT NULL	SQL Text