Crosschecking data with Manitoba Health: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,599 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
needs to be updated!
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).  
* 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?==
==Purpose of sending data to MHSC?==
Line 7: Line 7:
*aligning and correcting our patient ID information with MHSC
*aligning and correcting our patient ID information with MHSC
*maintaining consistency of key patient identifiers in our database when a patient is readmitted.
*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
*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
*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.
*One sent/received log form for ICU another for Medicine.
*CD's are kept sleeves in this binder with these MHSC send/recieved logs.
*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==
==Instruction on how to run the MB Health ACCESS database "Conditioner" Program==
*see [[Manitoba Health "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 32: Line 23:
*PURPOSE: statistician would like to keep track of the number of corrections made.   
*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: Manitoba Health]]
[[Category: Questions Data Processing]]
[[Category: Questions Data Processing]]

Revision as of 21:22, 1 November 2012

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

Purpose of sending data to MHSC?

  • for crosschecking our database patient identifiers (PHIN, FN, LN, DOB, Gender) against MHSC database
  • 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)Template:Discussion

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

typing data into a EXCEL table to report % match/no match from MHSC

  • When data is returned from MB Health, after Pagasa runs the Manitoba Health_"Conditioner" program, she counts the number of corrections made in our database for each patient identifier. She manually counts then she enters this information into an EXCEL spreadsheet where info is automatically tallied.
  • 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?...Template:Discussion

Contacts

What do we do when something is found?

Data processor corrects info in master database. 

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.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Crosschecking_data_with_Manitoba_Health&oldid=29910"