This chapter provides an overview of data archiving and discusses how to:
Manage the Data Archive Manager
Run the Data Archive Manager
Global Payroll generates a large amount of result data. To maintain a detailed audit trail, it is often necessary to keep this data for compliance purposes. Usually the amount of data that needs to be saved is greater than the amount that is actually required to be referenced actively. To keep the amount of saved data manageable, you might choose to archive it periodically.
PeopleSoft PeopleTools delivers an archiving tool called the Data Archive Manager. To use this tool to archive Global Payroll result data correctly, you should have a solid understanding of the data you are trying to archive and the corresponding table structures. To aid you in archiving your result data, PeopleSoft Global Payroll 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 PeopleTools: Data Management PeopleBook, Using PeopleSoft Data Archive Manager
An archive object is a collection of tables that you archive. The object definition determines how you archive data from a table.
PeopleSoft Global Payroll delivers one archive object (GP_RSLT_ARCHIVE) that contains a list of all of the Global Payroll Core result tables to be archived. In addition, PeopleSoft Global Payroll delivers an archive object for each Global Payroll country extension. These archive objects contain lists of the country-specific tables to be archived. Each country-specific archive object is named GPxx_RSLT_ARCHIVE, where xx is the 2 character ISO country code.
Note. Please refer to your country-specific documentation for more information on the specific tables included in the country-specific archive objects.
PeopleSoft Data Archive Manager uses queries to define selection criteria from the base table of the base archive object. PeopleSoft Global Payroll delivers two archive queries:
GP_CAL_RUN_SNGL
GP_CAL_RUN_MULT
Both queries select data to archive based on calendar group ID (CAL_RUN_ID). GP_CAL_RUN_SNGL selects data for one specific calendar group ID while GP_CAL_RUN_MULT selects records for all calendar groups finalized on or before a specified calendar group.
Note. You archive data for only one country at a time. You specify the country when you run the selection process using the Data Archive Manager.
Archive templates link archive objects and archive queries together. PeopleSoft Global Payroll delivers one archive template (GPRSLT) that references the Global Payroll Core archive object and the two archive queries. In addition, PeopleSoft Global Payroll delivers an archive template for each Global Payroll country extension that references the Global Payroll Core archive object, the country specific archive object, and the two archive queries. Each country-specific archive template is named GPxxRSLT, where xx is the 2 character ISO country code.
This section discusses how to:
Manage archive objects.
Manage archive templates.
Page Name |
Definition Name |
Navigation |
Usage |
PSARCHOBJDEFN |
PeopleTools, Data Archive Manager, Manage Archive Objects, Manage Archive Objects |
Group archive records into archive objects. |
|
PSARCHTEMPDEFN |
PeopleTools, Data Archive Manager, Manage Archive Templates, Manage Archive Templates |
Define archive templates. |
Access the Manage Archive Objects page (PeopleTools, Data Archive Manager, Manage Archive Objects, Manage Archive Objects).
Use this page to view the tables and associated history tables defined for the delivered archive objects.
See Also
Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Managing Archive Objects
Access the Manage Archive Templates page (PeopleTools, Data Archive Manager, Manage Archive Templates, Manage Archive Templates).
Use this page to view the archive objects and archiving queries associated with the delivered archive templates.
See Also
Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Managing Archive Templates
This section provides an overview of using the Data Archive Manager and discusses how to:
Define an archive job for Global Payroll data.
Define query bind variables.
Page Name |
Definition Name |
Navigation |
Usage |
PSARCHRUNCNTL |
PeopleTools, Data Archive Manager, Archive Data To History |
Define archive jobs. |
|
PSARCHRUNQRYBND |
Click the Define Binds link on the Archive Data To History page. |
Define the archive query bind variables for the archiving process. |
|
PSARCHEXAMRUNCNTL |
Click the View Details link on the Archive Data To History page. |
View details about the data you are archiving. See Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Archiving Data to History, Viewing Details |
|
PSARCHIVEAUDIT |
PeopleTools, Data Archive Manager, Audit Archiving, Audit Archiving |
View the results of an archive job. See Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Auditing Archive Processes |
Access the Archive Data To History page (PeopleTools, Data Archive Manager, Archive Data To History).
Data Archiving Processes
You can use the Archive Data To History page to run four different processes:
Selection: Copies data from transaction tables to history tables.
Delete: Deletes data from transaction tables only if they have already been archived in the history tables.
Rollback: Copies data from history tables back to transaction tables.
Remove from History: Deletes data from the history tables.
Note. Typically you will use only the Selection and Delete processes during your regular data archiving activities.
Archiving Global Payroll Data
To archive Global Payroll data:
Select the archive template you want to use.
Select a process type of Selection to copy data from the Global Payroll result tables to their corresponding history tables.
To archive data for a single calendar group, select the GP_CAL_RUN_SNGL selective query.
To archive data for multiple calendar groups, select the GP_CAL_RUN_MULT selective query.
Click the Define Binds link to access the Define Archive Query Binds page where you select a calendar group and country as bind variables for the archive process. If you are using the GP_CAL_RUN_MULT query, the archive process selects the data for all calendar groups finalized on or before the date defined for the calendar group ID that you select.
Click Run to initiate the selection process.
Use the Audit Archiving page to confirm the results of the selection process.
Return to the Archive Data to History page.
Select a process type of Delete to delete the data you just copied to history tables.
Select the batch ID of the selection process you ran.
Click Run to initiate the deletion process.
Use the Audit Archiving page to confirm the results of the deletion process.
See Also
Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Archiving Data to History, Defining Archive Jobs
Access the Define Archive Query Binds page (click the Define Binds link on the Archive Data To History page).
Click the Reset Query Bind Variables button to select a country and calendar group as bind variables for the data archive process. Once you select a country and calendar group, the View Details link becomes available on the Archive Data to History page that enables you to view the information to be archived.
See Also
Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Archiving Data to History, Defining Archive Query Binds
Access the Audit Archiving page (PeopleTools, Data Archive Manager, Audit Archiving, Audit Archiving).
Use this page to view the results of your archive jobs.
See Also
Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager, Auditing Archive Processes