2.5 Archival of Transaction Entries and Balance

This topic provides information on the archival of transaction accounting entries and balance.

The archival process transfers historical transaction and balance data from active tables to archive tables to improve system performance and optimize storage utilization. It uses the Plato Archival Framework to ensure secure, consistent, and traceable data management.

The archival process moves historical records from the following active table:

• OBOL_TB_SYS_ACC_BD_BAL

• OBOL_TB_SYS_ACC_VD_BAL

• OBOL_TB_GL_TRANSACTION_LOG

to their corresponding archive tables:

• OBOL_TB_SYS_ACC_BD_BAL_ARCH

• OBOL_TB_SYS_ACC_VD_BAL_ARCH 

• OBOL_TB_GL_TRANSACTION_LOG_ARCH

This ensures improved system performance, optimized storage usage, and compliance with audit and regulatory requirements.

Archival Criteria:

Records eligible for archival are identified based on defined criteria such as:

• Transaction Date
• Booking Date
• Value Date

Retention Period:

The archival job retains data in active tables based on the following retention periods:

• Transaction Log Table – 548 days
• Booking Date and Value Date Balances – 730 days

Records older than the defined retention period are automatically moved to the corresponding archive tables.

Process Execution:

The archival job is automatically triggered as part of the End-of-Day (EOD) operations.

During execution, the system identifies eligible records in active tables and moves them securely to archive tables using the Plato Archival Framework and PLATO-FAST-DATA-TRANSFER mechanism.

The process ensures data integrity, consistency, and complete traceability throughout the archival lifecycle.

This impact

• Reduces volume of active tables.
• Improves query and application performance.
• Optimizes storage utilization on primary systems.
• Maintains historical data for audit and reporting.

The system maintains a complete log of all archived records and archival activities to ensure traceability and regulatory compliance.

This topic contains the following sub-topics:

• Archive Transaction Log
  This topic explains the systematic instructions to view archived transaction log screen.
• Archive Value Date Balance Entries
  This topic explains the systematic instructions to view archived value date balance entries screen.
• Archive Booking Date Balance Entries
  This topic explains the systematic instructions to view archived booking date balance entries screen.