Category:Data Processing: Difference between revisions

Cross checking CCMDB data with Manitoba Health (MH)

PURPOSE of CCMDB cross check with MHSC

• quality of consistency of patient information

Sending Process

• Key patient identifiers from CCMDB are sent to MH to find matches on the following fields: PHIN, last name, first name, DOB and Gender.
• Goal is to send one once per month
• Information is sent by Pagasa to Dave Silva?
• Data is sent in batches, one from Medicine and another from ICU.
• Data is zipped with a password and sent by courier to MHSC.
• MHSC send data back by courier
• A logging system is kept of batch of files send in and returned.

Instruction on how to run the MB Health ACCESS database "Conditioner"

• Process on how to unzip
• Process to remove the"2" Hfrom M_PHIN2 column and reason that this is done.
• where to unzip to (x drive/ to which folder?/to which subfolder? (e.g. auout.xls) to the AU) folder
• How to open the xls file sent from MH using MB health ACCESS Database Conditioner program?
• what to do is you get and "match parameter" error
• Making a back up copy of working copy of MB health Conditioner ACCESS.mdb.

Template:Discussion

1. Pagasa, can you please update this information

Template:Stub

Instruction on how to apply corrections to master CCMS databases (ICU & Medicine)

Template:Stub Template:Discussion

1. Explain how MH marks matches when disks return.