CCMDB Wiki

Crosschecking data with Manitoba Health

Revision as of 09:09, 2 June 2014 by Ttenbergen (talk | contribs) (→PCH admit date)

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.
  • 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.Trish Ostryzniuk 18:45, 2012 November 20 (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

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

MB Health Crosscheck Contact

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