What is HL7?

[LonnieJohnson]

Can SQL Server export to an HL7 format? If so how?

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[SgtJarrow]

I am not familiar with this standard, but after a couple web searches, I found that this is a healthcare standard for storing data. It seems to me it is more focused on the database model and not any "format" or "export" type.

This model seems to be a semi-standard to simplify the transferring of data from one database to another, such as transferring records from one doctor's office to a new doctor's office.

I found this page which seems to outline the model pretty well.

http://wiki.hl7.org/index.php?title=ORM_best_practices

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
C#.NET Programmer

 

[TheBugSlayer]

I work with HL7 formats. SQL Server does not intrinsically export to HL7. But you can format the data you want to export to match an HL7 standard. As an example, doctors send requests for tests and patient information to a lab and labs send data back to the clients in an HL7 format.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)