Understanding Archive Objects Definitions, Query Definitions, and Template Definitions
PeopleSoft Contracts delivers history tables, archive object definitions, archive query definitions, and archive template definitions to archive contract data. You can modify the archive definitions, if needed, using the Data Archive Manager. You can also create your own archive definitions to archive other types of data.
Archive Object Definitions
Each table from which you archive data must be associated with a history table. An archive object definition identifies the tables that contain the data to archive and the history tables that are updated for each table.
Base tables contain all key fields by which data is archived from all other tables in the archive object. Each archive object has only one base table. PeopleSoft Contracts delivers one archive object that contains multiple archiving records. The CA_CONTR_HDR is the base table for the multiple archiving records.
PeopleSoft Contracts delivers the following archive object and corresponding description:
Term |
Definition |
---|---|
Archive Object |
CA_ARCHIVE_001 |
Archive Object Description |
Contracts Archive Object |
The table lists the archiving records and corresponding archiving history tables for the archive object (CA_ARCHIVE_001). PeopleSoft Contracts updates the relevant history tables (based on the type of data that you are archiving) when you run the selection process:
Archiving Record |
Archive History Table |
---|---|
CA_CONTR_HDR (base table) |
CA_CONTR_HDR_H (base table) |
CA_ACCTG_LINE |
CA_ACCTG_LINE_H |
CA_ACCTG_LN_PC |
CA_ACCTG_LN_P_H |
CA_ACCTG_LN_TXN |
CA_ACCTG_LN_T_H |
CA_ACCTPLAN |
CA_ACCTPLAN_H |
CA_ACCTPLN_LANG |
CA_ACCTPLN_LA_H |
CA_AP_DFR |
CA_AP_DFR_H |
CA_AP_DST |
CA_AP_DST_H |
CA_AP_EVENT |
CA_AP_EVENT_H |
CA_AP_EVENT_DTL |
CA_AP_EVENT_D_H |
CA_AP_EVT_CHG |
CA_AP_EVT_CHG_H |
CA_AP_FEE_ADJ |
CA_AP_FEE_ADJ_H |
CA_AP_FEE_WS |
CA_AP_FEE_WS_H |
CA_AP_PC_DFR |
CA_AP_PC_DFR_H |
CA_AP_PC_DST |
CA_AP_PC_DST_H |
CA_AP_PC_UAR |
CA_AP_PC_UAR_H |
CA_AP_SCHEDULE |
CA_AP_SCHEDUL_H |
CA_AP_TXN_DST |
CA_AP_TXN_DST_H |
CA_AP_TXN_UAR |
CA_AP_TXN_UAR_H |
CA_AP_UAR |
CA_AP_UAR_H |
CA_ATTACHMENTS |
CA_ATTACHMENT_H |
CA_BILL_PLAN |
CA_BILL_PLAN_H |
CA_BILLPLN_LANG |
CA_BILLPLN_LA_H |
CA_BONUS_PENALTY |
CA_BONUS_PENAL_H |
CA_BP_EVENTS |
CA_BP_EVENTS_H |
CA_BP_EVT_CHG |
CA_BP_EVT_CHG_H |
CA_BP_EVT_LN |
CA_BP_EVT_LN_H |
CA_BP_FEE_ADJ |
CA_BP_FEE_ADJ_H |
CA_BP_FEE_WS |
CA_BP_FEE_WS_H |
CA_BP_LINES |
CA_BP_LINES_H |
CA_BP_NOTE |
CA_BP_NOTE_H |
CA_BP_SCHEDULE |
CA_BP_SCHEDUL_H |
CA_BP_XREF |
CA_BP_XREF_H |
CA_CHG_DTL |
CA_CHG_DTL_H |
CA_CHG_HDR |
CA_CHG_HDR_H |
CA_CONTR_HDR_DC |
CA_HDR_DC_H |
CA_DETAIL |
CA_DETAIL_H |
CA_DETAIL_APPOR |
CA_DETAIL_APP_H |
CA_DETAIL_DC |
CA_DETAIL_DC_H |
CA_DETAIL_DFR |
CA_DETAIL_DFR_H |
CA_DETAIL_DST |
CA_DETAIL_DST_H |
CA_DETAIL_LANG |
CA_DETAIL_LAN_H |
CA_DETAIL_PRICE |
CA_DETAIL_PRI_H |
CA_DETAIL_PROJ |
CA_DETAIL_PRO_H |
CA_DETAIL_REDUC |
CA_DETAIL_RED_H |
CA_DETAIL_UAR |
CA_DETAIL_UAR_H |
CA_DST_ERR |
CA_DST_ERR_H |
CA_DTL_DST_DATE |
CA_DTL_DST_DA_H |
CA_DTL_RED_DATE |
CA_DTL_RED_DA_H |
CA_EARLY_OPTION |
CA_EARLY_OPTI_H |
CA_EMAIL_CONTR |
CA_EMAIL_CONT_H |
CA_EMAIL_CONTR2 |
CA_EMAIL_CON2_H |
CA_FC_MAIN |
CA_FC_MAIN_H |
CA_FC_STG_RUN |
CA_FC_STG_RUN_H |
CA_HDR_AE_ACCT |
CA_HDR_AE_ACC_H |
CA_HDR_COMM |
CA_HDR_COMM_H |
CA_HDR_REDUCTS |
CA_HDR_REDUCT_H |
CA_HDRRED_LANG |
CA_HDRRED_LAN_H |
CA_LMT_FEE_DTL |
CA_LMT_FEE_DT_H |
CA_LMT_TXN |
CA_LMT_TXN_H |
CA_LMT_TXN_LG |
CA_LMT_TXN_LG_H |
CA_LN_REDUCTS |
CA_LN_REDUCTS_H |
CA_LNRED_LANG |
CA_LNRED_LANG_H |
CA_MILESTONE |
CA_MILESTONE_H |
CA_MS_COND |
CA_MS_COND_H |
CA_NOTE |
CA_NOTE_H |
CA_NOTE_DETAIL |
CA_NOTE_DETAI_H |
CA_NOTE_TRANS |
CA_NOTE_TRANS_H |
CA_OPRID_CONTR |
CA_OPRID_CONT_H |
CA_PGP_COSTS |
CA_PGP_COSTS_H |
CA_PGP_PROJ |
CA_PGP_PROJ_H |
CA_PGP_TERMS |
CA_PGP_TERMS_H |
CA_PGP_WKS |
CA_PGP_WKS_H |
CA_PREPAID_AUD |
CA_PREPAID_AU_H |
CA_PREPAID_PROJ |
CA_PREPAID_PR_H |
CA_PREPAID_TBL |
CA_PREPAID_TB_H |
CA_PROJ_SUMMARY |
CA_PROJ_SUMMA_H |
CA_RATE |
CA_RATE_H |
CA_RECON_BI |
CA_RECON_BI_H |
CA_RECON_REV |
CA_RECON_REV_H |
CA_RNW_APPLIES |
CA_RNW_APPLIE_H |
CA_RNW_LN_LINK |
CA_RNW_LN_LIN_H |
CA_SUPPORT_TEAM |
CA_SUPPORT_TE_H |
CA_WTH_REL_LANG |
CA_WTH_REL_LA_H |
CA_WTH_RELEASE |
CA_WTH_RELEAS_H |
CA_DET_REV_PRCE |
CA_DET_REVPRI_H |
CA_PRC_ADJ_DTL |
CA_PRC_ADJ_H |
CA_PRC_ADJ_LANG |
CA_PRC_ADJ_LG_H |
The archive history tables are identical copies of the transaction tables. Data in archive history tables is keyed by the archive template—also known as archive ID—and batch number for an archive run. You can run a query on the archive history tables if you want to see all transactions that are selected to archive.
You may not want to delete data from the history tables each time that you select and delete data from the transaction tables. This way the data will be available for a period of time to enable you to restore the data into the transaction tables. Oracle recommends that you create a schedule for deleting data from the history tables. Before you delete data from the history tables, use a database utility to copy the contents to a flat file.
Important! If you select incorrect data to archive, use the Data Archive Manager to remove the data from the archive history tables before you rerun the archive selection process.
Archive Query Definitions
Each archive query definition defines the selection criteria to archive data from transaction tables. The following table lists the archive query definitions that PeopleSoft Contracts delivers.
Query Name |
Description |
---|---|
CA_BY_BU |
Archive Contracts By BU |
CA_BY_BU_AND_CONTRACT_LIST |
Archive By Contract List |
CA_BY_BU_AND_SOLD_TO_CUSTOMER |
Archive By Sold to Customer |
Review these queries to determine whether you want to add additional selection criteria for the transactions that are to be archived.
Archive Template Definitions
To archive data, you select an archive template definition on the Archive Data to History run control page. Each archive template definition includes one or more archive object definitions and archive query definitions that are used to select the data.
This table lists the archive template definition that PeopleSoft Contracts delivers:
Archive Template |
Description |
Archive Object |
Query Name |
---|---|---|---|
CA_001 |
Contracts Archive Template |
CA_ARCHIVE001 (base object) |
CA_BY_BU CA_BY_BU_AND_CONTRACT_LIST CA_BY_BU_AND_SOLD_TO_CUSTOMER |
Users manage historical data by archive template and batch number of the run control. This granularity enables users to selectively roll back an archive process, if necessary, rather than rolling back all of the data in the history table.