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 NOT IN ('JPM_IMPORTANCE', '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).