Category:Data Processing: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
No edit summary
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
No edit summary
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.




Revision as of 00:06, 2008 July 3

Data Processes

  • this sections explains all data processing tasks that take place once data is submitted and before it is used for producing stat reports.



Template:Stub

Subcategories

This category has the following 14 subcategories, out of 14 total.

B

C

D

L

M

P

Q

T

Pages in category "Data Processing"

The following 73 pages are in this category, out of 73 total.

 

"

A

B

C

D

E

F

G

K

L

N

O

P

Q

R

S

T

U

V

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Category:Data_Processing&oldid=2036"