|
|
| (22 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| This article explains the process of crosschecking our patient identifier from our database with Manitoba Health Database (MHSC).
| | {{LegacyContent |
| * Refer to [[Manitoba Health "Conditioner"]] Program, which is an ACCESS program that is associated with this process.
| | |explanation=Manitoba Health stopped providing this data |
| *Also see [[Manitoba_Health_Match_Indicator_Guideline]] for decision making Guidelines for match and unmatched data recieved from Manitoba Health.
| | |content= |
|
| |
|
| ==Purpose of sending data to 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. |
| *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?== | | ==Sending to MHSC== |
| *DATE: Between '''September 14 & December 6, 2000''' | | * data files that are exported from the ICU and Medicine database every 2-3 months |
| *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.
| | * see [[Manitoba Health Crosschecking Sending Data]] for details on the process and a log of activity |
| *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== | | == Correcting data based on response received == |
| | When files are returned, data in [[Centralized_data.accdb]] 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]] |
|
| |
|
| *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==
| | [[Category:Manitoba Health]] |
| *Pagasa manually counts then enters into an Excel workbook where info is automatically tallied.
| | }} |
| *PURPOSE: ? Julie.
| |
| | |
| | |
| 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.
| |
| | |
| ===What do we do when something is found? ===
| |
| | |
| {{stub}}
| |
| [[Category:Data_Processing]]
| |
| [[Category: Questions]]
| |