Crosschecking data with Manitoba Health: Difference between revisions

Line 1:

This article explains the process of crosschecking our patient identifier from our database with Manitoba Health Database (MHSC).

* Refer to [[Manitoba Health "Conditioner"]] Program, which is an ~~ACCESS~~ program that is associated with this 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.

*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?==

Line 7:

*aligning and correcting our patient ID information with MHSC

*maintaining consistency of key patient identifiers in our database when a patient is readmitted.

* we are now getting additional data, what is it? Ttenbergen 22:22, 2012 November 1 (EDT){{discussion}}

~~==When did MHSC crosschecking process start?==~~

==Sending to MHSC==

*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.

==Sending ~~Process~~ 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

Line 22:

Line 15:

*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==

Line 32:

Line 23:

*PURPOSE: statistician would like to keep track of the number of corrections made.

Explain the naming structure, where is the Excel sheet, is the data being used in any way?...{{discussion}}

~~Explain~~ the ~~naming structure~~...

=== Contacts ===

*The [[data processor]] uses the [[Manitoba Health "Conditioner"]] program.

*The [[statistician]] coordinates communication with MB Health.

*The person providing the info at MB Health is Marc Silva (email?) {{discussion}}.

~~How does the file get there~~?

===What do we do when something is found? ===

[[Data processor]] corrects info in master database.

~~=== who are the contacts ===~~

Below this is legacy info only

*The [[data processor]] uses the program.

*The [[statistician]] coordinates communication with MB Health.

*The person providing the info ~~at MB Health is Marc Silva.~~

===~~What do we do when something is found~~? ===

== 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.

~~{{stub}}~~

[[Category: Manitoba Health]]

[[Category: Questions Data Processing]]

@@ Line 1: / Line 1: @@
 This article explains the process of crosschecking our patient identifier from our database with  Manitoba Health Database (MHSC).
-* Refer to [[Manitoba Health "Conditioner"]] Program, which is an ACCESS program that is associated with this 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.
+*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?==
@@ Line 7: / Line 7: @@
 *aligning and correcting our patient ID information with MHSC
 *maintaining consistency of key patient identifiers in our database when a patient is readmitted.
+* we are now getting additional data, what is it? Ttenbergen 22:22, 2012 November 1 (EDT){{discussion}}
-==When did MHSC crosschecking process start?==
+==Sending to MHSC==
-*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.
-==Sending Process 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
@@ Line 22: / Line 15: @@
 *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==
@@ Line 32: / Line 23: @@
 *PURPOSE: statistician would like to keep track of the number of corrections made.
+Explain the naming structure, where is the Excel sheet, is the data being used in any way?...{{discussion}}
-Explain the naming structure...
+=== Contacts ===
+*The [[data processor]] uses the [[Manitoba Health "Conditioner"]] program.
+*The [[statistician]] coordinates communication with MB Health.
+*The person providing the info at MB Health is Marc Silva (email?) {{discussion}}.
-How does the file get there?
+===What do we do when something is found? ===
+[[Data processor]] corrects info in master database.
-=== who are the contacts ===
+ Below this is legacy info only
-*The [[data processor]] uses the program.
-*The [[statistician]] coordinates communication with MB Health.
-*The person providing the info at MB Health is Marc Silva.
-===What do we do when something is found? ===
+== 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.
-{{stub}}
 [[Category: Manitoba Health]]
 [[Category: Questions Data Processing]]