|
|
| (8 intermediate revisions by the same user 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 MS 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.
| |
| *Nov.12: included: Medicine Only: "Date of admission" to PCH (Primary Care Home)
| |
| **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)
| |
|
| |
|
| ==Sending to MHSC== | | ==Sending 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 | | * see [[Manitoba Health Crosschecking Sending Data]] for details on the process and a log of activity |
| *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== | | == Correcting data based on response received == |
| *see [[Manitoba Health "Conditioner"]] Program. | | 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]] |
|
| |
|
| ==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?...{{discussion}}
| |
|
| |
|
| === Contacts ===
| |
| [[MB Health Crosscheck Contact]]
| |
|
| |
|
| ===What do we do when something is found? ===
| |
| [[Data processor]] corrects info in master database.
| |
|
| |
|
| | | [[Category:Manitoba Health]] |
| | | }} |
| ====PCH admit date====
| |
| [[User: JMojica|Julie Mojica]] Nov 1.12, is getting PCH [[Personal Care Home (what)]] (what is this?) arrival date from MHSC along with regular cross checks done with MHSC.--Trish Ostryzniuk 20:55, 2012 November 1 (EDT)
| |
| | |
| *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: Questions Data Processing]]
| |
Legacy Content
This page contains Legacy Content.
- Explanation: Manitoba Health stopped providing this data
- Successor: No successor was entered
Click Expand to show legacy content.
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.
Sending to MHSC
Correcting data based on response received
When files are returned, data in Centralized_data.accdb is corrected based on the feedback