Archiving Data

This section provides an overview of the archive process flow and lists the pages used to archive data.

Page Name

Definition Name

Usage

Archive Data to History

PSARCHRUNCNTL

Select an archive template, query, and action that you want to take in the archiving process.

Define Query Bind Variables

PSARCHRUNQRYBND

Enter the date used to select the transactions to archive by clicking the Reset Query Bind Variables button.

When entering multiple values in the Contract Numbers field on the Define Query Bind Variables page, enter the contract numbers in this format: CON001','CON002', 'CON003. When PeopleTools constructs the SQL statement, it returns the contract numbers in this format: 'CON001','CON002', 'CON003'.

Audit Archiving

PSARCHIVEAUDIT

View the number of rows selected to be archived for each table for a specific archive run.

Use the Data Archive Manager to archive transactions. You use the same run control page for each step in the process except for auditing the archive selection.

Perform these tasks to archive data:

  1. Archive transaction data to the history tables by selecting the archive template and query for the data type that you want to archive on the Archive Data to History page.

    Also, enter the archive date used to select the transactions by clicking Reset Query Bind Variables on the Define Query Bind Variables page.

    Note: You can run the process multiple times to create various "what-if" scenarios based on the archive date.

  2. (Optional) Review the number of rows that were selected for archiving for each table on the Audit Archiving page.

    This page lists the number of rows that were selected for archiving for each archive ID (template), archive batch number, and table combination.

    Note: This page displays data only if you selected the Audit Row Count check box on the Archive Data to History page.

  3. Delete the data from the transaction tables for a specific archive ID (template) and batch number on the Archive Data to History page.

  4. (Optional) Roll back the transaction data from the history tables for a specific archive ID (template) and batch number on the Archive Data to History page to recover deleted data.

  5. Remove the transaction data from the history tables for a specific archive ID (template) and batch number on the Archive Data to History page.