Imaging.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Fschumacher (talk | contribs) No 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. | ||
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'''. | ||
| Line 16: | Line 16: | ||
[[Category:Data Repository]] | [[Category:Data Repository]] | ||
Revision as of 08:02, 2012 September 11
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 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.