SRCH_PSRCFLD_VW (SQL View)	Index Back
Search Component Record View A selection of all records which have EMPLID in the table. The search component portion of the individual search facility makes use of this table. As the search is looking for individuals, all tables used in the search need to be linked via the EMPLID. This view restricts the selection of the records appropriately.

SRCH_PSRCFLD_VW

(SQL View)

Search Component Record View

A selection of all records which have EMPLID in the table. The search component portion of the individual search facility makes use of this table. As the search is looking for individuals, all tables used in the search need to be linked via the EMPLID. This view restricts the selection of the records appropriately.

select a.recname from psrecfield a, PSRECDEFN b where a.fieldname = 'EMPLID' and a.recname = b.recname and b.rectype in (0,1,3)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).