HL7 mapping issue !!!

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › HL7 mapping issue !!!

Viewing 0 reply threads
  • Author
    Posts
    • #24584

      Hi,

      I am facing this issue in Mapping HL7 schema to SQLOrder Schema. The problem is in my source schema there is a segment called TQ1 which will has looping structure and I am mapping this destination schema which has a flat structure.

      Here is the part of my SOURCE SCHEMA which is repeating

       <</ORC_CommonOrder>
        <TQ1_TimingQuantity>
          <TQ1_1_SetIdTq1>1</TQ1_1_SetIdTq1>
          <TQ1_2_Quantity>
            <CQ_0_Quantity>1</CQ_0_Quantity>
            <CQ_1_Units>
              <CQ_1_0_Identifier>EA</CQ_1_0_Identifier>
            </CQ_1_Units>
          </TQ1_2_Quantity>
          <TQ1_3_RepeatPattern>
            <RPT_0_RepeatPatternCode>
              <RPT_0_0_Identifier>QD</RPT_0_0_Identifier>
            </RPT_0_RepeatPatternCode>
          </TQ1_3_RepeatPattern>
          <TQ1_4_ExplicitTime>0800</TQ1_4_ExplicitTime>
          <TQ1_5_RelativeTimeAndUnits>
            <CQ_0_Quantity></CQ_0_Quantity>
          </TQ1_5_RelativeTimeAndUnits>
          <TQ1_6_ServiceDuration>
            <CQ_0_Quantity></CQ_0_Quantity>
          </TQ1_6_ServiceDuration>
          <TQ1_7_StartDateTime>
            <TS_0_Time>20100405000000</TS_0_Time>
          </TQ1_7_StartDateTime>
          <TQ1_8_EndDateTime>
            <TS_0_Time></TS_0_Time>
          </TQ1_8_EndDateTime>
          <TQ1_9_Priority>
            <CWE_0_Identifier>P</CWE_0_Identifier>
          </TQ1_9_Priority>
          <TQ1_10_ConditionText></TQ1_10_ConditionText>
          <TQ1_11_TextInstruction>1T PO QD</TQ1_11_TextInstruction>
          <TQ1_12_Conjunction>A</TQ1_12_Conjunction>
          <TQ1_13_OccurrenceDuration>
            <CQ_0_Quantity></CQ_0_Quantity>
          </TQ1_13_OccurrenceDuration>
          <TQ1_14_TotalOccurrenceS></TQ1_14_TotalOccurrenceS>
        </TQ1_TimingQuantity>
        <TQ1_TimingQuantity>
          <TQ1_1_SetIdTq1>2</TQ1_1_SetIdTq1>
          <TQ1_2_Quantity>
            <CQ_0_Quantity>1</CQ_0_Quantity>
            <CQ_1_Units>
              <CQ_1_0_Identifier>EA</CQ_1_0_Identifier>
            </CQ_1_Units>
          </TQ1_2_Quantity>
          <TQ1_3_RepeatPattern>
            <RPT_0_RepeatPatternCode>
              <RPT_0_0_Identifier>QHS PRN</RPT_0_0_Identifier>
            </RPT_0_RepeatPatternCode>
          </TQ1_3_RepeatPattern>
          <TQ1_4_ExplicitTime></TQ1_4_ExplicitTime>
          <TQ1_5_RelativeTimeAndUnits>
            <CQ_0_Quantity></CQ_0_Quantity>
          </TQ1_5_RelativeTimeAndUnits>
          <TQ1_6_ServiceDuration>
            <CQ_0_Quantity></CQ_0_Quantity>
          </TQ1_6_ServiceDuration>
          <TQ1_7_StartDateTime>
            <TS_0_Time>20100405000000</TS_0_Time>
          </TQ1_7_StartDateTime>
          <TQ1_8_EndDateTime>
            <TS_0_Time></TS_0_Time>
          </TQ1_8_EndDateTime>
          <TQ1_9_Priority>
            <CWE_0_Identifier>P</CWE_0_Identifier>
          </TQ1_9_Priority>
          <TQ1_10_ConditionText></TQ1_10_ConditionText>
          <TQ1_11_TextInstruction>1T PO QHS PRN DAILY WT GAIN &gt;5 LBS</TQ1_11_TextInstruction>
          <TQ1_12_Conjunction>A</TQ1_12_Conjunction>
          <TQ1_13_OccurrenceDuration>
            <CQ_0_Quantity></CQ_0_Quantity>
          </TQ1_13_OccurrenceDuration>
          <TQ1_14_TotalOccurrenceS></TQ1_14_TotalOccurrenceS>
        </TQ1_TimingQuantity>
          

      Here is my Destination Schema

       

      <?xml version=”1.0″ encoding=”utf-16″?>

      <xs:schema xmlns:ns0=”http://Schemas.PropertySchema.PropertySchema” xmlns:b=”http://schemas.microsoft.com/BizTalk/2003” xmlns=”http://Schemas.StandardOrder” targetNamespace=”http://Schemas.StandardOrder” xmlns:xs=”http://www.w3.org/2001/XMLSchema“>

       <xs:annotation>

        <xs:appinfo>

         <b:imports xmlns:b=”http://schemas.microsoft.com/BizTalk/2003“>

          <b:namespace prefix=”ns0″ uri=”http://Schemas.PropertySchema.PropertySchema” location=”.\propertyschema.xsd” />

         </b:imports>

        </xs:appinfo>

       </xs:annotation>

       <xs:element name=”StandardOrder”>

        <xs:annotation>

         <xs:appinfo>

          <b:properties>

           <b:property distinguished=”true” xpath=”/*[local-name()=’StandardOrder’ and namespace-uri()=’http://Schemas.StandardOrder’%5D/*%5Blocal-name()=’TransactionType&#8217; and namespace-uri()=”]” />

           <b:property name=”ns0:NDC” xpath=”/*[local-name()=’StandardOrder’ and namespace-uri()=’http://Schemas.StandardOrder’%5D/*%5Blocal-name()=’NDC&#8217; and namespace-uri()=”]” />

          </b:properties>

         </xs:appinfo>

        </xs:annotation>

        <xs:complexType>

         <xs:sequence>

          <xs:element name=”TransactionType” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”PatientID” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”PatientFirstName” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”PatientLastName” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”Wing” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”Room” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”Bed” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”Facility” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”AdminStartDate” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”AdminStopDate” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”DayOfWeek” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”HOA” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”DrugID” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”NDC” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”DrugDescription” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”Unit” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”DispenseQuantity” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”AdminInstructions” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”DoseUnitDescription” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”PharmacistName” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”PharmacistInitials” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”DoctorName” type=”xs:string” />

          <xs:element minOccurs=”0″ name=”RxNumber” type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate2″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”SigCount” type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate2″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek2″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA2″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity2″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate3″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ default=” ” name=”AdminStopDate3″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek3″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA3″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity3″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate4″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate4″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek4″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA4″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity4″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate5″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate5″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek5″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA5″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity5″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate6″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate6″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek6″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA6″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity6″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate7″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate7″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek7″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA7″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity7″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate8″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate8″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek8″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA8″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity8″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate9″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate9″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek9″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA9″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity9″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStartDate10″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”AdminStopDate10″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DaysOfWeek10″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”HOA10″ type=”xs:string” />

          <xs:element minOccurs=”0″ maxOccurs=”1″ name=”DispenseQuantity10″ type=”xs:string” />

         </xs:sequence>

        </xs:complexType>

       </xs:element>

      </xs:schema>

      I have mapped it such that there is a looping functoid and iteration which are attached to TQ1 elements (TS_0_Time) in the source schema then I check the value of iteration if it is equal to 1 then I map it Value Mapping flattening functoid and which is in turn mapped to AdminStartDt. Also value mapping functoid gets Admin start date gets a value from

       

      Here is the XSL produced when I validate the Map. Also I am able to test the map but the problem is the the TQ1 segment loops only 1 time as you can see in the XSL below because in for-each loop it limits it [1]. so the position counter never gets to 2. How can fix this problem. 

      <?xml version=”1.0″ encoding=”UTF-16″?>

      <xsl:stylesheet xmlns:xsl=”http://www.w3.org/1999/XSL/Transform” xmlns:msxsl=”urn:schemas-microsoft-com:xslt” xmlns:var=”http://schemas.microsoft.com/BizTalk/2003/var” exclude-result-prefixes=”msxsl var s3 s1 s2 s0 userCSharp” version=”1.0″ xmlns:ns0=”http://Schemas.StandardOrder” xmlns:s3=”http://microsoft.com/HealthCare/HL7/2X/2.5/DataTypes” xmlns:s1=”http://microsoft.com/HealthCare/HL7/2X” xmlns:s2=”http://microsoft.com/HealthCare/HL7/2X/2.5/Tables” xmlns:s0=”http://microsoft.com/HealthCare/HL7/2X/2.5/Segments” xmlns:userCSharp=”http://schemas.microsoft.com/BizTalk/2003/userCSharp“>

       <xsl:output omit-xml-declaration=”yes” method=”xml” version=”1.0″ />

       <xsl:template match=”/”>

        <xsl:apply-templates select=”/s1:RDE_O11_25_GLO_DEF” />

       </xsl:template>

       <xsl:template match=”/s1:RDE_O11_25_GLO_DEF”>

        <xsl:variable name=”var:v27″ select=”userCSharp:StringConcat(string(ORC_CommonOrder/ORC_11_VerifiedBy/XCN_1_FamilyName/XCN_1_0_Surname/text()) , &quot;,&quot; , string(ORC_CommonOrder/ORC_11_VerifiedBy/XCN_2_GivenName/text()))” />

        <xsl:variable name=”var:v28″ select=”userCSharp:StringConcat(string(ORC_CommonOrder/ORC_12_OrderingProvider/XCN_1_FamilyName/XCN_1_0_Surname/text()) , &quot;,&quot; , string(ORC_CommonOrder/ORC_12_OrderingProvider/XCN_2_GivenName/text()))” />

        <ns0:StandardOrder>

         <TransactionType>

          <xsl:value-of select=”ORC_CommonOrder/ORC_1_OrderControl/text()” />

         </TransactionType>

         <xsl:variable name=”var:v1″ select=”userCSharp:GetPatientID(string(PID_PatientIdentification/PID_3_PatientIdentifierList/CX_0_IdNumber/text()))” />

         <PatientID>

          <xsl:value-of select=”$var:v1″ />

         </PatientID>

         <xsl:if test=”PID_PatientIdentification/PID_5_PatientName/XPN_1_GivenName”>

          <PatientFirstName>

           <xsl:value-of select=”PID_PatientIdentification/PID_5_PatientName/XPN_1_GivenName/text()” />

          </PatientFirstName>

         </xsl:if>

         <xsl:if test=”PID_PatientIdentification/PID_5_PatientName/XPN_0_FamilyName/XPN_0_0_Surname”>

          <PatientLastName>

           <xsl:value-of select=”PID_PatientIdentification/PID_5_PatientName/XPN_0_FamilyName/XPN_0_0_Surname/text()” />

          </PatientLastName>

         </xsl:if>

         <xsl:if test=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_0_PointOfCare”>

          <Wing>

           <xsl:value-of select=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_0_PointOfCare/text()” />

          </Wing>

         </xsl:if>

         <xsl:if test=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_1_Room”>

          <Room>

           <xsl:value-of select=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_1_Room/text()” />

          </Room>

         </xsl:if>

         <xsl:if test=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_2_Bed”>

          <Bed>

           <xsl:value-of select=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_2_Bed/text()” />

          </Bed>

         </xsl:if>

         <xsl:if test=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_3_Facility/PL_3_0_NamespaceId”>

          <Facility>

           <xsl:value-of select=”PV1_PatientVisit/PV1_3_AssignedPatientLocation/PL_3_Facility/PL_3_0_NamespaceId/text()” />

          </Facility>

         </xsl:if>

         <xsl:for-each select=”TQ1_TimingQuantity[1]”>

          <xsl:variable name=”var:v2″ select=”position()” />

          <xsl:variable name=”var:v3″ select=”userCSharp:LogicalEq(string($var:v2) , &quot;1&quot;)” />

          <xsl:if test=”string($var:v3)=’true'”>

           <xsl:variable name=”var:v4″ select=”TQ1_7_StartDateTime/TS_0_Time/text()” />

           <AdminStartDate>

            <xsl:value-of select=”$var:v4″ />

           </AdminStartDate>

          </xsl:if>

         </xsl:for-each>

         <xsl:for-each select=”TQ1_TimingQuantity[1]”>

          <xsl:variable name=”var:v5″ select=”position()” />

          <xsl:variable name=”var:v6″ select=”userCSharp:LogicalEq(string(TQ1_1_SetIdTq1/text()) , &quot;1&quot;)” />

          <xsl:if test=”string($var:v6)=’true'”>

           <xsl:variable name=”var:v7″ select=”TQ1_8_EndDateTime/TS_0_Time/text()” />

           <xsl:variable name=”var:v8″ select=”userCSharp:StringLeft(string($var:v7) , &quot;8&quot;)” />

           <AdminStopDate>

            <xsl:value-of select=”$var:v8″ />

           </AdminStopDate>

          </xsl:if>

         </xsl:for-each>

         <xsl:for-each select=”TQ1_TimingQuantity[1]”>

          <xsl:variable name=”var:v9″ select=”position()” />

          <xsl:for-each select=”TQ1_3_RepeatPattern”>

           <xsl:for-each select=”RPT_0_RepeatPatternCode”>

            <xsl:variable name=”var:v10″ select=”userCSharp:LogicalEq(string(../../TQ1_1_SetIdTq1/text()) , &quot;1&quot;)” />

            <xsl:if test=”string($var:v10)=’true'”>

             <xsl:variable name=”var:v11″ select=”RPT_0_0_Identifier/text()” />

             <xsl:variable name=”var:v12″ select=”userCSharp:MyConcat(string($var:v11))” />

             <DayOfWeek>

              <xsl:value-of select=”$var:v12″ />

             </DayOfWeek>

            </xsl:if>

           </xsl:for-each>

          </xsl:for-each>

         </xsl:for-each>

         <xsl:for-each select=”TQ1_TimingQuantity[1]”>

          <xsl:variable name=”var:v13″ select=”position()” />

          <xsl:for-each select=”TQ1_3_RepeatPattern”>

           <xsl:for-each select=”RPT_0_RepeatPatternCode”>

            <xsl:variable name=”var:v14″ select=”string(../../TQ1_1_SetIdTq1/text())” />

            <xsl:variable name=”var:v15″ select=”userCSharp:LogicalEq($var:v14 , &quot;1&quot;)” />

            <xsl:if test=”string($var:v15)=’true'”>

             <xsl:variable name=”var:v16″ select=”RPT_0_0_Identifier/text()” />

             <xsl:if test=”string($var:v15)=’true'”>

              <xsl:variable name=”var:v17″ select=”userCSharp:InitCumulativeConcat(0)” />

              <xsl:for-each select=”/s1:RDE_O11_25_GLO_DEF/TQ1_TimingQuantity[1]/TQ1_4_ExplicitTime”>

               <xsl:variable name=”var:v18″ select=”userCSharp:AddToCumulativeConcat(0,string(./text()),&quot;1000&quot;)” />

              </xsl:for-each>

              <xsl:variable name=”var:v19″ select=”userCSharp:GetCumulativeConcat(0)” />

              <xsl:variable name=”var:v20″ select=”userCSharp:GetHOA(string($var:v16) , string($var:v19))” />

              <HOA>

               <xsl:value-of select=”$var:v20″ />

              </HOA>

             </xsl:if>

            </xsl:if>

           </xsl:for-each>

          </xsl:for-each>

         </xsl:for-each>

         <xsl:if test=”RXE_PharmacyTreatmentEncodedOrder/RXE_2_GiveCode/CE_2_NameOfCodingSystem”>

          <DrugID>

           <xsl:value-of select=”RXE_PharmacyTreatmentEncodedOrder/RXE_2_GiveCode/CE_2_NameOfCodingSystem/text()” />

          </DrugID>

         </xsl:if>

         <xsl:if test=”RXE_PharmacyTreatmentEncodedOrder/RXE_2_GiveCode/CE_0_Identifier”>

          <NDC>

           <xsl:value-of select=”RXE_PharmacyTreatmentEncodedOrder/RXE_2_GiveCode/CE_0_Identifier/text()” />

          </NDC>

         </xsl:if>

         <xsl:if test=”RXE_PharmacyTreatmentEncodedOrder/RXE_2_GiveCode/CE_1_Text”>

          <DrugDescription>

           <xsl:value-of select=”RXE_PharmacyTreatmentEncodedOrder/RXE_2_GiveCode/CE_1_Text/text()” />

          </DrugDescription>

         </xsl:if>

         <xsl:if test=”RXE_PharmacyTreatmentEncodedOrder/RXE_6_GiveDosageForm/CE_0_Identifier”>

          <Unit>

           <xsl:value-of select=”RXE_PharmacyTreatmentEncodedOrder/RXE_6_GiveDosageForm/CE_0_Identifier/text()” />

          </Unit>

         </xsl:if>

         <xsl:for-each select=”TQ1_TimingQuantity[1]”>

          <xsl:variable name=”var:v21″ select=”position()” />

          <xsl:for-each select=”TQ1_3_RepeatPattern”>

           <xsl:for-each select=”RPT_0_RepeatPatternCode”>

            <xsl:variable name=”var:v22″ select=”string(../../TQ1_1_SetIdTq1/text())” />

            <xsl:variable name=”var:v23″ select=”userCSharp:LogicalEq($var:v22 , &quot;1&quot;)” />

            <xsl:if test=”string($var:v23)=’true'”>

             <xsl:variable name=”var:v24″ select=”RPT_0_0_Identifier/text()” />

             <xsl:if test=”string($var:v23)=’true'”>

              <xsl:variable name=”var:v25″ select=”../../TQ1_2_Quantity/CQ_0_Quantity/text()” />

              <xsl:if test=”../../../ZPI_AdditionalPrescriptionInformationSegment/ZPI.9_MaxDailyQty/text()=’true'”>

               <xsl:variable name=”var:v26″ select=”userCSharp:MyConcat(string($var:v24) , string($var:v25) , string($var:v23))” />

               <DispenseQuantity>

                <xsl:value-of select=”$var:v26″ />

               </DispenseQuantity>

              </xsl:if>

             </xsl:if>

            </xsl:if>

           </xsl:for-each>

          </xsl:for-each>

         </xsl:for-each>

         <xsl:if test=”RXE_PharmacyTreatmentEncodedOrder/RXE_7_ProviderSAdministrationInstructions/CE_1_Text”>

          <AdminInstructions>

           <xsl:value-of select=”RXE_PharmacyTreatmentEncodedOrder/RXE_7_ProviderSAdministrationInstructions/CE_1_Text/text()” />

          </AdminInstructions>

         </xsl:if>

         <PharmacistName>

          <xsl:value-of select=”$var:v27″ />

         </PharmacistName>

         <xsl:if test=”ORC_CommonOrder/ORC_11_VerifiedBy/XCN_0_IdNumber”>

          <PharmacistInitials>

           <xsl:value-of select=”ORC_CommonOrder/ORC_11_VerifiedBy/XCN_0_IdNumber/text()” />

          </PharmacistInitials>

         </xsl:if>

         <DoctorName>

          <xsl:value-of select=”$var:v28″ />

         </DoctorName>

         <xsl:if test=”RXE_PharmacyTreatmentEncodedOrder/RXE_15_PrescriptionNumber”>

          <RxNumber>

           <xsl:value-of select=”RXE_PharmacyTreatmentEncodedOrder/RXE_15_PrescriptionNumber/text()” />

          </RxNumber>

         </xsl:if>

         <xsl:for-each select=”TQ1_TimingQuantity[1]”>

          <xsl:variable name=”var:v29″ select=”position()” />

          <xsl:variable name=”var:v30″ select=”userCSharp:LogicalEq(string($var:v29) , &quot;2&quot;)” />

          <xsl:if test=”string($var:v30)=’true'”>

           <xsl:variable name=”var:v31″ select=”TQ1_7_StartDateTime/TS_0_Time/text()” />

           <AdminStartDate2>

            <xsl:value-of select=”$var:v31″ />

           </AdminStartDate2>

          </xsl:if>

         </xsl:for-each>

         <AdminStopDate3>

          <xsl:text> </xsl:text>

         </AdminStopDate3>

        </ns0:StandardOrder>

       </xsl:template>

       <msxsl:script language=”C#” implements-prefix=”userCSharp”><![CDATA[

      .
      .
      ]]></msxsl:script>

      </xsl:stylesheet>

      Can somebody please help ?

       

      Thanks,

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.