Crosschecking data with Manitoba Health

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

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.
• Nov.12: included is: "Date of admission" to PCH (Primary Care Home).-Trish Ostryzniuk 23:15, 2012 November 4 (EST)

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

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

• 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?) Template:Discussion.

What do we do when something is found?

Data processor corrects info in master database.

PCH admit date

Julie Mojica Nov 1.12, is getting PCH {Personal Care Home} 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. 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.