RIS/PACS: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 22: | Line 22: | ||
=== Aggregating === | === 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 | 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). | ||
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. | 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. | Further, the query will of course only pick up images that have been imported. | ||