Manitoba Centre for Health Policy export: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,600 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m →sending: minor
m →checklist: clean-up
Line 4: Line 4:


== checklist ==
== 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?
* how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
* itiss?
* 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
* Julie has started a data dictionary in
\\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\DataDictionary.xlsx
\\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\DataDictionary.xlsx
* X:\CCMDB_Special_Projects\MCHP\2015 is drive for this
* X:\CCMDB_Special_Projects\MCHP\2015 is drive for this


== Instructions ==
== Instructions ==

Revision as of 18:39, 23 April 2015

Which DB, stored where...

Draws from Legacy TMS Data.mdb.

checklist

  • how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
  • itiss?
  • 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:

Importing

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

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

Log

2015-04-23

do:

  • make-table queries

2015-04-20

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Manitoba_Centre_for_Health_Policy_export&oldid=43148"