CCMDB Wiki

Crosschecking data with Manitoba Health: Difference between revisions

← Older editNewer edit →
m u
Line 1: Line 1:
This article explains the process of crosschecking our patient identifier from our database with  Manitoba Health Database (MHSC).  
This article explains the process of crosschecking our patient identifier from our database with  Manitoba Health Database (MHSC). See [[Manitoba Health Crosschecking Background]] for background information on the process.  
* Refer to [[Manitoba Health "Conditioner"]] Program, which is an MS Access program that is associated with this process.
*Also see [[Manitoba Health Match Indicator Guideline]] for decision making Guidelines for match and unmatched data recieved from Manitoba Health.


==Purpose of sending data to MHSC==
==Sending to MHSC==
*for crosschecking our database patient identifiers (PHIN, FN, LN, DOB, Gender) against MHSC database
* data files that are exported from the ICU and Medicine database every 2-3 months
*aligning and correcting our patient ID information with MHSC
* see [[Manitoba Health Crosschecking Sending Data]] for details on the process and a log of activity
*maintaining consistency of key patient identifiers in our database when a patient is readmitted.
 
*Nov.12: included: Medicine Only: "Date of admission" to PCH (Primary Care Home)
== Correcting data based on response received ==
**Dr. Garland has asked Julie to try and obtain this information to include ICU also.[[User:TOstryzniuk|Trish Ostryzniuk]] 18:45, 2012 November 20 (EST)
When files are returned, data in [[Dentralized_data.mdb]] is corrected based on the feedback
* See [[Manitoba Health Match Indicator Guideline]] for decision making Guidelines for matched and unmatched data recieved from Manitoba Health.
* [[Manitoba Health Crosschecking Reconciling Returned Data]]


==Sending to MHSC==
*data files that are exported from the ICU and Medicine database every 2-3 months
*PHIN, LN, FN, DOB & Gender are included in a EXCEL file
*A Paper Log Records batch number, date send and date recieved from MHSC.
*One sent/received log form for ICU another for Medicine.
*CD's are kept sleeves in this binder with these MHSC send/recieved logs.


==Instruction on how to run the MB Health ACCESS database "Conditioner" Program==
*see [[Manitoba Health "Conditioner"]] Program.


==typing data into a EXCEL table to report % match/no match from MHSC==
==typing data into a EXCEL table to report % match/no match from MHSC==
Line 25: Line 17:


Explain the naming structure, where is the Excel sheet, is the data being used in any way?...{{discussion}}
Explain the naming structure, where is the Excel sheet, is the data being used in any way?...{{discussion}}
=== Contacts ===
[[MB Health Crosscheck Contact]]
===What do we do when something is found? ===
[[Data processor]] corrects info in master database.


====PCH admit date====
====PCH admit date====
Line 38: Line 22:


*Julie and Pagasa where both asked to add anything to here in regards to what we sent or recieve from MB health so that we have some documentation. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:43, 2012 November 6 (EST)
*Julie and Pagasa where both asked to add anything to here in regards to what we sent or recieve from MB health so that we have some documentation. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:43, 2012 November 6 (EST)
Below this is legacy info only
== Legacy ==
===When did MHSC crosschecking process start?===
*DATE: Between '''September 14 & December 6, 2000'''
*DATE: '''January, 2003''' study numbers 1-13034 '''resent''' to MHSC for a second match.  This was are older DOS data that was converted from an old DOS database to and Windows base platform. 
*Trish started a system of sending data for cross checking with MHSC. 
*Dr. Carla Chrusch facilitate this opportunity with MHSC. 
*Julie took over the process and improved it in 2003.


[[Category: Manitoba Health]]
[[Category: Manitoba Health]]
[[Category: Questions Data Processing]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Crosschecking_data_with_Manitoba_Health"