JPM_JP_PROPS_VW (SQL View)	Index Back
Content Section Properties Displays selectable properties when adding a property to a content section in the profile type configuration.

JPM_JP_PROPS_VW

(SQL View)

Content Section Properties

Displays selectable properties when adding a property to a content section in the profile type configuration.

SELECT DISTINCT FIELDNAME FROM PSRECFIELDALL WHERE RECNAME = 'JPM_JP_ITEMS' AND FIELDNAME NOT IN ('JPM_PROFILE_ID', 'JPM_ITEM_KEY_ID', 'EVALUATION_ID', 'JPM_SOURCE_ID1', 'JPM_SOURCE_ID3', 'JPM_JP_QUAL_SET', 'JPM_JP_QUAL_SET2', 'JPM_EVAL_MTHD', 'JPM_PARENT_KEY_ID','JPM_SETID_LOC_1','JPM_SETID_LOC_2','SETID_LOCATION')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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