11.2 Warehouse Data Mapping: Data Mapping Workbook

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 02:32, 19 November 2011 by Steve.Stahr (talk | contribs)
Jump to navigation Jump to search

The purpose of this mapping is to map a client’s custom dictionary entries to values that are used by CQS in order to calculate properly for Meaningful Use. This mapping does not change any values within the client’s system. As the data from the client’s system is uploaded to the Allscripts Data Warehouse the information will be processed according to the mapping and then calculated for Meaningful Use. This process is required for all client's upgrading to Allscripts Enterprise EHR v11.2. Clients will need to complete the Data Mapping Workbook regardless if they currently use on premise CQS or plan on implementing the Basic Clinical Quality Reporting functionality included with the Stimulus Set contract.

Example: For gender, CQS lists the following genders:

  • Male
  • Female
  • Unknown

If a client was to use Boy and Girl as genders, then these entries would not be calculated. By performing the Data Mapping the client can then map the entry of Boy to Male and the entry of Girl to Female. Once mapped, these entries will now be included in the calculation.

The workbook contains a macro that will look to automatically map these values. Any values which the workbook cannot automap will be the responsibility of the client to complete. The Upgrade Consultant will perform this automapping and hand off the workbook to the client to complete the remaining items. The Upgrade Constultant will provide the client with predefined definitions to help in the process. Once the workbook has been completed, the client should return it to the Upgrade Consultant.

Data Mapping v1.19

Appointment Type

When calculating Meaningful Use objectives, some of the objectives count the number of Encounters (for example - Clinical Summary), while some measure the number of patients during the reporting period (for example - Demographics and BMI). If a group has any providers intending to report Meaningful Use that are not on the Charge module, they will need to map Appointment Types.