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

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 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

do:

• make-table queries

2015-04-20

• re-conect for relevant files
• initial file (is a modified clone of Legacy_TMS_Data.mdb)