|
|
| (21 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| ''see [[Impax]] about the software used to access RIS/PACS data from the laptops
| | RIS/PACS is the medical imaging database used by the WRHA. Some of our data collectors use it to count x-rays for [[Lab Collection Process|Labs]] collecting. |
|
| |
|
| RIS/PACS is the medical imaging database used by the WRHA. Some of our data collectors use it to count x-rays for [[Labs]] collecting. | | == Accessing RIS/PACS data == |
| | Double-click the "RIS PACS" shortcut on your desktop |
|
| |
|
| == Set-up on PCs==
| | If you don't have a shortcut, follow instructions at [[Desktop shortcuts for collection laptops]] |
| see [[Impax]]
| |
|
| |
|
| == Direct access to data (work in progress)==
| | If you can't log on, then contact the [[p:EHealth ServiceDesk]] |
| We are going to test accessing this data directly from RIS. Once we know it is feasible we will ask the steering committee if we can stop manual collection.
| |
|
| |
|
| === Data Acquisition - RIS/PACS ===
| | Alternatively RIS PACS can be accessed at https://diviewer.manitoba-ehealth.ca/ |
| 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'''.
| |
| 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 === | | == Site training and adoption == |
| 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.
| | All sites have access and should know how to use. If you don't have access please comment here. Ttenbergen 14:55, 2015 May 25 (CDT) |
| * hopefully fixed with update [[CCMDB.mdb_Change_Log_2011#ver_2011-11-18]] [[User:Ttenbergen|Ttenbergen]] 16:28, 18 November 2011 (CST)
| |
|
| |
|
| === combining === | | == Direct Data Access == |
| I have taken a first look at combining the data from RIS/PACS and from our collection: I have set up the query combiner in imaging.mdb to pull together the data in the patients table (sent by collectors) and the images table (imported from RIS/PACS). I am not sure what to make of the results yet as I only have about a month of patient data imported. Here is what I have found, though:
| | see [[Direct Data Access for RIS/PACS]] about an ongoing project to maybe get data from RIS/PACS directly rather than having to collect it manually. |
| * 336 patients since we started sending (sounds reasonable)
| |
| ** earliest admit 1 jan 2011, only 3 from before 18 oct
| |
| * 1451 likely-meaningful entries in the imaging file >= 18 Oct(again, sounds reasonable)
| |
| * the two combine for only 25 pt-image combinations (that doesn't sound reasonable across all ICUs)
| |
| ** all matches are HSC_MICU
| |
| ** zero unmatched patients (need to re-check that)
| |
| ** 624 unmatched images
| |
| *** checked ~100, not an issue of simple PHIN / chart typo
| |
| '''I think this is at least partly a problem of not enough data yet, will check again in January. [[User:Ttenbergen|Ttenbergen]] 16:15, 14 December 2011 (CST)
| |
|
| |
|
| === Aggregating === | | == Legacy Info - IMPAX == |
| 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 IMAGE_COUNTS which will provide a count for lines of the same combination of (Serial/PHIN /MRN/location/admit_dt_tm/discharge_dt_tm/imaging_type).
| | RIS/PACS data used to have to be viewed via installed software IMPAX. As of 2014-01 it can just be accessed via intranet. |
| 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 ===
| | As per email from HSC Messsenger 2014-Jan-16: |
| 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.
| | Both the PACS software and Digital Imaging Viewer are available to users at present. However, when PACS is upgraded a few months from now, the PACS system will be reserved for the diagnostic imaging and emergency departments. DI Viewer will replace the IMPAX PACS software for other users. This change will affect all current users of IMPAX viewer for reviewing diagnostic images and reports. |
|
| |
|
| {{Discussion}}
| |
| 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)
| |
| *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)
| |
|
| |
|
| === Backups ===
| |
| eHealth backs up the server, so we should not have to back this up.
| |
| We used to back up the contents of the Output directory (see [[Outputbackup.bat]]), but decided to stop this. If we decide we need to back this up, then we should review the decision about the rest of the directory as well.
| |
| {{discussion}}
| |
| Can we agree that the eHealth backup is enough, or should we re-visit Outputbackup to create our own backup on Pagasa's computer or the x: drive? [[User:Ttenbergen|Ttenbergen]] 11:30, 4 August 2011 (CDT)
| |
| *Agree that eHealth backup is enough. Do we still need to keep the monthly data files from RIS ? or the mdb is enough? [[User:JMojica|JMojica]] 12:19, 4 August 2011 (CDT)
| |
| ** Don't think we need to keep the monthly files; if we really needed them, we would be able to request a new batch.[[User:Ttenbergen|Ttenbergen]] 12:29, 4 August 2011 (CDT)
| |
|
| |
|
| [[Category: Laptop]] | | [[Category:Laptop]] |
| [[Category: IT Instructions]] | | [[Category:IT Instructions]] |
| | [[Category:Hospital EPR]] |
| | [[Category:RIS/PACS]] |
RIS/PACS is the medical imaging database used by the WRHA. Some of our data collectors use it to count x-rays for Labs collecting.
Accessing RIS/PACS data
Double-click the "RIS PACS" shortcut on your desktop
If you don't have a shortcut, follow instructions at Desktop shortcuts for collection laptops
If you can't log on, then contact the p:EHealth ServiceDesk
Alternatively RIS PACS can be accessed at https://diviewer.manitoba-ehealth.ca/
Site training and adoption
All sites have access and should know how to use. If you don't have access please comment here. Ttenbergen 14:55, 2015 May 25 (CDT)
Direct Data Access
see Direct Data Access for RIS/PACS about an ongoing project to maybe get data from RIS/PACS directly rather than having to collect it manually.
Legacy Info - IMPAX
RIS/PACS data used to have to be viewed via installed software IMPAX. As of 2014-01 it can just be accessed via intranet.
As per email from HSC Messsenger 2014-Jan-16:
Both the PACS software and Digital Imaging Viewer are available to users at present. However, when PACS is upgraded a few months from now, the PACS system will be reserved for the diagnostic imaging and emergency departments. DI Viewer will replace the IMPAX PACS software for other users. This change will affect all current users of IMPAX viewer for reviewing diagnostic images and reports.