Crosschecking data with Manitoba Health: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) |
||
| Line 29: | Line 29: | ||
==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== | ||
*Pagasa manually counts then enters into an | *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 | ||
*PURPOSE: | and manually counts then enters this information into an EXCEL spreadsheet where info is automatically tallied. | ||
*PURPOSE: statistician would like to keep track of the number of corrections are made. | |||
Revision as of 19:20, 26 January 2009
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.
- 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?
- 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.
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.
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
- 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
- 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
and manually counts then enters this information into an EXCEL spreadsheet where info is automatically tallied.
- PURPOSE: statistician would like to keep track of the number of corrections are made.
Explain the naming structure...
How does the file get there?
who are the contacts
- The data processor uses the program.
- The statistician coordinates communication with MB Health.
- The person providing the info at MB Health is Marc Silva.