Imaging.mdb

The access file Regional Server\Output\imaging.mdb will be the data store for the import of RIS/PACS data. NOTE: "Patient identifiers" in imaging.mdb are sent "from ccmdb.mdb" 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.mdb 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.