Conversion Tasks

Tracking via a Complete Audit File

During conversions, data goes through many transformations.  This makes the task of reconciling the moved data a tedious one at best.  For example, converting from one monetary unit to another, deleting or combining records, or enacting other changes make it difficult to balance paper reports.  The Gladstone methodology allows clients to balance and validate conversions easily by creating a dynamic, “traveling” audit file that provides for complete tracking.

Utilizing the Power of Report Writer

The Report Writer is a general purpose Gladstone reporting function that produces custom reports based on client-entered parameters.  For example, you can generate a report for selected fields for selected records.  In conjunction, with Gladstone’s Master File Display, the Report Writer function enables the client to mine the data in as much detail as desired.  For example, the report could show all permutations of the fields that actually exist in the data.

Automated Reporting of Exceptions

The Gladstone software allows the client’s technical staff to insert a pre-defined “exception reporting” code at any place in the conversion process.  This process allows for automated reporting of exceptions.  This method has the overwhelming support of auditors from various industries.  For example, financial auditors request frequent exception reports.

Verifying Before and After Balances

The actual conversion period is one of the few times that both input and output data are accessable at the same time.  The Gladstone methodology tasks all of the balancing drudgery out of the conversion project by writing out a file of fields to be used in the balancing process.  This file then is taken into the Gladstone Report Writer at the time the conversion files are being passed to the next step.  The file may be sorted in any order and fields totaled (up to nine levels) to create the necessary balancing reports.

Processing Dates

The Gladstone software supports over one-hundred date formats.  In the conversion process, the analyst indicates the date format of the source and the desired date format for the target, and the code is automatically generated to convert the dates from the source to the target format.