https://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&feed=atom&action=history11.2 Warehouse Data Mapping: Data Mapping Workbook - Revision history2024-03-29T05:08:08ZRevision history for this page on the wikiMediaWiki 1.35.1https://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&diff=14632&oldid=prevCrystal.Vervaecke at 19:07, 29 October 20122012-10-29T19:07:45Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:07, 29 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">__TOC__</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=='''Overview'''==</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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. </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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. </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l24" >Line 24:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Recommendation: ''' Map all Result Types. Like Appointment Type, it take some effort up front, but will reduce the work required in the future if it ever becomes a required process.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Recommendation: ''' Map all Result Types. Like Appointment Type, it take some effort up front, but will reduce the work required in the future if it ever becomes a required process.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Return to [[V 11.x to V11.2 Build Activity Workbook (BAW)]].</ins></div></td></tr>
</table>Crystal.Vervaeckehttps://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&diff=12103&oldid=prevSteve.Stahr: /* * Appointment Types only need to by mapped when one of more providers using AEEHR do NOT use the charge module */2011-11-19T02:58:14Z<p><span dir="auto"><span class="autocomment">* Appointment Types only need to by mapped when one of more providers using AEEHR do NOT use the charge module</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 02:58, 19 November 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17" >Line 17:</td>
<td colspan="2" class="diff-lineno">Line 17:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>''' Recommendation: ''' Map all Appointment Types regardless of using Charge. It takes a little effort, but in the event it is ever necessary in the future, it will be done. </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>''' Recommendation: ''' Map all Appointment Types regardless of using Charge. It takes a little effort, but in the event it is ever necessary in the future, it will be done. </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Appointment Type Exclusion?</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">[[</ins>Appointment Type Exclusion<ins class="diffchange diffchange-inline">]]</ins>?</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Result Type ==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Result Type ==</div></td></tr>
</table>Steve.Stahrhttps://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&diff=12100&oldid=prevSteve.Stahr: /* Appointment Type */2011-11-19T02:45:01Z<p><span dir="auto"><span class="autocomment">Appointment Type</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 02:45, 19 November 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l13" >Line 13:</td>
<td colspan="2" class="diff-lineno">Line 13:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Data Mapping v1.19===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Data Mapping v1.19===</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Appointment Type ==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Appointment Type ==</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">==== * Appointment Types only need to by mapped when one of more providers using AEEHR do NOT use the charge module ====</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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 so that the Stimulus Set Reports recognize the nature of the appointment. There are many Appointment Types that would never be recognized for reporting and normally that is determined by the CPT code. When Charge is not in use, this mapping enables the Stim Set reports to recognize the type of appointment and whether or not it will be used for reporting.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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 so that the Stimulus Set Reports recognize the nature of the appointment. There are many Appointment Types that would never be recognized for reporting and normally that is determined by the CPT code. When Charge is not in use, this mapping enables the Stim Set reports to recognize the type of appointment and whether or not it will be used for reporting.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">''' Recommendation: ''' Map all Appointment Types regardless of using Charge. It takes a little effort, but in the event it is ever necessary in the future, it will be done. </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Appointment Type Exclusion?</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Result Type ==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">==== * Result Type only need to be mapped for 1) the Results that are associated to the chosen CQM and 2) the LOINC code is not assigned ====</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">After selecting CQM, a key build task is assigning the correct LOINC codes to the Results that are being reported on. If the AEEHR group does not have these LOINC codes assigned, they can choose to map the Result Types that are associated to the the CQM. </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'''Recommendation: ''' Map all Result Types. Like Appointment Type, it take some effort up front, but will reduce the work required in the future if it ever becomes a required process.</ins></div></td></tr>
</table>Steve.Stahrhttps://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&diff=12099&oldid=prevSteve.Stahr: /* Appointment Type */2011-11-19T02:37:43Z<p><span dir="auto"><span class="autocomment">Appointment Type</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 02:37, 19 November 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l13" >Line 13:</td>
<td colspan="2" class="diff-lineno">Line 13:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Data Mapping v1.19===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Data Mapping v1.19===</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Appointment Type ==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Appointment Type ==</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>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 <ins class="diffchange diffchange-inline">so that the Stimulus Set Reports recognize the nature of the appointment. There are many Appointment Types that would never be recognized for reporting and normally that is determined by the CPT code. When Charge is not in use, this mapping enables the Stim Set reports to recognize the type of appointment and whether or not it will be used for reporting</ins>.</div></td></tr>
</table>Steve.Stahrhttps://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&diff=12098&oldid=prevSteve.Stahr at 02:32, 19 November 20112011-11-19T02:32:32Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 02:32, 19 November 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l10" >Line 10:</td>
<td colspan="2" class="diff-lineno">Line 10:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">===Data Mapping v1.19===</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Appointment Type ==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">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.</ins></div></td></tr>
</table>Steve.Stahrhttps://wiki.galenhealthcare.com/index.php?title=11.2_Warehouse_Data_Mapping:_Data_Mapping_Workbook&diff=11090&oldid=prevAugust.Borie: Created page with "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 ..."2011-04-26T12:30:40Z<p>Created page with "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 ..."</p>
<p><b>New page</b></p><div>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. <br />
<br />
'''Example:''' <br />
For gender, CQS lists the following genders:<br />
*Male<br />
*Female<br />
*Unknown<br />
<br />
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.<br />
<br />
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.</div>August.Borie