OPRIDSDK_SRCHSV_IDDefault Value: 0
SDK_SRCH_SAVE(SQL Table) |
Index Back |
|---|---|
SDK Saved Searches MasterSDK Saved Searches Master |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SDK_SRCHSV_ID |
Number(2,0) | SMALLINT NOT NULL |
SDK Saved Searches Numeric Identifier
Default Value: 0 |
| 3 | SDK_SRCHSV_TITLE | Character(30) | VARCHAR2(30) NOT NULL | SDK Saved Search Title |
| 4 | SDK_DESCR | Character(30) | VARCHAR2(30) NOT NULL | SDK Description |
| 5 | SDK_SRCHSV_QUERY | Long Character | CLOB NOT NULL | SDK Saved Search Query String - Saved Searches Keywords that are to be searched upon. |