|
|
| Line 1: |
Line 1: |
| ==Cross checking CCMDB data with Manitoba Health (MH)== | | ==Data Processes== |
| ===PURPOSE of CCMDB cross check with MHSC===
| | *this sections explains all data processing tasks that take place once data is submitted and before it is used for producing stat reports. |
| *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
| |
| *who set up the ACCESS program (the conditioner)?
| |
| *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.
| |
| ===Instruction on how to apply corrections to master CCMS databases (ICU & Medicine)===
| |
| | |
| | |
| {{Discussion}}
| |
| # Pagasa, can you please update this information
| |
| ##Explain how MH marks matches when disks return.
| |
|
| |
|
|
| |
|