History Tables
Commitment control delivers history tables as system data to be used with the delivered commitment control archive procedures.
You can change or configure history tables to correspond to any special requirements or configuration of your system using the PeopleSoft Application Designer and by following the instructions located in the PeopleTools documentation.
However, history tables are by definition copies of your database tables. To successfully archive and restore records and tables to and from the history tables, the history tables must mirror your specific database tables. This requirement must be considered before reconfiguring or customizing such things as ChartFields, fields, and tables. If you reconfigure or customize your tables or upgrade you system, refer to the PeopleSoft upgrade documentation for information dealing with these situations.
Archiving produces place copies of database information in the history tables and at that point, the data exists in the database and the history tables. You can remove the archived information from the database tables and remove the archived data from the history tables when you no longer need it by using the delete and the remove from history features available on the archive run control.
CC Activity Archive History Tables
The CC Activity Archive Preprocess Application Engine program (KK_AR_AC_PRE) selects source transaction types and their related transactions according to the parameters you specify and copies the selected records to their corresponding history tables.
| Database Table | History Table |
|---|---|
|
KK_ACTIVITY_LOG |
KK_ACTVTY_LOG_H |
|
KK_ACT_LOG_FS |
KK_ACT_LOG_FS_H |
|
KK_EXCPTN_TBL |
KK_EXCEPTION_H |
|
KK_LIQUIDATION |
KK_LIQUIDATN_H |
|
KK_OVERRIDE_TBL |
KK_OVERRIDE_H |
|
KK_REFERENCED |
KK_REFERENCED_H |
|
KK_SOURCE_HDR |
KK_SOURCE_HDR_H |
|
KK_SOURCE_LN |
KK_SOURCE_LN_H |
|
KK_TRANS_LOG |
KK_TRANS_LOG_H |
|
KK_ACT_LOG_FS |
KK_ACT_LOG_FS_H |
| Source Transaction | Description | Source Header Sibling | History Table |
|---|---|---|---|
|
AP_VOUCHER |
Voucher |
KK_SHDR_APVCHR |
KK_SHDR_APVCH_H |
|
AP_ACCT_LN |
Voucher (Gain, Loss, Close) |
KK_SHDR_APACTLN |
KK_SHDR_APALN_H |
|
AP_ACCTDSE |
Voucher - Discount Earned |
KK_SHDR_APACTLN |
KK_SHDR_APALN_H |
|
AP_ACTDSEC |
Voucher - Disc Earn - PO close |
KK_SHDR_APACTLN |
KK_SHDR_APALN_H |
|
AP_VCHR_NP |
Voucher (Non-Prorated Item) |
KK_SHDR_APVCHR |
KK_SHDR_APVCH_H |
|
AR_MISCPAY |
Miscellaneous Payment |
KK_SHDR_ARMPAY |
KK_SHDR_ARMPY_H |
|
AR_REVEST |
Revenue Estimate |
KK_SHDR_ARRVEST |
KK_SHDR_ARRVE_H |
|
BI_INVOICE |
Billing Invoice |
KK_SHDR_BIINV |
KK_SHDR_BIINV_H |
|
CM_TRNXTN |
Cost Management Transaction |
KK_SHDR_CMTRN |
KK_SHDR_CMTRN_H |
|
EX_EXCLOSE |
Closed Expense Reports |
KK_SHDR_EXSHEET |
KK_SHDR_EXSH_H |
|
EX_EXSHEET |
Expense Sheet |
KK_SHDR_EXSHEET |
KK_SHDR_EXSH_H |
|
EX_TRVAUTH |
Travel Authorization |
KK_SHDR_EXTRATH |
KK_SHDR_EXTAU_H |
|
GENERIC |
Generic Transactions |
KK_SHDR_GEN |
KK_SHDR_GEN_H |
|
GL_BD_JRNL |
GL Budget Entry |
KK_SHDR_GLBDJNL |
KK_SHDR_GLBJ_H |
|
GL_JOURNAL |
General Ledger Journal |
KK_SHDR_GLJRNL |
KK_SHDR_GLJ_H |
|
GM_FA |
Facilities and Administration |
KK_SHDR_GMFA |
KK_SHDR_GMFA_H |
|
GM_FA_UPG |
Facilities and Administration |
KK_SHDR_GMFA |
KK_SHDR_GMFA_H |
|
HR_PAYROLL |
Payroll Transaction |
KK_SHDR_HRPAY |
KK_SHDR_HRPAY_H |
|
PC_BUDGET |
Project Budget |
KK_SHDR_PCJRNL |
KK_SHDR_PCJNL_H |
|
PC_JOURNAL |
Project Journal |
KK_SHDR_PCJRNL |
KK_SHDR_PCJNL_H |
|
PO_POENC |
Purchase Order |
KK_SHDR_POENC |
KK_SHDR_POENC_H |
|
PO_POENCNP |
PO (NonProrate Item) |
KK_SHDR_POENC |
KK_SHDR_POENC_H |
|
PO_PROCARD |
Procurement Card |
KK_SHDR_POCARD |
KK_SHDR_POCRD_H |
|
PO_RAENC |
Receipt Accruals - Encumbrance |
KK_SHDR_PORA |
KK_SHDR_PORA_H |
|
PO_RAEXP |
Receipt Accruals - Expense |
KK_SHDR_PORA |
KK_SHDR_PORA_H |
|
REQ_PRECNP |
Requisition (Non-Prorated) |
KK_SHDR_REQ |
KK_SHDR_REQ_H |
|
REQ_PREENC |
Purchase Requisition |
KK_SHDR_REQ |
KK_SHDR_REQ_H |
|
EX_ACENC |
Expenses Accrual Encumbrance |
KK_SHDR_EXACENC |
KK_SHDR_EXACE_H |
|
EX_ACEXP |
Expense Sheet Accrual Expense |
KK_SHDR_EXACENC |
KK_SHDR_EXACE_H |
|
AP_ACENC |
Voucher Accrual Encumbrance |
KK_SHDR_APACENC |
KK_SHDR_APENC_H |
|
AP_ACEXP |
Voucher Accrual Expense |
KK_SHDR_APACENC |
KK_SHDR_APENC_H |
CC Ledger Archive History Tables
| Database Table | History Table |
|---|---|
|
LEDGER_KK |
LEDGER_KK_H |
|
LEDGER_KK_FS |
LEDGER_KK_FS_H |
CC Journals Archive History Tables
| Database Table | History Table |
|---|---|
|
KK_BUDGET_HDR |
KK_BUDGET_HDR_H |
|
KK_BUDGET_LN |
KK_BUDGET_LN_H |