SEARCH_ORDR_SQL(SQL Table) |
Index Back |
---|---|
Search Order SQLThe 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 | Character(15) | VARCHAR2(15) NOT NULL | Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition. | |
2 | 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 | Character(1) | VARCHAR2(1) NOT NULL |
Search SQL Type
C=COBOL O=On Line S=SQR Default Value: C |
|
4 | Number(3,0) | SMALLINT NOT NULL | Search Sequence Number | |
5 | SQL_TEXT | Character(80) | VARCHAR2(80) NOT NULL | SQL Text |