Direct Data Access for RIS/PACS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "== Potential Change == {{Potential Change}} We could stop having collectors enter imaging data available from IMPAX onto their laptops and use the combined data from dump and ..."
 
mNo edit summary
 
(33 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{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 combined data from dump and from imaging.mdb 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:  
* import all data received from PACS and not yet imported
* confirm that the data is of comparable quality
* confirm that the data is of comparable quality
* decide how to store this:
* come up with an import process
** if storing in Ed's DB, confirm that we have all required data to output the same way Delphic does, and that Ed can import our data
* ensure that we can generate output to support whatever this data is used for now
** if imaging.mdb is sufficient, 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]]).


== Direct access to data (work in progress)==  
== Direct access to data (work in progress)==  
We are going to test accessing this data directly from RIS. Once we know it is feasible we will ask the Database [[:Category: Steering Committee | Steering Committee]] if we can stop manual collection.  
We are going to test accessing this data directly from RIS. Once we know it is feasible we will ask the Database [[:Category: Steering Committee|Steering Committee]] if we can stop manual collection.  


=== Data Acquisition - RIS/PACS ===
=== Data Acquisition - RIS/PACS ===
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 will get imported into [[Regional Server]]\output\'''imaging.mdb''', table name '''images'''.
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.
I have reports for July and August, but none after that... emailed Breanne [[User:Ttenbergen|Ttenbergen]] 16:28, 18 November 2011 (CST)


=== Data Acquisition - Collectors ===
=== Importing ===
Additionally, during [[sending]], '''complete patients' only''' (hosp|loc|serial|phin|chart|admit_datetime|disch_datetime) will be sent to the table '''patients'''; this information is required to link images to our database.
see [[RIS PACS importer.accdb]]
* hopefully fixed with update [[CCMDB.mdb_Change_Log_2011#ver_2011-11-18]] [[User:Ttenbergen|Ttenbergen]] 16:28, 18 November 2011 (CST)


=== combining ===
== Things still being worked out ==
combine patients and images: see [[Imaging.mdb]] query '''combiner'''
=== deciding on types ===
There seem to be new types of images on every mew import. They get less but this will probably continue. To be able to categorize them they need to be added to table s_aggregate_types and categorized manually the first time they are encountered. This means it would probably be best if Trish or a collector did the imports. They take about 30 minutes once a quarter.


=== Aggregating ===
==== RIS/PACS ambiguous types ====
There will be one line per image, so we will need to aggregate the lines into counts image_type. This will be done by a query '''combiner_pivoter''' which will provide a count for lines of the same combination of (Serial/PHIN /MRN/location/admit_dt_tm/discharge_dt_tm/imaging_type).
Things like "CT ANGIO ABDOMEN COMBINED" or "CT ANGIO ABDOMEN COMBINED" may be in the table s_aggregate_types twice to be counted as both Angios and CTs.  
The query will start to pick up records from the image file only once a line is present in the patients table, i.e. after a patient has been sent.
Further, the query will of course only pick up images that have been imported.


=== Where to store ===
* Is that how collectors would count it? Ttenbergen 15:37, 2015 August 19 (CDT)
Data can be stored in the imaging.mdb program. I think it would be a long time before we would hit any size restrictions with this, and by then we will hopefully have moved on to a different data repository that can handle the volume.  
* No, we only count arterial angios done by arterial access in our lab counts as angios. CT angios are counted as CT's in the lab counts.
**I have always counted the CTangio as 1 for CT and 1 for angio.--[[User:Jpeterson|Jpeterson]] 12:46, 2015 August 31 (CDT)
**I count it as 1 in the lab counts (for a non invasive CT angio)[[User:GHall|GHall]] 16:01, 2015 September 2 (CDT)
***IMPORTANT:  Count as 1 CT scan only.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:50, 2015 September 3 (CDT)


There is another option for long-term storage. We are currently importing some values for HSC into TMSX. Do we have any documentation for the importer? If I stream the reports from RIS into the right format, would we be able to import into Ed's program directly? [[User:Ttenbergen|Ttenbergen]] 11:30, 4 August 2011 (CDT)
=== HSC and STB data problem ===
*In the Labdownloading program, the study and chart#, admit datetime and disch datetime are entered manually by batch to download the lab dump file from New Delphic. Then Ed's interface program picks up the corresponding match, sums it up and upload to the master database.  I don't think we have the documentation of the importer. [[User:JMojica|JMojica]] 12:13, 4 August 2011 (CDT)
We didn't get much for HSC/STB, email is out to Breanne Batters to find out more


=== 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.  


[[Category: IT Instructions]]
== Log ==
[[Category: RIS/PACS]]
* 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:RIS/PACS]]
[[Category:Labs]]
[[Category:Data Sources]]

Latest revision as of 12:04, 2022 June 22

_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. 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. Ttenbergen 13:04, 2022 June 22 (CDT)
  • added: 2022-06-22
  • action: 2022-06-22
  • Cargo


  • Categories


Potential Change

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:

  • confirm that the data is of comparable quality
  • come up with an import process
  • ensure that we can generate output to support whatever this data is used for now

Direct access to data (work in progress)

We are going to test accessing this data directly from RIS. Once we know it is feasible we will ask the Database Steering Committee if we can stop manual collection.

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). 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.

Importing

see RIS PACS importer.accdb

Things still being worked out

deciding on types

There seem to be new types of images on every mew import. They get less but this will probably continue. To be able to categorize them they need to be added to table s_aggregate_types and categorized manually the first time they are encountered. This means it would probably be best if Trish or a collector did the imports. They take about 30 minutes once a quarter.

RIS/PACS ambiguous types

Things like "CT ANGIO ABDOMEN COMBINED" or "CT ANGIO ABDOMEN COMBINED" may be in the table s_aggregate_types twice to be counted as both Angios and CTs.

  • Is that how collectors would count it? Ttenbergen 15:37, 2015 August 19 (CDT)
  • No, we only count arterial angios done by arterial access in our lab counts as angios. CT angios are counted as CT's in the lab counts.
    • I have always counted the CTangio as 1 for CT and 1 for angio.--Jpeterson 12:46, 2015 August 31 (CDT)
    • I count it as 1 in the lab counts (for a non invasive CT angio)GHall 16:01, 2015 September 2 (CDT)
      • IMPORTANT: Count as 1 CT scan only.Trish Ostryzniuk 13:50, 2015 September 3 (CDT)

HSC and STB data problem

We didn't get much for HSC/STB, email is out to Breanne Batters to find out more

Backups

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.

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, this is now a priority since we need to streamline collection

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Direct_Data_Access_for_RIS/PACS&oldid=156609"