PC_SUM_FD_FLDS

(SQL View)
 Index Back

Summarization Fields

This record identifies all the Project Transaction fields available for feeder summarization.

SELECT A.FIELDNAME , A.FIELDTYPE FROM PS_PC_SUM_FIELDS A WHERE A.REQUIRE_TYPE <> 'R'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)