JPM_SRCH_FLD_VW (SQL View)	Index Back
Profile Item Srch Props VW Identifies those properties available to be selected as searchable properties in the Profile Type definition.

JPM_SRCH_FLD_VW

(SQL View)

Profile Item Srch Props VW

Identifies those properties available to be selected as searchable properties in the Profile Type definition.

SELECT FIELDNAME FROM PSRECFIELDALL WHERE RECNAME = 'JPM_SRCH_ITEMS' AND FIELDNAME <> 'JPM_IMPORTANCE' AND FIELDNAME <> 'JPM_CAT_TYPE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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