RB_VRTY_PG_AOPT

(SQL Table)
 Index Back

Page Level Configuration

Page 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 DISPLAY_STOPWORD Character(1) VARCHAR2(1) NOT NULL Display Stop word flag to sipaly stop words/noise words at runtime

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

11 PROXIMITY_FACTOR Number(4,0) SMALLINT NOT NULL Proximity factor
12 MAX_TRANSFORMATION Number(3,0) SMALLINT NOT NULL Maximum Transformations
13 ALTERNATE_SPELLING Character(1) VARCHAR2(1) NOT NULL Alternate spellings for Verity

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit