INDEX_TYPEA=Address
N=Name
Prompt Table: PSPTSF_SD
Y/N Table Edit
Default Value: N
SDN_SRCH_LISTS(SQL Table) |
Index Back |
|---|---|
List of SDN indexesList of SDN indexes 04/18/2016 -- Added STOPLIST_WORDS 08/12/2019 -- Added STOPLIST_FLAG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INDEX_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Type of the SDN index
A=Address N=Name |
| 2 | PTSF_SBO_NAME | Character(65) | VARCHAR2(65) NOT NULL |
Search Definition (see PSPTSF_SD).
Prompt Table: PSPTSF_SD |
| 3 | STOPLIST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Stoplist
Y/N Table Edit Default Value: N |
| 4 | STOPLIST_WORDS | Long Character(1024) | VARCHAR2(1024) | Stoplist Words |