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:
Admit Source & Type
Revenue Code (Charge Description Master (CDM)/CaseMix)
Physician Practice & Specialty
Billing Form Code
- 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.