Managing Archive Templates

This section discusses how to manage archive templates.

Access the Manage Archive Templates page (PeopleTools > Data Archive Manager > Manage Archive Templates).

Image: Manage Archive Templates page

This example illustrates the fields and controls on the Manage Archive Templates page.

Manage Archive Templates page

Archive Template Objects

Field or Control

Definition
Base Object

Select this check box if the archive object that you select is the base object of this archive template. Be definition, there can only be one base object per archive template. Data from tables in non-base objects are archived based on archived data from the link table in the base object.
Archive Object

Insert from the list of archive objects previously defined in the database.
Description

Displays the description of the query.
Link Record

If the archive object is not a base object, a link record must be defined. Similar to the concept of a foreign key constraint, the link table is used to “link” data between the base record of the non-base objects to archived data of any record in the base object. By this definition, only records that are defined in the base object of the archive template can be used as link records.

Queries Run on Archive Objects

Field or Control

Definition
Query Name

Select from a list of queries defined in the template. The selection determines how PeopleSoft Data Archive Manager will generate the where clause for the base table of the base object at runtime. Only queries of the type Archive or Restore can be defined in the Archive Template. You can insert multiple archive or restore queries into the template.
Description

Displays the description of the query.

Queries Run on Restore Objects

Field or Control

Definition
Query Name

Select from a list of queries defined in the template. The selection determines how PeopleSoft Data Archive Manager will generate the where clause for the base table of the base object at runtime. Only queries of the type Archive or Restore can be defined in the Archive Template. You can insert multiple archive or restore queries into the template.
Description

Displays the description of the query.

AE Processes

Field or Control

Definition
Archive Process

Specify a PeopleSoft Application Engine archive process. Valid options are:

  • Archive Selection

  • Archive Delete

  • Archive Rollback

  • Remove from History

You can define different Application Engine (AE) programs to run for each of the archiving processes. For example, you can define an Application Engine program called SEL_PRE that creates summary data in a work table before the Archive Selection process (Pre-AE) is executed. If you perform a rollback, you might want to create an Application Engine program called RBK_POST that executes after the Archive Rollback process (Post-AE) to remove the summary data in the work table.
Pre AE Program

Select the custom Application Engine program that you want to run against your data before archiving.
Post AE Program

Select the custom Application Engine programs that you want to run against your data after archiving.