Understanding Archive Objects Definitions, Query Definitions, and Template Definitions
PeopleSoft Expenses delivers archive object definitions, query definitions, and template definitions to archive:
Travel authorization transaction data.
Travel authorization approval data.
Cash advance transaction data.
Cash advance approval data.
Expense transaction data.
Expense approval data.
Time report transaction data.
Time report approval data.
DCAA audit transaction data.
Time report project resource data.
My Wallet data.
Account entry data.
Approval history 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 Expenses delivers these archive objects:
|
Data Type |
Archive Object |
|---|---|
|
Travel authorization transaction data |
EX_TRAVELAUTH |
|
Travel authorization approval data |
EX_TRAVELAUTH_APPR_DATA |
|
Cash advance transaction data |
EX_EXADVANCE |
|
Cash advance approval data |
EX_EXADVANCE_APPR_DATA |
|
Expense report transaction data |
EX_EXSHEET |
|
Expense report approval data |
EX_EXSHEET_APPR_DATA |
|
Time report transaction data |
EX_TIMEREPORT |
|
Time report approval data |
EX_TIMEREPORT_APPR_DATA |
|
DCAA audit transaction data |
EX_AUDIT_DCAA |
|
Time report project resource data |
EX_TIME_PRJ_RESOURCE |
|
My Wallet transaction data |
EX_MYWALLET |
|
My Wallet enhanced data |
EX_MYWALLET_ENHC EX_MYWALLET_ENHCAMX (for American Express) |
|
Accounting line data |
EX_ACCOUNTING |
|
Approval history data |
EX_APPROVAL_HIST |
Archive Query Definitions
Each archive query definition defines the selection criteria to archive data from transaction tables. PeopleSoft Expenses delivers these archive queries:
|
Data Type |
Archive Query |
|---|---|
|
Travel authorization transaction data |
EX_TAUTH_ARCH |
|
Travel authorization approval data |
EX_TAUTH_APPR_DATA_ARCH |
|
Cash advance transaction data |
EX_ADV_ARCH |
|
Cash advance approval data |
EX_ADV_APPR_DATA_ARCH |
|
Expense report transaction data |
|
|
Expense report approval data |
EX_EXSHT_APPR_DATA_ARCH |
|
Time report transaction data |
EX_TIME_ARCH |
|
Time report approval data |
EX_TIME_APPR_DATA_ARCH |
|
DCAA audit transaction data |
EX_AUDIT_DCAA_ARCH |
|
Time report project resource data |
EX_TIME_PRJRES_ARCH |
|
My Wallet transaction data |
EX_MYWALLET_ARCH |
|
Accounting line data |
EX_ACCTG_ARCH |
|
Approval history data |
EX_APPROVAL_HIST_ARCH |
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 Expenses delivers these archive templates:
|
Data Type |
Archive Template |
|---|---|
|
Travel authorization transaction data |
EX_TAUTH |
|
Travel authorization approval data |
EX_TA_AD |
|
Cash advance transaction data |
EX_EXADV |
|
Cash advance approval data |
EX_CA_AD |
|
Expense report transaction data |
EX_EXSHT |
|
Expense report approval data |
EX_ER_AD |
|
Time report transaction data |
EX_TIME |
|
Time report approval data |
EX_TR_AD |
|
DCAA audit transaction data |
EX_DCAA |
|
Time report project resource data |
EX_PRJRS |
|
My Wallet data |
EX_MYWAL |
|
Accounting line data |
EX_ACCTG |
|
Approval history data |
EX_APPR |