Direct Data Access for RIS/PACS: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (17 intermediate revisions by the same user 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 == | ||
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 | * come up with an import process | ||
* ensure that we can generate output to support whatever this data is used for now | * 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 [[ | 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 26: | Line 35: | ||
==== RIS/PACS ambiguous types ==== | ==== 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. | 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. | * 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 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) | **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) | ***IMPORTANT: Count as 1 CT scan only.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:50, 2015 September 3 (CDT) | ||
=== 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 | ||
== 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]] | |||