Refresh Summary Tables

The PeopleSoft system delivers these summary tables that are used internally by PeopleSoft Project Costing and PeopleSoft Program Management for analytical reporting:

  • Project Transactions Summary (PC_ACTIVITY_SUM).

    This table is used by flexible analysis reporting.

  • Project Transactions Summary (PC_SUMMARY_TBL).

    This table is used by PeopleSoft Project Costing and PeopleSoft Program Management analytics, including estimate to complete, earned value, forecasting, and project valuation.

  • Summary Budget Data (PC_BUD_SUMMARY).

    This table is used by budget versus actual, budget item analysis, and percent complete analyses.

All transactions that enter the Project Transaction table—whether from feeder systems, direct entry through the Add Transactions component (INTFC_PROJ_EXPRESS), or through the Load Third-Party Transactions Application Engine process (PC_INTFEDIT)—trigger the Refresh Summary Tables Application Engine process (PC_SUM_RFSH) to populate all necessary summary tables.