Manitoba Centre for Health Policy export: Difference between revisions
Jump to navigation
Jump to search
Line 57: | Line 57: | ||
=== Tasks === | === Tasks === | ||
Tasks (since it's only for Medicine) | Tasks (since it's only for Medicine) | ||
=== ADL_scores === | |||
ADL_scores (since it's only for Medicine) | |||
=== Tmp === | === Tmp === |
Revision as of 14:04, 2017 April 12
The export process for MCHP uses the file MCHP Export.mdb to generate a date-named file which is then sent to Manitoba Health, where it is de-identified before they send it on to MCHP.
checklist
- how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
- itiss?
- data dictionary
Instructions
Preparations
Copy the following files all to one folder:
- a centralized_data_front_end.mdb with up-to-date created_variables
- Centralized_data.mdb
- PHI.mdb
- CCMDB.mdb
- Legacy TMS Data.mdb
- TISS28_Data.mdb
generating the export file
- open
- click the "Generate output" button
sending
- copy MCHP Export.mdb to a memory stick or CD
- delete the modules and forms, they contain Passwords
- send the memory stick or CD to Jason Berry, Privacy Policy Analyst, of Information Management and Analytics, Manitoba Health, Healthy Living & Seniors (4040D -300 Carlton Street, Winnipeg MB R3B 3M9) and email the password to him (Jason.Berry@gov.mb.ca); Manitoba Health with de-identify the data and pass it on to MCHP.
structure
1Main
- contents of
- L_Log
- L_PHI (all of it, MB Health can decide what to strip/obfuscate)
- Created_variables_CC and Created_variables_common, those which are not already in L_Log
Como
- contents of L_Como
Dxs
- admit and acquired diagnoses with priorities and primary designation.
Labs
- separate table because only in CC and there is a lot there
- Query L Labs total which summarizes L_Labs_Flowsheet into one line per pt
- Labs from Legacy TMS Data.mdb
- some of the above were previously combined in which case we kept the value from L Labs total
Pharmacy_new
- separate table because only in CC and there is a lot there
- Query L_Pharm_total which summarizes L_Pharm_Flowsheet into one line per pt
- pharm_* fields from L_Log
- Pharmacy from Legacy TMS Data.mdb
Pharmacy_old
- separate table because only in CC and there is a lot there
- Pharmacy from Legacy TMS Data.mdb
- separate table because combined there were more than the 256 columns access can handle
Tasks
Tasks (since it's only for Medicine)
ADL_scores
ADL_scores (since it's only for Medicine)
Tmp
A subset of Category:All_Projects
- ERWait - Med only and it should be clearly specified as DATE_TIME LEFT ED to go to the WARD.
- ABO_TEE - STB CICU is using the MCHP and this data has been requested by CICU
- ABO TEE blood type
- ABO TEE function
- ABO TEE LV fraction
- A_T blood type
- A_T function
- A_T LV fraction
- VAP/CLI DATES - there are cases of more than one VAP Date (multi record)
- QAInf
TISS28
- new TISS, one entry per item per day
TISS76
- from Legacy TMS Data.mdb, own table since one line for all items per day