none
Looping HIPAA 837 to a flat structure RRS feed

  • Question

  • I am having difficulty with the mapping of ClaimQuantity elements in an 837I to a flat structure that will be inserted into SQL.

    Specifically the QuantityQualifier and ClaimDaysCount can repeat up to four times, and if it does I want all four to be represented in the destination.

    I have a looping functoid connected from the root of the 2000B loop to the record node of of my destination.  I have another connected from the root of the 2300 loop to the same record node of my destination as well. 

    How do I get the ClaimQuantity element to loop so that it populates all the attributes in my destination schema in one pass?

    Source structure:

    - <ns0:QTY_ClaimQuantity_TS837Q3_2300>
      <QTY01__QuantityQualifier>CA</QTY01__QuantityQualifier>
      <QTY02__ClaimDaysCount>3</QTY02__ClaimDaysCount>
    - <ns0:QTY03_C001U1845_TS837Q3_2300>
      <QTY03_C00101U1846_UnitOrBasisForMeasurementCode>DA</QTY03_C00101U1846_UnitOrBasisForMeasurementCode>
      </ns0:QTY03_C001U1845_TS837Q3_2300>
      </ns0:QTY_ClaimQuantity_TS837Q3_2300>
    - <ns0:QTY_ClaimQuantity_TS837Q3_2300>
      <QTY01__QuantityQualifier>CD</QTY01__QuantityQualifier>
      <QTY02__ClaimDaysCount>21</QTY02__ClaimDaysCount>
    - <ns0:QTY03_C001U1845_TS837Q3_2300>
      <QTY03_C00101U1846_UnitOrBasisForMeasurementCode>DA</QTY03_C00101U1846_UnitOrBasisForMeasurementCode>
      </ns0:QTY03_C001U1845_TS837Q3_2300>
      </ns0:QTY_ClaimQuantity_TS837Q3_2300>
    - <ns0:QTY_ClaimQuantity_TS837Q3_2300>
      <QTY01__QuantityQualifier>LA</QTY01__QuantityQualifier>
      <QTY02__ClaimDaysCount>4</QTY02__ClaimDaysCount>
    - <ns0:QTY03_C001U1845_TS837Q3_2300>
      <QTY03_C00101U1846_UnitOrBasisForMeasurementCode>DA</QTY03_C00101U1846_UnitOrBasisForMeasurementCode>
      </ns0:QTY03_C001U1845_TS837Q3_2300>
      </ns0:QTY_ClaimQuantity_TS837Q3_2300>
    - <ns0:QTY_ClaimQuantity_TS837Q3_2300>
      <QTY01__QuantityQualifier>NA</QTY01__QuantityQualifier>
      <QTY02__ClaimDaysCount>42</QTY02__ClaimDaysCount>
    - <ns0:QTY03_C001U1845_TS837Q3_2300>
      <QTY03_C00101U1846_UnitOrBasisForMeasurementCode>DA</QTY03_C00101U1846_UnitOrBasisForMeasurementCode>
      </ns0:QTY03_C001U1845_TS837Q3_2300>
      </ns0:QTY_ClaimQuantity_TS837Q3_2300>


    Destination structure:

    < CLAIMQTY COVERED_DAYS="3" COINSURANCE_DAYS="21" LIFETIME_RESERVE_DAYS="4" NONCOVERED_DAYS="42"  />
    • Moved by Ben Cline1Moderator Saturday, May 2, 2009 3:48 PM EDI Related (From:BizTalk Server General)
    Friday, May 1, 2009 5:54 PM

Answers

All replies