Manitoba Centre for Health Policy export

From CCMDB Wiki
Jump to navigation Jump to search

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:

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

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