Manitoba Centre for Health Policy export: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →checklist: clean-up |
Ttenbergen (talk | contribs) m m |
||
| Line 1: | Line 1: | ||
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 == | == checklist == | ||
* how about the ALERT score (MOST), this was not given before but we can add now, what do you think? | * how about the ALERT score (MOST), this was not given before but we can add now, what do you think? | ||
* itiss? | * itiss? | ||
* data dictionary | |||
* | |||
== Instructions == | == Instructions == | ||
| Line 18: | Line 13: | ||
* [[PHI.mdb]] | * [[PHI.mdb]] | ||
* CCMDB.mdb | * CCMDB.mdb | ||
* | * [[Legacy TMS Data.mdb]] | ||
* TISS28_Data.mdb | * TISS28_Data.mdb | ||
=== | === generating the export file === | ||
* open | * open | ||
* click " | * click the "Generate output" button | ||
=== sending === | === sending === | ||
| Line 86: | Line 79: | ||
== Log == | == Log == | ||
=== 2015-04-23 === | === 2015-04-23 === | ||
* code to generate export file when "generate output" is clicked | |||
* make-table queries | * make-table queries | ||
Revision as of 19:03, 23 April 2015
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 Julene Reimer at Manitoba Health (address? Template:Discussion), email her the password; Manitoba Health with de-identify the data and pass it on to MCHP.
structure
Main
- 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)
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
Log
2015-04-23
- code to generate export file when "generate output" is clicked
- make-table queries
2015-04-20
- re-conect for relevant files
- initial file (is a modified clone of Legacy_TMS_Data.mdb)