Imaging.mdb: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The access file [[Regional Server]]\Output\imaging.mdb will be the data store for the import of [[RIS/PACS]] data. | 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) | *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'''. | 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'''. | ||
Revision as of 13:49, 2013 August 19
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
- receive monthly email from Breanne Batters with last month's imaging data
- open Regional Server\Output\Imaging.mdb
- import doesn't work with the data for some reason, so following steps:
- make copy of imp_blank table, name imp_<yyyy>-<mm>, e.g. imp_2012-01
- copy and paste data from Breanne's excel sheet into the table
- update the query 1_Union_Imports to include the newest table
- run (double-click, then Yes) query 2_import_streamer
Combined Data
The image data combined with patient data can be seen in query combiner.