RB_SRCHIDX_HDVW (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_HDVW

(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.RECDESCR ,A.RB_WHERE_CLAUSE FROM PS_RB_SRCHIDX_HDR A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME

Related Language Record: RB_SRCHIDX_HDLG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SRCH_COLLECTN_NAME Character(28) VARCHAR2(28) NOT NULL Search Collection Name
Prompt Table: RB_SRCH_PARMS

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW

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

4 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 Prompt Table: RB_SRCH_PARMS
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFNPVW
3	RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description
4	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