Understanding the Data Summary Process

In PeopleSoft Project Costing, you summarize data before you archive it. You use the Project Data Compression Application Engine process (PC_COMPRESS) to summarize project data into history tables. Then, you use the PeopleSoft Archive (PSARCHIVE) process to archive data from the history tables.

This topic discusses:

  • Summarization process flow.

  • Tables populated by the Project Data Compression process.

  • Summary transactions.

  • Project compression log.

PeopleSoft Project Costing keeps all life-to-date transactions for each project, resulting in a high volume of data to manage. To reduce storage needs and increase performance, you can summarize transaction data by using the Project Data Compression Application Engine process that retains project costs while deleting some detail and integration information.

The Compress Project Data (PC_COMPRESS) process compresses project transactions based on parameters from the run control. This process:

  1. Selects the transactions that are targeted for compression and saves them in history tables.

  2. Creates summary transactions and inserts them into the project transactions table.

  3. Deletes the original transactions from the project transaction table.