RB_VRTY_UR_BOPT(SQL Table) |
Index Back |
|---|---|
User ConfigurationUser Level Configuration Table for Verity options in Basic mode under User preferences |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEARCH_DEFN_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Search Definition Name |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SEARCHTEXT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Various searchtext types supported in Verity 8.9.
A=With all words E=With the exact phrase G=Words in a paragraph M=Words in same order O=Without the words P=Words in proximity S=Words in a sentence Y=With any words |
| 4 | WORD_VARIATION_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Different word variations types supported in Verity 8.9 , like Synonyms,Stemmings etc
A=Alternate spellings E=Exact words S=Stemmings T=Include Synonyms X=Similar Sounds |
| 5 | DISPLAY_STOPWORD | Character(1) | VARCHAR2(1) NOT NULL | Display Stop word flag to sipaly stop words/noise words at runtime |
| 6 | CASE_SENSITIVE | Character(1) | VARCHAR2(1) NOT NULL |
this field is Case Sensitive.....................
Y/N Table Edit |