Understanding the Delivered Data Archive Templates for Benefits Administration
Data archiving is necessary to manage the increasing amount of event data created in Benefits Administration. PeopleSoft PeopleTools delivers an archiving tool called the Data Archive Manager. To use this tool to archive Benefits Administration data correctly, you should have a good understanding of the data you are trying to archive and the corresponding table structures. To aid you in archiving your result data, PeopleSoft Benefits Administration delivers predefined archive objects, queries, and templates.
Note: Please use extreme caution when making changes to delivered archive objects, queries, or templates. Any modifications can result in the loss of important data.
See “Using PeopleSoft Data Archive Manager” in PeopleTools: Data Management product documentation.
Delivered Archive Objects
An archive object is a collection of tables that you archive. The object definition determines how you archive data from a table.
PeopleSoft Benefits Administration delivers one archive object (BAS_PARTIC_ARCHIVE) that contains a list of all of BAS_PARTIC transaction tables and transaction history tables. BAS_PARTIC is the base record.
Delivered Archive Query
PeopleSoft Data Archive Manager uses queries to define selection criteria from the base table of the base archive object. PeopleSoft Benefits Administration delivers the archive query, BAS_PARTIC_AR_QRY.
Delivered Archive Template
Archive templates link archive objects and archive queries together. PeopleSoft Benefits Administration delivers one archive template (BAS_PART) that references the Benefits Administration Core archive object and the two archive queries.
Delivered Archive Jobs
PeopleSoft Data Archive Manager uses queries to define archive jobs to archive data to history. Before you submit an archive job, you must first define the archive job information including the Archive Template, Archive Process, and Commit Processing. You can submit archive jobs in a batch using the process scheduler. As part of the process, PeopleSoft Data Archive Manager prompts you for run time parameters such as bind variables and the query to use.
Delivered Archive Restore Query
PeopleSoft Data Archive Manager uses queries to define restore jobs to restore any subset of archived data to production tables. As with Archive Jobs, you must first define the job information, and then run the job using the process scheduler. PeopleSoft Benefits Administration delivers the archive restore query, BAS_PARTIC_RS_QRY.