Advertisement

Find answers, ask questions, and connect with our community around the world.

  • SQL Database View to DICOM Modality Worklist SCP

    Posted by infampprocon_701 on April 2, 2023 at 7:35 pm

    I 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,
    Andrew

    uhuman_p_770 replied 1 year, 1 month ago 3 Members · 6 Replies
  • 6 Replies
  • kaldridgewv2211

    Member
    April 3, 2023 at 1:33 pm

    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.

    • infampprocon_701

      Member
      April 3, 2023 at 1:43 pm

      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.

      • kaldridgewv2211

        Member
        April 5, 2023 at 12:30 pm

        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.

        • infampprocon_701

          Member
          April 5, 2023 at 4:47 pm

          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.

          • kaldridgewv2211

            Member
            April 6, 2023 at 10:24 am

            DCMTK might be worth a look.

            • uhuman_p_770

              Member
              April 11, 2023 at 9:19 am

              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.