Imaging.mdb

From CCMDB Wiki
Revision as of 21:28, 2020 July 24 by Ttenbergen (talk | contribs) (Text replacement - " ccmdb.accdb" to " CCMDB.accdb")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Legacy only

Final resting place: \\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\Output\versions

Was supposed to be the data store for Direct Data Access for RIS/PACS but that never got off ground, and now with CFE we would not need this part. Ttenbergen 11:44, 2015 April 30 (CDT)

  • NOTE: "Patient identifiers" in imaging.mdb are sent "from CCMDB.accdb" during sending. It would be needed to index the RIS/PACS info if we ever got into importing that. We are not importing or using that right now, it's stockpiling on my computer. This is a project that stalled out at some point, we might want to pick it back up. Ttenbergen 14:02, 2013 August 19 (CDT)

Data to allow merging into TMSX will be written to the table Patients in the Imaging.mdb from CCMDB.accdb for all patient being sent by the query Send_Imaging.

Process to import data

  1. receive monthly email from Breanne Batters with last month's imaging data
  2. open Regional Server\Output\Imaging.mdb
    • import doesn't work with the data for some reason, so following steps:
    1. make copy of imp_blank table, name imp_<yyyy>-<mm>, e.g. imp_2012-01
    2. copy and paste data from Breanne's excel sheet into the table
    3. update the query 1_Union_Imports to include the newest table
    4. run (double-click, then Yes) query 2_import_streamer

Combined Data

The image data combined with patient data can be seen in query combiner.