Direct Data Access for RIS/PACS: Difference between revisions

mNo edit summary
m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{DA | Identified as something we should do; the notes below are quite old but might still be a starting point.  
 
}}
{{Todo
| who = Tina
| todo_added = 2022-06-22
| todo_action = 2022-06-22
| question =  _after
* Identified as something we should do; the notes below are quite old but might still be a starting point.  
** This will not happen until we have a PHIA approved repository. [[User:Ttenbergen|Ttenbergen]] 11:32, 2022 February 9 (CST)
*** Nothing will come of this until our data is stored elsewhere, so pulling it onto my list so we have some record that this is an outstanding want. [[User:Ttenbergen|Ttenbergen]] 13:04, 2022 June 22 (CDT)
}}
 


== Potential Change ==
== Potential Change ==
{{Potential Change}} We could stop having collectors enter imaging data available from IMPAX onto their laptops and use the data from dump instead.  
We could stop having collectors enter imaging data available from IMPAX onto their laptops and use the data from dump instead.  


To do that we would need to:  
To do that we would need to:  
* confirm that the data is of comparable quality
* confirm that the data is of comparable quality
* come up with an import process (programming is almost done)
* come up with an import process
* ensure that we can generate output to support whatever this data is used for now (what is it used for? might want to put that into [[Lab Collection Process|Labs]]).
* ensure that we can generate output to support whatever this data is used for now


== Direct access to data (work in progress)==  
== Direct access to data (work in progress)==  
Line 15: Line 24:
=== Data Acquisition - RIS/PACS ===
=== Data Acquisition - RIS/PACS ===
Dianne Julius (used to be Breanne Batters) from the RIS/PACS team will provide us with a monthly report with columns (hospital|unit|phin|chart|image_DateTime|imaging_type).  
Dianne Julius (used to be Breanne Batters) from the RIS/PACS team will provide us with a monthly report with columns (hospital|unit|phin|chart|image_DateTime|imaging_type).  
This data would get imported into [[Centralized data.mdb]], details to be determined but possibly into [[L Labs Flowsheet table]] where it is stored now.
This data would get imported into [[Centralized_data.accdb]], details to be determined but possibly into [[L Labs Flowsheet table]] where it is stored now.


=== Importing ===
=== Importing ===
Line 35: Line 44:
=== HSC and STB data problem ===
=== HSC and STB data problem ===
We didn't get much for HSC/STB, email is out to Breanne Batters to find out more
We didn't get much for HSC/STB, email is out to Breanne Batters to find out more
=== comparison ===
review queries 5_compare_* with Trish


== Backups ==
== Backups ==
eHealth backs up the server, so we should not have to back this up.  
eHealth backs up the server, so we should not have to back this up.  
Considering that we could get new dump files generated when needed we don't need to keep or back those up either.  
Considering that we could get new dump files generated when needed we don't need to keep or back those up either.  
== Log ==
* We need RIS is the Radiology information system, we don't need PACS which is the images. Angela Carbonneau
* Can we get a per admission dump? If not a per quarter dump? Research coordinator at Radiology said she does something like that...
* Can we get a per quarter dump? Discussing with app admin at eHealth...
in newest first order:
* 2019-11-18 - emailed Teresa.Figley@umanitoba.ca for info about individual dumps
* 2019-11-14 - Richard Pierre at eHealth may be app admin for this, we called him
* 2019-11-05 - Discussed at [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2019#ICU Database Task Group Meeting – November 5, 2019 | Task]], this is now a priority since we need to streamline collection
== Related articles ==
{{Related Articles}}


[[Category:IT Instructions]]
[[Category:IT Instructions]]
[[Category:RIS/PACS]]
[[Category:RIS/PACS]]
[[Category:Labs]]
[[Category:Labs]]
[[Category:Data Sources]]