Data Consolidation and Conversions/MPI Data Assessment

Data Consolidation and Conversions/MPI Data Assessment 

Data Consolidation and Conversions

As with any system, there will be key files that need to be 100% accurate for a successful implementation. MedSeries4® Master Files are those key files. We have master file conversion tools that help enable you to restructure or redefine MedSeries4® master files and incorporate the new definitions into your database. System conversions are the best time to restructure the system files if needed. Our data conversion tools allow you to implement new numbering schemes for key identification fields such as medical record number and employee ID.

At CCC we also include in-depth verification programs and pre-processing routines to validate files and data prior to the actual conversions.  Two environments exist in MedSeries4®, test and production. These environments provide the ability to work in an update or non-update mode in either option.

Our expert staff will assist you in all phases of the conversion process. We will provide you with a detailed project plan identifying all conversion activities including CCC and client responsibilities for testing, validation and support.

Our specialties include:

  • Carrier Consolidation
    Create new carriers, consolidate duplicate carriers and eliminate carrier codes that are no longer applicable. Restructure the Carrier Master and dependent master files to meet corporate or facility standardization requirements and to utilize plan number options in the Reimbursement Management module, if applicable.
  • Master File Definitions
    Redefine key application master files and convert database history to reflect updated file definitions. CCC tools can be used to restructure many of the most critical elements of your system and convert production and archive history to reflect the updated definitions. Common examples of elements converted with our tool include:

Patient Type

Admit Source & Type

Service Code

Discharge Disposition

Charge Number

Relationship Code

Doctor Number

Scramble Code

Employee ID


Revenue Code (Charge Description Master (CDM)/CaseMix)

Physician Practice & Specialty

Billing Form Code

Proration Plan

  • Chart of Accounts
    Standardize your Chart of Accounts across your corporate structure and convert all current and historical information without sacrificing comparative reporting features. Use this utility to redefine your Chart of Accounts to accommodate consolidation of General Ledger accounts including changes to department and natural class numbers.
  • Fiscal Year Conversion
    Achieve a seamless transition of current and historical financial and statistical data to the new fiscal year across the full MedSeries4® Financial Application suite and the Patient Accounting database. As part of this service we will assist you in the development of balancing and validation procedures, including an evaluation of year-end closing entries.
  • Medical Records Number
    Complete migration to a new Medical Record number format or numbering scheme in your single facility or across a Centralized Business Office (CBO) environment, for all MedSeries4® applications.

MPI Data Assessment 

Data integrity across applications is critical for accurate patient identification and tracking, not to mention satisfying HIPAA requirements. If any of the following issues exist at your facility, we can assist you in cleanup of your MPI and MR history:

  • Erroneous attachments of accounts to a patient
  • Unable to view MR encounter history for patient visits
  • Inability to view certain data online that displays a report
  • “MISSING” displays instead of a patient name

Through a phased approach and a proven investigation process, CCC can address these issues utilizing MedSeries4® application tools and IBM i® utilities. Our analysis will identify issues with orphaned, duplicate and erroneous records. Our resolution process will correct the discrepancies and provide the client with education necessary to minimize future inconsistencies.