RB_SRCHIDX_LNVW

(SQL View)
 Index Back

Verity Search Index Tmpl View

view of search index template fields that have been flagged as index fields or search results fields

SELECT SRCH_COLLECTN_NAME , RECNAME , FIELDNAME , RB_INDEX_FLG , RB_FIELD_FLG , ATTACHMENT_LINK FROM PS_RB_SRCHIDX_LINE WHERE RB_INDEX_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SRCH_COLLECTN_NAME Character(28) VARCHAR2(28) NOT NULL Search Collection Name
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

4 RB_INDEX_FLG Character(1) VARCHAR2(1) NOT NULL Include this field
N=Exclude in Search Index
Y=Include in Search Index

Y/N Table Edit

5 RB_FIELD_FLG Character(1) VARCHAR2(1) NOT NULL Include as Search Results Field. If included, this field will be part of the Search Results returned on a Verity query.
N=Exclude from Search Result
Y=Include in Search Results

Y/N Table Edit

6 ATTACHMENT_LINK Character(1) VARCHAR2(1) NOT NULL Field contains attachment links.