Back to Pilotfish Home

Data Mapping To HL7 Message Template


    Data Mapping to HL7 Message Template using Healthcare Integration Engine – eiConsole

    This is a demonstration of the eiConsole for Healthcare mapping to HL7 Message Template feature. In the course of this demonstration, I will show you just how easy it is to use a sample HL7 message, for instance from an implementation guide, to create a new mapping from a custom format.

    Here we are in the eiConsole, we’ll add a source and add a target. We’ll create a new transformation for this mapping. The first thing we need to do is to build the map itself. We’ll do this in the PilotFish Data Mapper. Our store’s format will be a custom XML file, so we’ll choose the XML format builder and load our custom XML.

    The data mapper will load the structure that we can then view. Now we’ll use our sample HL7 message using the HL7 version 2.x format builder to create a template to map to. We’ll choose our HL7 version, in this case, 2.4, we’ll elect to use Friendly Names, and we’ll check to use a sample file. We’ll choose our sample HL7 message, click open, and read format.

    A slice of the HL7 Vocabulary corresponding to the sample message provided will appear in the target format tree. Now, we’ll want to create a mapping. To do this under the formats menu, I’ll choose to add my target sample data as a template and click yes.

    A number of green nodes corresponding to the segment’s fields and components used in the sample message will automatically appear in my mapping panel. By default, these fields will contain the values from my sample file. However, I now want to map dynamic information from my source data into some of these fields. For instance, let’s map the patient name. I’ll delete the hard-coded values and replace them using drag & drop with values from my source XML. I can also manipulate this data during the mapping. For instance, let’s map the date of birth. We’ll see that my message format expects YYYYMMDD with no punctuation.

    However, in my source the format is MM-DD-YYYY. Again, we’ll delete the hardcoded value, drag & drop the volume from the source. But this time, we’ll use one of the palliative functions above to do the date manipulation. I’ll choose the date-time formatting tool and drag it onto the field requiring the formatting and enter in my source pattern which is MMDDYYYY and my desired output YYYYMMDD and click OK.

    As I do this, XSLT is being generated for my mapping that I can then test in the testing view of the data mapper. Here we can see values from my source mapped into my HL7 XML template. Similarly, we can see the date of birth with the formatting rules placed in the date and time of birth field.

    Once I’ve completed my mapping to the template, I save it and return to the main eiConsole screen to convert my output into delimited HL7. I’ll choose the HL7 Version 2.x transformer. Again, select the expected version and check the friendly name option. I save my work and test in the eiConsole’s testing mode to test my transformation. I’ll start at the first stage and end after the mapping onto HL7 2.x and click the execute test button.

    I’ll choose my custom XML file and click open. Checkmarks will appear as each stage completes. Here we can see our custom XML format with Sally Underweather born on September 19, 1980. Here we can see that data after being mapped onto the HL7 message template. Again, you can see Sally Underweather; this time her name and the PID component, and the date of birth as well.

    Finally, the HL7 transformation module converted that into a delimited HL7 compliant format. So, it’s just that easy you can take a sample HL7 message from any implementation guide or vendor system loaded as a target template, drag & drop your source data onto it, and you’re done! You’ve created a transformation to a custom defined HL7 message template.

    Review our long list of other helpful HL7 Tools included with our Integration Engine, the eiConsole. We encourage you to try it for yourself by downloading a Free 90-Day Trial of eiConsole by PilotFish.

    For more information, please call us at 813 864 8662 or click the link below to email us.

    HL7 is the registered trademark of Health Level Seven International. 

    This is a unique website which will require a more modern browser to work! Please upgrade today!