May 21, 2013 at 12:37 pm
Hello everyone. I have be trying to figure out how to convert patient records into HL7 format for about a week now with no success. Is this possible within SQL Server? Is it even worth doing or should I look to a third party solution. If this can be done in SQL Server, can someone please refer me to any resources or point me in the right direction.
Thanks.
May 21, 2013 at 12:49 pm
troe_atl (5/21/2013)
Hello everyone. I have be trying to figure out how to convert patient records into HL7 format for about a week now with no success. Is this possible within SQL Server? Is it even worth doing or should I look to a third party solution. If this can be done in SQL Server, can someone please refer me to any resources or point me in the right direction.Thanks.
Sure you can do that. HL7 is nothing more than a big complex string.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 22, 2013 at 11:15 am
It can be done, but it is ugly cursor-driven stuff. CLR will likely be a good bit more efficient, but you will have a lot of code to write and validate. Third party product will be best, but if you haven't used one, there is usually a TREMENDOUS overhead to learning how to use said product and then you still have to do the mapping and whatnot yourself. I would look for a 3rd party product that is generic enough that you can point it at whatever structure you have for your claims and let it auto-magically build the HL7. I have no idea if such exists (I doubt it), and it will probably cost a pretty penny if it does.
I have done healthcare data processing for a dozen years now and you should consider yourself lucky you are just having to do HL7 instead of 837I/P!! 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 24, 2013 at 6:35 am
Thanks I will look into some third party solutions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply