Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
| Search | Today's Posts | Mark Forums Read
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 30th, 2009, 07:04 PM
Registered User
 
Join Date: Sep 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
  #2 (permalink)  
Old November 3rd, 2009, 01:17 PM
Registered User
 
Join Date: Nov 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
  #3 (permalink)  
Old November 4th, 2009, 10:33 PM
Registered User
 
Join Date: Sep 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
  #4 (permalink)  
Old December 1st, 2009, 11:25 AM
Registered User
 
Join Date: Nov 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Biztalk and Hl7 tcronin@cmsstl.com Biztalk 5 July 31st, 2013 03:12 AM
impersonate user wss v3 DumAss SharePoint Development 0 August 28th, 2007 06:15 AM
Use of X509V1/V3 create Example .? harmit7 BOOK: Beginning Cryptography with Java 1 April 10th, 2007 08:43 PM
Help with HL7 v3 tarun.mistry Biztalk 0 October 12th, 2005 05:26 AM
XMLHTTP v3 Automation Error jinyen VB Components 0 May 12th, 2004 03:44 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.