p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Biztalk (http://p2p.wrox.com/forumdisplay.php?f=112)
-   -   HL7 V3 database (http://p2p.wrox.com/showthread.php?t=76415)

RaniaKort September 30th, 2009 07:04 PM

HL7 V3 database
 
I am currently building an integration layer for a heathcare billing services company. I am looking for an HL7 database to speed up my project. Any databases aound (preferably SQL Server) other ran HL7v3 LTR 1.1?

RK

Mike Toubasi November 3rd, 2009 01:17 PM

HL7 v3 SQL server Database
 
Rania,

Are you using the HL7v3 LTR 1.1 database?

If you are, please let me know if you have any questions.

You can download the latest revision from Health-IT-Bits.com

Software architect / Health-IT-Bits

RaniaKort November 4th, 2009 10:33 PM

HL7 v3 Database
 
Yes we used the HL7v3 LTR 1.1 database. It maps very well to the CDA document. I have a question about the role name: in the database you have a "ST" data type instead of an "EN". Is there a reason for that?

Mike Toubasi December 1st, 2009 11:25 AM

HL7 V3 SQL Database - Demoting Role Name to ST
 
Rania,

Since the Role name is a description of the role and is not used for searches, I have demoted it ro ST. By doing this, the EN will link only to the entity making the data structure more robust and more easy to implement by the middle tier.

Rania, you can use the blog at www.Health-IT-Bits.com


Mike Toubasi


All times are GMT -4. The time now is 06:50 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.