CF_MAP_VW

(SQL View)
 Index Back

Distinct SetID/ChartFields


SELECT DISTINCT A.CHARTFIELD ,B.LONGNAME FROM PS_LED_FLDS_TBL A , PSDBFLDLABL B WHERE B.FIELDNAME = A.CHARTFIELD AND B.DEFAULT_LABEL = 1 AND A.CHARTFIELD NOT IN ('AFFILIATE', 'BUSINESS_UNIT', 'CURRENCY_CD') AND A.CHARTFIELD NOT IN ( SELECT FIELDNAME FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS = 'I')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name