Imaging.mdb: Difference between revisions

(11 intermediate revisions by 3 users not shown)

Line 1:

~~The access file [[Regional Server]]\Output\imaging.mdb will be the data store for the import of RIS/PACS data.~~

Legacy only

~~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'''~~.

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

[[Category:Data ~~Repository~~]]

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 ~~Import~~]]

*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]]

@@ Line 1: / Line 1: @@
-The access file [[Regional Server]]\Output\imaging.mdb will be the data store for the import of RIS/PACS data.
+ Legacy only
-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'''.
+Final resting place: \\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\Output\versions
-[[Category:Data Repository]]
+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 Import]]
+*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]]