RB_SRCHIDX_HDLG (SQL View)	Index Back
Verity Search Index Template Search Index Template Header record - used to save the Index Template record name and an associated where clause used to screen out record occurences when the Search Collection is build

RB_SRCHIDX_HDLG

(SQL View)

Verity Search Index Template

Search Index Template Header record - used to save the Index Template record name and an associated where clause used to screen out record occurences when the Search Collection is build

SELECT A.srch_COLLECTN_NAME ,A.RECNAME ,B.LANGUAGE_CD ,B.RECDESCR ,A.RB_WHERE_CLAUSE FROM PS_RB_SRCHIDX_HDR A , PSRECDEFNLANG B WHERE A.RECNAME = B.RECNAME

Related Language Record for RB_SRCHIDX_HDVW

# 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: PSRECDEFNRVW

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description

5 RB_WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Contains SQL where clause that is used at the time the Search Index data is created to select only those record occurrences that meet the where clause criteria

#	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: PSRECDEFNRVW
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description
5	RB_WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Contains SQL where clause that is used at the time the Search Index data is created to select only those record occurrences that meet the where clause criteria