JPM_JP_PROPS_VW

(SQL View)
 Index Back

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_PARENT_KEY_ID', '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).