none
Splitting a 837D RRS feed

  • Question

  •  

    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!

    Thursday, October 25, 2007 5:24 PM

Answers

  • 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:33 PM
  • Make sure to use the multiple map for this and it works great!

     

    Thanks for the help, Leonid!

    Friday, October 26, 2007 3:19 PM
  • 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.

     

    Friday, October 26, 2007 5:48 PM

All replies

  • 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:33 PM
  •  

    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 2:42 PM
  • Make sure to use the multiple map for this and it works great!

     

    Thanks for the help, Leonid!

    Friday, October 26, 2007 3:19 PM
  • 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.

     

    Friday, October 26, 2007 5:48 PM
  • 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!

     

    Tuesday, October 30, 2007 7:35 PM
  • 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, April 25, 2008 12:33 AM
  • 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
    Friday, October 30, 2009 10:37 AM
  • 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
    Monday, November 2, 2009 6:54 AM
  • Hi Tony,

    Do you know that if this subdocument_break = "yes" Property works with NON-HIPAA EDI Schemas? I tried to use this property on a Inbound 850 to split the document @ Line Level (PO1) and it does not work.

     

    This is what I have modified so far in the 850 XSD:

    Add - subdocument_break="yes" to the Schema Annotation on the top ..AND...

    Add  - subdocument_creation_break="yes" to the PO1Loop Annotation

     

    Anyone encountered this?

     

    Thanks,

    -amit

     

     

     

     


    amit kumar * Please Indicate "Mark as Answer" if this Post has Answered the Question
    Thursday, October 27, 2011 5:58 PM