GM_PT_CFS_VW

(SQL View)
 Index Back

F&A CS CFs Prompt Table


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

  • Related Language Record: GM_PT_CFS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_GROUP_BY Character(18) VARCHAR2(18) NOT NULL Budget Group by
    2 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name