GM_PT_CFS2_VW

(SQL View)
 Index Back

F&A CS CFs Prompt Table


SELECT DISTINCT A.FIELDNAME ,B.LONGNAME ,B.SHORTNAME FROM PS_FS_CF_TMPLT_VW A , PSDBFLDLABL B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME NOT IN ( 'ALTACCT', 'PROJECT_ID', 'BUSINESS_UNIT_PC', 'ACTIVITY_ID' ) AND A.CF_ACTIVE_STATUS = 'A' AND B.DEFAULT_LABEL = 1

  • Related Language Record: GM_DBFLDLABLLNG

    • # 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
    3 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name