RIS/PACS: Difference between revisions

Line 17:

* hopefully fixed with update [[CCMDB.mdb_Change_Log_2011#ver_2011-11-18]] [[User:Ttenbergen|Ttenbergen]] 16:28, 18 November 2011 (CST)

=== combining ===

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:

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

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

@@ Line 17: / Line 17: @@
 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 ===
+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:
+* 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 ===
 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 ===