AFF_CF_PRMPT_VW

(SQL View)
 Index Back

Affiliate Chartfield Prompt

Prompt for Affiliate Chartfield

SELECT A.FIELDNAME , A.LONGNAME FROM PSDBFLDLABL A , PS_FS_CF_TEMPLATE B WHERE A.DEFAULT_LABEL = 1 AND B.FIELDNAME = A.FIELDNAME AND B.CF_ACTIVE_STATUS = 'A' AND B.CF_TYPE <> 'A' AND B.FIELDNAME NOT IN ('BUSINESS_UNIT_PC','ACTIVITY_ID','RESOURCE_TYPE','RESOURCE_CATEGORY','RESOURCE_SUB_CAT')

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