BI_FSCF_TMPLTVW

(SQL View)
 Index Back

SELECT ORIG_CF_NAME , FIELDNAME FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS = '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 ORIG_CF_NAME Character(18) VARCHAR2(18) NOT NULL Holds the Original Chartfield Name. This will not change!
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).