Manitoba Centre for Health Policy export

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

need to address how the de-identification will happen, emailed Julie Ttenbergen 17:35, 2015 April 20 (CDT)

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)