RB_VRTY_UR_AOPT

(SQL Table)
Index Back

User Configuration

User Level Configuration Table for Verity options in Advance mode

# 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).

Prompt Table: PSOPRDEFN

3 DISPLAY_STOPWORD Character(1) VARCHAR2(1) NOT NULL Display Stop word flag to sipaly stop words/noise words at runtime

Y/N Table Edit

4 ALL_WORDS Character(1) VARCHAR2(1) NOT NULL Checkbox for with all words option

Y/N Table Edit

5 ANY_WORDS Character(1) VARCHAR2(1) NOT NULL Any words search text type

Y/N Table Edit

6 EXACT_PHRASE Character(1) VARCHAR2(1) NOT NULL Exact phrase search text type

Y/N Table Edit

7 WITHOUT_WORDS Character(1) VARCHAR2(1) NOT NULL without words search text type

Y/N Table Edit

8 WORDS_SENTENCE Character(1) VARCHAR2(1) NOT NULL Words in sentence search text type

Y/N Table Edit

9 WORDS_SAME_ORDER Character(1) VARCHAR2(1) NOT NULL Words in same order searchtext type

Y/N Table Edit

10 WORDS_PROXIMITY Character(1) VARCHAR2(1) NOT NULL Words in proximity searchtext type

Y/N Table Edit

11 WORDS_PARAGRAPH Character(1) VARCHAR2(1) NOT NULL Words in a Paragraph searchtext type

Y/N Table Edit

12 ALTERNATE_SPELLING Character(1) VARCHAR2(1) NOT NULL Alternate spellings for Verity

Y/N Table Edit

13 USE_STEMMINGS Character(1) VARCHAR2(1) NOT NULL Stemmings for Verity

Y/N Table Edit

14 EXACT_WORDS Character(1) VARCHAR2(1) NOT NULL Exact words for Verity

Y/N Table Edit

15 INCLUDE_SYNONYMS Character(1) VARCHAR2(1) NOT NULL use of synonyms in Verity

Y/N Table Edit

16 CASE_SENSITIVE Character(1) VARCHAR2(1) NOT NULL this field is Case Sensitive.....................

Y/N Table Edit

17 SOUNDEX_WORD Character(1) VARCHAR2(1) NOT NULL words with similar sound

Y/N Table Edit