AM_CF_TMPL1_VW

(SQL View)
 Index Back

SELECT FIELDNAME FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS = 'A' AND CF_TYPE <> 'A' AND ORIG_CF_NAME NOT IN ('ACTIVITY_ID', 'BUSINESS_UNIT_PC', 'RESOURCE_CATEGORY', 'RESOURCE_SUB_CAT', 'RESOURCE_TYPE')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).