Understanding Archive Objects Definitions, Query Definitions, and Template Definitions

PeopleSoft Receivables delivers archive object definitions, query definitions, and template definitions to archive:

Pending item data
Payment data
Posted item data
Action list data
Direct debit data
Statement data

You can modify them if needed using the Data Archive Manager. You can also use the Data Archive Manager to create your own archive object definitions, query definitions, and template definitions to archive other types of data.

Archive Object Definitions

An archive object definition identifies the tables that contain the data to be archived and the history tables that will be updated for each table. PeopleSoft Receivables delivers these archive objects:

Data Type	Archive Object
Pending item data	AR_ARCH_PENDING_ITEM
Payment data	AR_ARCH_PAYMENTS
Posted item data	AR_ARCH_ITEMS
Direct debit data	AR_ARCH_DIRECT_DEBITS
Action list data	AR_ARCH_ACTIONS
Statement data	AR_ARCH_STATEMENTS

Archive Query Definitions

Each archive query definition defines the selection criteria to archive data from transaction tables. PeopleSoft Receivables delivers these archive queries:

Data Type	Archive Query
Pending item data	AR_ARCH_PENDING_ITEM
Payment data	AR_ARCH_PAYMENTS
Posted item data	AR_ARCH_ITEM
Direct debit data	AR_ARCH_DIRECT_DEBIT
Action list data	AR_ARCH_ACTION_LST
Statement data	AR_ARCH_STATEMENTS

Review these queries to determine whether you want to add additional selection criteria for the transactions to be archived.

Archive Template Definitions

When you archive data, you select an archive template definition. Each archive template definition includes one or more archive object definitions and the archive query definitions used to select the data. PeopleSoft Receivables delivers these archive templates:

Data Type	Archive Template
Pending item data	ARPEND
Payment data	ARPYMT
Posted item data	ARITEM
Direct debit data	ARDIRDEB
Action list data	ARACTLST
Statement data	ARSTMT