Archiving Data

This chapter provides an overview of data archiving and discusses how to:

• Manage the Data Archive Manager

• Run the Data Archive Manager

Archiving Global Payroll Data

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 Enterprise PeopleTools PeopleBook: Data Management, Using PeopleSoft Data Archive Manager

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 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.

Delivered Archive Queries

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.

Delivered Archive Templates

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.

Managing the Data Archive Manager

This section discusses how to:

• Manage archive objects.

• Manage archive templates.

Pages Used to Managing the Data Archive Manager

Managing Archive Objects

Access the Manage Archive Objects page.

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

Managing Archive Templates

Access the Manage Archive Templates page.

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

Running the Data Archive Manager

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.

Pages Used to Run the Data Archive Manager

Defining an Archive Job for Global Payroll Data

Access the Archive Data To History page.

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:

1. Select the archive template you want to use.

2. Select a process type of Selection to copy data from the Global Payroll result tables to their corresponding history tables.

3. 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.

4. 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.

5. Click Run to initiate the selection process.

6. Use the Audit Archiving page to confirm the results of the selection process.

7. Return to the Archive Data to History page.

8. Select a process type of Delete to delete the data you just copied to history tables.

9. Select the batch ID of the selection process you ran.

10. Click Run to initiate the deletion process.

11. 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

Defining Query Bind Variables

Access the Define Archive Query Binds 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

Viewing Archive Job Results

Access the Audit Archiving page.

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