View source for RIS/PACS

''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 [[Labs]] collecting. 

== Set-up on PCs==
see [[Impax]]

== 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 steering committee if we can stop manual collection. 

=== 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). 
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 ===
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.
* hopefully fixed with update [[CCMDB.mdb_Change_Log_2011#ver_2011-11-18]] [[User:Ttenbergen|Ttenbergen]] 16:28, 18 November 2011 (CST)

=== combining ===
see [[Imaging.mdb]] query combiner

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

{{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: IT Instructions]]