Manitoba Centre for Health Policy export: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Instructions) |
Ttenbergen (talk | contribs) m (→Instructions: m) |
||
Line 17: | Line 17: | ||
=== Instructions === | === Instructions === | ||
* | ==== Preparations ==== | ||
** steps? {{discussion}} | Copy the following files all to one folder: | ||
* sending | * 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 | |||
==== Importing ==== | |||
* open | |||
* click "Re-connect Data" button | |||
* steps? {{discussion}} | |||
* | |||
==== sending ==== | |||
** copy the data to a memory stick or CD | ** copy the data to a memory stick or CD | ||
** '''delete the modules and forms, they contain passwords''' | ** '''delete the modules and forms, they contain passwords''' |
Revision as of 10:50, 2015 April 23
Which DB, stored where...
Draws from Legacy TMS Data.mdb.
checklist
- The Created Variable (APACHE, APS Score,GCS, LOS, AGE, Delays, etc.) should be given and added to L_LOG.
- I have a note "old Apache medicine" - does this address that?
- Need to add the Comorbidity score
- do we need the combined score if I were to add individual scores in como table? Would be easy to do...
- how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
- itiss?
- add "program" field from s_locations, or rather, use individual columns from there rather than using R_Location which has weird stuff like the H4H sharing...
- Julie has started a data dictionary in
\\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\DataDictionary.xlsx
- X:\CCMDB_Special_Projects\MCHP\2015 is drive for this
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
Importing
- open
- click "Re-connect Data" button
- steps? Template:Discussion
sending
- copy the data to a memory stick or CD
- delete the modules and forms, they contain passwords
- send the data 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
Table <what would be a good name for the main table>
- contents of
- L_Log
- L_PHI (I have a "Julie to talk to Angela" note in my notes, can't remember what about...)
- Query L Labs total which summarizes L_Labs_Flowsheet into one line per pt
- Labs from Legacy TMS Data.mdb
- Query L_Pharm_total which summarizes L_Pharm_Flowsheet into one line per pt
- Pharmacy from Legacy TMS Data.mdb
- created_variables
- Tasks (since it's really always all for Medicine)
Como
- contents of L_Como
Dxs
- contents of L_Dxs (except tasks)
- use Query L_Dxs_w_primary?
L_TISS
- from Legacy TMS Data.mdb, own table since one per day
Log
2015-04-23
do:
- make-table queries
2015-04-20
- re-conect for relevant files
- initial file (is a modified clone of Legacy_TMS_Data.mdb)