BI_SUM_FLD_VW

(SQL View)
 Index Back

Summarized by Field Prompt

Prompt View for Summarized by Field and associated field description.

SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B , PSDBFIELD C WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME = C.FIELDNAME AND B.DEFAULT_LABEL = 1 AND A.RECNAME IN ('BI_LINE', 'PC_CF1_N_SBR') AND (C.FIELDTYPE IN (2, 4) OR (C.FIELDTYPE = 0 AND C.LENGTH <> 1) OR (C.FIELDTYPE = 0 AND C.LENGTH = 1 AND A.DEFFIELDNAME NOT IN ('Y', 'N'))) AND NOT EXISTS ( SELECT 'X' FROM PS_BI_FUNC_FNAME D WHERE D.FIELDNAME = C.FIELDNAME AND D.FUNCTION_CD = 'SU')

  • Related Language Record: BI_SUM_FLD_LVW

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