Sign in
Microsoft.com
 
Resources for IT Professionals
 
 
 
Resources for IT Professionals > Forums Home > BizTalk Server Forums > BizTalk Server EDI and AS2 > Splitting a 837D
Ask a questionAsk a question
Search Forums:
 

AnswerSplitting a 837D

  • Thursday, October 25, 2007 5:24 PMGeno Dillon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

     

    I'm new to BizTalk so I would appreciate some assistance on splitting a 837D claim file.  The incoming batched 837D has 10 claims in it all looping from the 2000A thru the 2400.  I want to pull the file into BizTalk 2006 R2 and output 10 837D files from ST to SE with one claim each.  What is the best way to accomplish this?

     

    I've added a basic layout in hopes that this will help.

     

    A basic layout would be something like this if you had 3 claims.  I have put the repeating segments that I need to split out in maroon.

     

    ST****~

    BHT******~

    REF****~

    1000A_Loop

    Submitter

    1000B_Loop

    Receiver

    2000A_Loop

    Provider

    Specialty

    Currency

    2010AA_Loop

    Billing_Provider

    2010AB_Loop

    Pay_to_Provider

    2000B_Loop

    2010BA_Loop

    2010BB_Loop

    2000A_Loop

    Provider

    Specialty

    Currency

    2010AA_Loop

    Billing_Provider

    2010AB_Loop

    Pay_to_Provider

    2000B_Loop

    2010BA_Loop

    2010BB_Loop

    2000A_Loop

    Provider

    Specialty

    Currency

    2010AA_Loop

    Billing_Provider

    2010AB_Loop

    Pay_to_Provider

    2000B_Loop

    2010BA_Loop

    2010BB_Loop

    SE**~

     

    I want this to become 3 separate files that would each look like this.

     

    ST****~

    BHT******~

    REF****~

    1000A_Loop

    Submitter

    1000B_Loop

    Receiver

    2000A_Loop

    Provider

    Specialty

    Currency

    2010AA_Loop

    Billing_Provider

    2010AB_Loop

    Pay_to_Provider

    2000B_Loop

    2010BA_Loop

    2010BB_Loop

    SE**~

     

    Thanks!

     

Answers

  • Friday, October 26, 2007 2:33 PMLeonid GanelineMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    When you set up the EDI properties for Parties you have the "Inbound Batch processing option". Set it up to the "Split Interchange as Transaction sets".
     
  • Friday, October 26, 2007 3:19 PMGeno Dillon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Make sure to use the multiple map for this and it works great!

     

    Thanks for the help, Leonid!

     
  • Friday, October 26, 2007 5:48 PMTony Bernard - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Geno,

     

    there is a flag in the schema that will help you split the claims out. It is subdocument_break="yes". If you navigate to the schema folders you will see a folder named 'multiple' under the 837D folder. Here is the path C:\Program Files\Microsoft BizTalk Server 2006\XSD_Schema\EDI\HIPAA\00401A1\Claim-Dental_837D\multiple. In that folder is a schema for 837D with this flag already set. You can use this to have the EDIReceive split them for you. Hope that helps.

     

     

All Replies

  • Friday, October 26, 2007 2:33 PMLeonid GanelineMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    When you set up the EDI properties for Parties you have the "Inbound Batch processing option". Set it up to the "Split Interchange as Transaction sets".
     
  • Friday, October 26, 2007 2:42 PMGeno Dillon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

     

    It is, but the file comes out the same way as it was before, all 10 claims are in one file, just in XML.  I'm just passing it through the single X12_00401_837D.xsd schema at this point.  Is there something else that I need to do?

     

    Thanks!

     
  • Friday, October 26, 2007 3:19 PMGeno Dillon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Make sure to use the multiple map for this and it works great!

     

    Thanks for the help, Leonid!

     
  • Friday, October 26, 2007 5:48 PMTony Bernard - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Geno,

     

    there is a flag in the schema that will help you split the claims out. It is subdocument_break="yes". If you navigate to the schema folders you will see a folder named 'multiple' under the 837D folder. Here is the path C:\Program Files\Microsoft BizTalk Server 2006\XSD_Schema\EDI\HIPAA\00401A1\Claim-Dental_837D\multiple. In that folder is a schema for 837D with this flag already set. You can use this to have the EDIReceive split them for you. Hope that helps.

     

     
  • Tuesday, October 30, 2007 7:35 PMGeno Dillon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Thanks, Tony!

     

    I may also need to split these claims out by Service Line if there is a different rendering provider there than at the claim level.  Is it possible to create a new schema for this with the subdocument_creation_break="yes" at the beginning of the 2400 loop?  I would be checking to see if the 2420A NM109 = 2310B NM109, if they are not equal I would run the file through this new schema to create multiple claim files by breaking it for each service line. 

     

    Any thoughts on the best way to do this would be appreciated.

     

    Thanks!

     

     
  • Friday, April 25, 2008 12:33 AMRP27 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    I am using Bizatlk 2006 R2 and I am having problem parsing 837D at receiving location. I have configured party with multiple option selected. I have even validated the 837d message with 837d edi schema (multiple) in visual studio. Is there something I am missing out.

     

    Thanks

     
  • Friday, October 30, 2009 10:37 AMNeelesh Jain Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    I am using Bizatlk 2006 R2 and I am having problem parsing 837D at receiving location. I have configured party with multiple option selected. I have even validated the 837d message with 837d edi schema (multiple) in visual studio. Is there something I am missing out.

     

    Thanks


    I am dealing with X12 271 EDI files of 100 MB+. I have repeating 2000A loops....repeating for more than 5,00,000 times. EDIDisassembler runs out of memory. I wanted to split this 100 MB of file to 10 MB each for 2000A loop. so one file will have 50,000 loops. How I can achieve this?...Any Idea folks?.


    Neelesh Jain
     
  • Monday, November 02, 2009 6:54 AMNeelesh Jain Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi,

    Did u get any idea how to split singlt ST SE section based on number of records?
    I need it urgently....If you coud provide me some trick.

    Neelesh