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.