Imaging.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Created page with "The access file Regional Server\Output\imaging.mdb will be the data store for the import of RIS/PACS data. Data to allow merging into TMSX will be written to the '''tab..." |
Ttenbergen (talk | contribs) m Text replacement - " ccmdb.accdb" to " CCMDB.accdb" |
||
| (11 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
Legacy only | |||
Final resting place: \\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\Output\versions | |||
[[Category:Data | 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) | ||
[[Category:RIS/PACS | |||
*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 == | |||
# 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'''. | |||
[[Category:Legacy Data]] | |||
[[Category:RIS/PACS]] | |||
Latest revision as of 20:28, 2020 July 24
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
- 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.