Announcement

Collapse
No announcement yet.

FREE HL7 database available?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • FREE HL7 database available?

    Hi all,

    My boss wants me to develop a product using Mirth as a front-end and a MySQL database behind the scenes to store HL7 messages. Problem is, we ain't got no money to buy a solution, and he wants it yesterday.

    I've googled for a day or so, but the closest thing I've found costs $750 (easyhl7).

    ANY SUGGESTIONS???

    I'm addicted to my bi-weekly paycheck, so ANY and ALL help is solicited!

    Thanks in advance!!!
    Andrew J. Burg
    Health eGRC
    Lenexa, KS

  • #2
    Have you actually tried out Mirth Connect yet? It supports MySQL already.
    Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

    Nicholas Rupley
    Work: 949-237-6069
    Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


    - How do I foo?
    - You just bar.

    Comment


    • #3
      Thanks for the quick response!

      Could you clarify something for me? I know Mirth has an internal Derby database, but does that database have every single HL7 field and version defined?

      We need to accept a large number of messages from the vendor, make a minimal amount of transformations, store the messages into a MySQL database, and allow them to query the data. We need to store the data so that each and every component is accessible.

      Your thoughts?
      Andrew J. Burg
      Health eGRC
      Lenexa, KS

      Comment


      • #4
        http://www.mirthcorp.com/community/w...m+Requirements

        The embedded Derby database is meant for quick deployment, development, and testing. For production instances one of the other four supported databases is recommended.

        By default only a couple of items (like the source and type) are stored as discrete/separate metadata columns. However you can add your own columns easily enough.
        Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

        Nicholas Rupley
        Work: 949-237-6069
        Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


        - How do I foo?
        - You just bar.

        Comment


        • #5
          You will need to create your own database tables, according to your requirement, HL7 specifications, your company specifications and users requirement

          For example, my ADT table (MSSQL 2008) has the following fields

          idx int
          mrn nvarchar(25)
          aa_mrn nvarchar(15)
          visit nvarchar(20)
          aa_visit nvarchar(15)
          external_id nvarchar(25)
          global_id nvarchar(25)
          recType int
          lastUpdate nvarchar(14)
          lname nvarchar(75)
          fname nvarchar(20)
          mname nvarchar(20)
          admitDate nvarchar(14)
          birthDate nvarchar(14)
          height int
          height_exp int
          height_units int
          weight int
          weight_exp int
          weight_units int
          race int
          religion int
          sex int
          primary_lang int
          national_id nvarchar(17)
          marital_status int
          nationality int
          pt_street1 nvarchar(40)
          pt_street2 nvarchar(40)
          pt_city nvarchar(25)
          pt_state nvarchar(25)
          pt_zip nvarchar(12)
          pt_country nvarchar(15)
          dischargeDate nvarchar(14)
          toCareunit nvarchar(10)
          toRoom nvarchar(10)
          toBed nvarchar(10)
          fromCareunit nvarchar(10)
          fromRoom nvarchar(10)
          fromBed nvarchar(10)
          event_code int
          event_string nvarchar(3)
          priorvisit nvarchar(20)
          priormrn nvarchar(20
          eventDate nvarchar(14)
          asa nvarchar(12)
          ethnicity int
          forwardCt int
          fullname nvarchar(25)
          bookingNumber nvarchar(20
          procFcnType nvarchar(40)
          surgicalSpec nvarchar(50
          wardLoc nvarchar(20
          bookMag nvarchar(10
          patientCode nvarchar(40
          hospitalCode nvarchar(10



          My allergies table has:
          idx nvarchar(20
          ref_idx Int
          category Int
          descript nvarchar(40)
          severity Int
          reaction nvarchar(25)
          code Int
          [primary] int



          Many more tables obviously.....
          Last edited by flyerman; 08-11-2015, 07:14 PM.

          Comment

          Working...
          X