Archive Objects

An archive object definition identifies the tables that contain the data to be archived and the history tables that are to be updated for each table.

It is important to understand the base table and nonbase table relationship. PeopleTools documentation explains in detail the concept and relationship of base to nonbase tables.

See PeopleTools documentation: Data Management, "Using PeopleSoft Data Archive Manager," Managing Archive Objects.

General Ledger delivers the following archive object definitions as system data:

Archive Object Description Base Table

GL_JOURNAL

Archives journal tables:

  • JRNL_HEADER

  • JRNL_LN

  • JRNL_VAT

  • JRNL_CF_BAL_TBL

  • JRNL_IU_ANCHOR

  • OPEN_ITEM_GL

JRNL_HEADER

GL_LEDGER

Archives detail ledger table, LEDGER.

LEDGER

GL_LED_ADB

Archives detail ADB ledger table, LEDGER_ADB.

LEDGER_ADB

GL_LED_ADB_MTD

Archives incremental ADB ledger table, LEDGER_ADB_MTD.

LEDGER_ADB_MTD

GL_LED_ADB_QTD

Archives incremental ADB ledger table, LEDGER_ADB_QTD.

LEDGER_ADB_QTD

GL_LED_ADB_YTD

Archives incremental ADB ledger table, LEDGER_ADB_YTD.

LEDGER_ADB_YTD