-
SQL Database View to DICOM Modality Worklist SCP
Posted by infampprocon_701 on April 2, 2023 at 7:35 pmI have a system that does not have an outbound HL7 interface, but it has a database view of the exams I would like to present on a DICOM Modality Worklist. I was wondering if anyone knew of an intergration tool that could do this.
Please let me know if you have any suggestions or ideas.
Thanks,
Andrewuhuman_p_770 replied 1 year, 1 month ago 3 Members · 6 Replies -
6 Replies
-
not sure the question makes sense. Outbound HL7 wouldn’t have anything to do with DICOM modality worklist. If you had an inbound HL& interface feeding the database maybe. If you have a system that has a database and provides an MWL SCP you should be able to setup something. What will be returned to a machine querying that DICOM SCP I couldn’t tell you.
-
My apologise for not making my question clear. I have a system that is used for scheduling and managing theatre events. This system is not capable of generating an outbound HL7 interface (ideally it would supply an SIU feed of scheduled activity).
I have a number of systems which would like to subscribe to a DICOM Modality Worklist in order to receive the identity of the patient that is in the operating theatre.
One apporach would be for me to build a custom SIU interface and deliver this HL7 feed to a system that can turn this into a DICOM Modality Worklist. But I wondered if there was anything I could use to map data directly from a database view of theatre activity to a DICOM Modality Worklist.
Hopefully that helps clarify my question.-
just from an application perspective you would need a database of data. Then a DICOM WML service using that data base. If you can’t get the data from an HL7 feed the only thing I can think would be manually putting info into an application, or maybe using SQL to extract and import data.
-
Thanks Dan. Yes I have access to the data and can add additional tables to the database. I have excellent SQL tools to extract and update data in the database. The bit I am struggling with is finding an application/utility that can receive the extract and present as DICOM MWL SCP. The all seem to consume with ORM or SIU messages and I was hoping to avoid having to convert into that format.
-
-
MirthConnect. Build a channel to query your DB and build your MWL entry . Use something like dcm4chee as your MWL server and setup your MC destination to feed it.
-
-
-
-
-