Understanding Archive Objects Definitions, Query Definitions, and Template Definitions

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

  • Payment data

  • Voucher data

  • Supplier data

  • Payment Request 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 are updated for each table. PeopleSoft Payables delivers these archive objects:

Data Type

Archive Object

Payment data

PAYABLES_PAYMENTS

Reconciled payment data

PAYMENT_RECON_TBL

Payment advice table

PYMNT_ADVICE

Voucher – supplier bank data

VCHR_VNDR_BANK

Voucher – supplier information data

VCHR_VNDR_INFO

Voucher data

VOUCHER

Voucher HIPAA data

VOUCHER_HIPAA

Supplier data

VENDOR

Supplier – reporting element data

VENDOR_RPT_ELEMENTS

Payment Request data

AP_PYMNT_REQUEST_ARCH

Payment Request Attachment data

AP_PYMNT_REQUEST_ATTATCH_ARCH

Payment Request Supplier Archive data

AP_PYMNT_REQUEST_VNDR_ARCH

Payment Request Message Archive data

AP_PYMNT_RQUST_CONVER_ARCH

Archive Query Definitions

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

Data Type

Archive Query

Archive all payment data

AP_ARCHIVE_PYMNT_ALL

Archive bank account data

AP_ARCHIVE_PYMNT_BANK_ACCT

Archive voucher, all business units

AP_ARCHIVE_VOUCHER_ALL

Archive voucher, business unit

AP_ARCHIVE_VOUCHER_BU

Archive all suppliers data

AP_VENDOR_ARCH_ALL

Archive suppliers by class data

AP_VENDOR_ARCH_CLASS

Archive suppliers by persistence data

AP_VENDOR_ARCH_PERS

Archive suppliers by SetID data

AP_VENDOR_ARCH_SETID

Archive suppliers by status data

AP_VENDOR_ARCH_STATUS

Payment Request Archive data

AP_PYMNT_REQUEST_ARCH

Payment Request Message Archive data

AP_PYMNT_RQUST_CONVER_ARCH

Review these queries to determine whether you want to add additional selection criteria for the transactions to be archived. Refer to the PeopleTools: PeopleSoft Query documentation if you want to create your own archive queries.

See PeopleTools: Data Management Using PeopleSoft Data Archive Manager," Defining Archive Queries

See PeopleTools: Query

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 Payables delivers these archive templates:

Data Type

Archive Template

Payment data

Payables Payment Archive (AP_PYMNT)

Voucher data

Voucher Archive (AP_VCHR)

Supplier data

Supplier Archive (AP_VNDR)

Payment Request data

Payment Request Archive (AP_PRQST)

Payment Request Message data

Payment Request Message Archive (AP_PRMSG)

Note: The AP_PYMNT and AP_VCHR Archive Templates have separate Pre and Post Processing Application Engine Programs for Archive Selection.

For AP_PYMNT, you use AP_PYA_PRE as the Pre-Processing Application Engine, and AP_PYA_POST as the Post Processing Application Engine.

For AP_VCHR, you use AP_VCH_PRE as the Pre-Processing Application Engine, and AP_VCHA_POST as the Post Processing Application Engine.

For more information, see PeopleTools: Data Management, Managing Archive Templates.