Imaging.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 9: | Line 9: | ||
## make copy of imp_blank table, name imp_<yyyy>-<mm>, e.g. imp_2012-01 | ## 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 | ## 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:Data Repository]] | [[Category:Data Repository]] | ||
[[Category:RIS/PACS Import]] | [[Category:RIS/PACS Import]] | ||
Revision as of 16:23, 2012 March 8
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.