none
Biztalk 2010 BRE question RRS feed

  • Question

  • We are processing 837I claim files.

    We have a need to add some additional validation to an existing BRE policy that will validate Admission Date (For valid data and whether the element exists).

    A sample claim file has three claims.  The first claim has an admission date.  The last two do not have this loop at all.

    Normally I would pull the field by dragging the element directly from the schema and check its length (to see if it exists), then perform further validation on the data if it does exist.

    For each of the 3 claims we get the admission date from the first claim rather than claim 1 - admission date, claim 2 and 3 element does not exist.

    I am trying to conceptualize how I should be accessing the element in the message.

    Here is the current XPath selector:

    /*[local-name()='X12_00501_837_I' and namespace-uri()='http://schemas.microsoft.com/BizTalk/EDI/X12/2006']/*[local-name()='TS837_2000A_Loop' and namespace-uri()='http://schemas.microsoft.com/BizTalk/EDI/X12/2006']/*[local-name()='TS837_2000B_Loop' and namespace-uri()='http://schemas.microsoft.com/BizTalk/EDI/X12/2006']/*[local-name()='TS837_2300_Loop' and namespace-uri()='http://schemas.microsoft.com/BizTalk/EDI/X12/2006']/*[local-name()='DTP_SubLoop' and namespace-uri()='http://schemas.microsoft.com/BizTalk/EDI/X12/2006']/*[local-name()='DTP_AdmissionDate_Hour' and namespace-uri()='http://schemas.microsoft.com/BizTalk/EDI/X12/2006']

    My sense is that I need to change the XPath selector to something with a relative path to prevent the fact from picking the data from the first claim when it does not exist.

    Any help is much appreciated.

    Thanks,

    Simon

    Monday, July 2, 2012 8:59 PM

Answers

  • Thanks for the reply.  We are using a C# Helper class to pass in the data for validation.  The issue was that the data being passed in is the admission date for the first claim for each of the claims.  However over the night it occurred to me that I can do some post shredding validation against the claim data in the intermediate sql database.

    • Marked as answer by SiBod Tuesday, July 3, 2012 11:43 AM
    Tuesday, July 3, 2012 11:43 AM

All replies