Archive & Purge Solutions

Databases that contain obsolete, corrupted, or errant data pose costly inefficiencies. Routinely archiving and cleansing records helps companies maintain a healthy billing system and save IT expenses associated with overly large or faulty data sets.

A well-tuned system avoids the costs of supplemental hardware from the loss of performance, and defers the need for additional data storage such as disc packs. An optimally performing system also prevents slower response times that would otherwise affect delays to customer requests, field operations, and reporting needs. Archive/purge services also suspend the trend for lengthening batch runs, which could eventually exceed batch windows and result in billing delays.

By routinely archiving data and identifying records that require ongoing attention, your utility can focus on maintenance and administration tasks that are directed at the most important data in the system. Having a right-sized, clean database allows management to pursue other system-related initiatives without fear of propagating corrupt data.
 

Key Features & Benefits
 

• KamTech offers the only available purge process that validates data prior to archiving and stores that data prior to a system purge. No data is lost as part of the process.
• Our solution maintains data integrity throughout the process. This safeguard ensures that future validations do not detect any issues with the purged accounts.
• The process allows purging by individual cycles, by cycle ranges and within a user-selected purge date.
• Archived data can be retrieved for future analysis or support purposes.
• KamTech uses a referential, production-proven and versatile process.
• KamTech employs knowledgeable Banner CIS personnel with decades of experience.
• We can provide training resources and documentation for future runs.
• KamTech offers guaranteed support and competitive rates for archive/purge services.

Service Overview

KamTech selects data from ten key tables within Banner to streamline the system including:

Adjustments Open Items Payments Payment Applications Bill Detail

Rate Changes Bill History Consumption History Consumption Adjustments Service History

KamTech selects key parameters in these tables to identify which records need to be removed. Determinants of obsolescence may include start and end cycles, selected accounts, or date ranges. Resultant data is sequestered and entered into a temporary table.

KamTech then processes each account in this data set and all the related billing, consumption, and financial records. Appropriate items are selected, archived and then deleted from the appropriate tables. KamTech replaces purged records with balance forward totals to maintain the financial requirements of the system.

Following record processing and purging, KamTech runs test instances to ensure the integrity of a baseline selection of records and financial information. Once iterative test efforts produce a set of identical and reconcilable results, data is ported to the production instance for final processing.

When the process is complete, the purged records will comprise files from the ten tables above and can be stored offline as reference data for archival requests.