History Tables

General Ledger delivers history tables as system data to be used with the delivered archive procedures.

You can change or configure history tables to correspond to any special requirements or configuration of your system by 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.

Archiving places copies of ledger and journal records in the history tables, and at that point the data exists in the database and the history tables. You can use the delete and remove from history action available on the archive run control to remove archived information from the database tables and when you no longer need the information, remove the archived data from the history tables.

Journal Archive History Tables

The following are the delivered sample system data history tables for journal archive:

Active Database Table	History Table
JRNL_HEADER	JRNL_HDR_H
JRNL_LN	JRNL_LN_H
JRNL_VAT	JRNL_VAT_H
JRNL_CF_BAL_TBL	JRNL_CF_BAL_H
JRNL_IU_ANCHOR	JRNL_IUAC_H
OPEN_ITEM_GL	GL_OITEM_H

Ledger Archive History Tables

The following are the delivered sample system data history tables for ledger archive:

Active Database Table	History Table
LEDGER	LEDGER_H
LEDGER_ADB	LED_ADB_H
LEDGER_ADB_MTD	LED_ADB_MTD_H
LEDGER_ADB_QTD	LED_ADB_QTD_H
LEDGER_ADB_YTD	LED_ADB_YTD_H