Archiving Data
This topic provides overviews of the archive process flow and of history tables, and lists the pages used to archive data.
Page Name |
Definition Name |
Usage |
---|---|---|
Archive Data to History Page |
PSARCHRUNCNTL |
Select an archive template and query, and select the action you want to take in the archiving process. See Understanding the Archive Process Flow. See the product documentation for PeopleTools: Data Management for more information. |
Define Query Bind Variables Page |
PSARCHRUNQRYBND |
Click Define Binds on the Archive Data to History page. Then enter the date used to select the transactions to archive by clicking the Reset Query Bind Variables button. See Understanding the Archive Process Flow. See the product documentation for PeopleTools: Data Management for more information. |
Audit Archiving Page |
PSARCHIVEAUDIT |
View the number of rows selected to be archived for each table for a specific archive run. Click Define Binds on the Archive Data to History page. Then enter the date used to select the transactions to archive by clicking the Reset Query Bind Variables button. See Understanding the Archive Process Flow. See the product documentation for PeopleTools: Data Management for more information. |
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 and generating archive candidate reports.
Navigation:
Perform these tasks to archive data:
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 (PSARCHRUNCNTL).
Also, enter the archive date (or statement ID for the statement archive process) used to select the transactions by clicking Reset Query Bind Variables on the Define Query Bind Variables page (PSARCHRUNQRYBND).
This table shows what the system compares the archive date to for the different data types:
Data Type
Archive Date
Pending item data
Accounting date for the pending item group.
Payment data
Accounting date for the deposit.
Posted item data
Accounting date for the item.
Direct debit data
Cash posting date or cancellation posting date for the direct debit.
Action list data
Date that the action was added.
Statement data
Statement ID for the statement.
Note: You can run the process multiple times to create various what-if scenarios based on the archive date.
(Optional) Review the number of rows that were selected for archiving for each table on the Audit Archiving page (PSARCHIVEAUDIT) (
).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.
(Optional) Run the archive candidate reports delivered with PeopleSoft Receivables to see a list of the transactions that were selected in the transaction tables and copied to the history tables.
Delete the data from the transaction tables for a specific archive ID (template) and batch number on the Archive Data to History page.
(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 if you deleted the transaction data in error.
Remove the transaction data from the history tables for a specific archive ID (template) and batch number on the Archive Data to History page.
PeopleSoft Receivables updates these history tables when you run the selection process:
Data to Archive |
History Tables |
---|---|
Pending item data |
|
Payment data |
|
Posted item data |
|
Direct debit data |
|
Action list data |
PS_AR_ACTION_LST_H |
Statement data |
|
The data in these tables is keyed by the archive ID (template) and batch number for each archive run. If you want to see all transactions that are selected to archive, you can run a query on the history tables or you can run one of the PeopleSoft Receivables archive candidate reports.
You may not want to delete data from the history tables each time that you select and delete data from the transaction tables. This way, the data will be available for a period of time to enable you to restore the data into the transaction tables. Oracle suggests that you create a schedule for deleting data from the history tables. Before you delete data from the history tables, you should use a database utility to copy the contents to a flat file.
Important! If you decide to run the archive selection process again because you did not select the correct data, you must first use the Data Archive Manager option to remove the data from the history tables.