Archive Query

Archive query definitions define the selection criteria to archive data from the database tables.

Archive Queries are defined only for base tables because nonbase tables are archived based on the archived data of the related base table.

Data Archive Manager uses PeopleSoft Query to define selection criteria for the base table of the base archive object. For example, you might choose to archive all rows in KK_BUDGET_HDR where business unit is FRA01.

There are many possible permutations of prompt and inclusion or exclusion logic. Always modify delivered queries or create new archive queries using the information provided in PeopleTools documentation. Do not use the delivered queries as is in your production environment because they are for examples only.

Query Name	Description of Prompt and Exclusion Logic
KK_ARCHIVE_ACTIVITY	This activity archive query is created with the Prompt of Process Instance, Business Unit From/To, and Transaction Date. No exclusion logic is included. Note: For the Archive Query used with CC Activity Archive, the first Prompt field must be Process Instance. The preprocess populates it with a value for the subsequent archive process to be used.
KK_ARCHIVE_ACTIVITY_EXCL1	This activity archive query has the same Prompt as above, but it joins the PO_HDR table to exclude purchase orders with statuses other than completed or canceled. Note: For the Archive Query used with CC Activity Archive, the first Prompt field has must be Process Instance. The preprocess populates it with a value for the subsequent archive process to use.
KK_ARCHIVE_LEDGER	This ledger archive query has the Prompt of Business Unit From/To, Ledger Group From/To, and Fiscal Year. No exclusion logic is included.
KK_ARCHIVE_LEDGER_EXCL1	This ledger archive query has the same Prompt as above, but only include budgets in the archive for which you have run the budget close process.
KK_ARCHIVE_LEDGER_EXCL2	This ledger archive query has the same Prompt as above, but only includes budgets for which the commitment control activity is archived.
KK_ARCHIVE_JOURNAL	This journal archive is defined with the Prompt of Business Unit From/To, Ledger Group From/To, and Journal Date. No exclusion is included.