RC_IDX_TMPLT_VW

(SQL View)
 Index Back

Verity Search Index view

View used to Eliminate certain records from the Verify Search Header

SELECT A.RECNAME , B.RECDESCR FROM PS_RB_SRCHIDX_HDR A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME AND EXISTS ( SELECT 'X' FROM PS_RB_SRCHIDX_LINE C WHERE C.RECNAME = B.RECNAME AND C.FIELDNUM > 0)

  • Related Language Record: RC_IDXTMPLVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 DESCR40 Character(40) VARCHAR2(40) NOT NULL This is a description field that holds 40 characters.