How to write multiple XML files with nested to database

Dear Code Master

Blessed day to you all, and i believe the question meet you all in good health. i have a challange with my code and i really need your assistance.

The issue is that i develop an application that generate patient level records in XML format. some of the facilities that use the application have patient greater than 10,000.

Now i want to read the data below from it

FacID

FacName

DOB

Sex

Age

ArtStartDate

ArtVisit

Nxt_App_Date

Drug_Reg

VL_Result

VL_Date

TestCode

i wrote the code below to see if i can read through each XML file and to get the above fields but i keep geting multiples record i thin the loops are the cause.

Dim Enrol_idm As String = ""
Dim xMLDirectory As String = Server.MapPath(String.Format("~/{0}/", "NDRExport"))
If Not Directory.Exists(xMLDirectory) Then
' Directory.CreateDirectory(xMLDirectory)
fillClient.Show("Create NDRExport Folder before using this utility")
End If
'Dim xMLName As New ArrayList
'xMLName.Add(Directory.GetFiles(xMLDirectory, "*.xml"))
Dim xMLName() As String = Directory.GetFiles(xMLDirectory, "*.xml")
Dim ID As String = ""
Dim FacID As String = ""
Dim FacName As String = ""
Dim DOB As String = ""
Dim Sex As String = ""
Dim Age As String = ""
Dim AgeA As Integer
Dim AgeP As Integer
Dim ArtStartDate As String = ""
Dim ArtVisit As String = ""
Dim Nxt_App_Date As String = ""
Dim Drug_Reg As String = ""
Dim VL_Result As String = ""
Dim VL_Date As String = ""
Dim TestCode As String = ""
FC.Create_RADET_Table()
For Each _xml As String In xMLName
Using reader As XmlReader = XmlReader.Create(_xml)
While reader.Read()
Select Case reader.NodeType
Case XmlNodeType.Element
Select Case reader.Name
Case "PatientIdentifier"
ID = reader.ReadElementContentAsString()
If ID = "" Then
Exit While
End If
'Case "FacilityName" use the textbox for facility name and id
FacName = "Barau Dikko Specialist Hospital" 'reader.ReadElementContentAsString()
'Case "IDNumber"
FacID = "aQTk0pRk6eY" ' reader.ReadElementContentAsString()
Case "PatientDateOfBirth"
DOB = reader.ReadElementContentAsString()
Case "PatientSexCode"
Sex = reader.ReadElementContentAsString()
Case = "PatientAge"
Age = reader.ReadElementContentAsString()
If Convert.ToInt16(Age) >= 14 Then
AgeA = Convert.ToInt32(Age)
Else
AgeP = Convert.ToInt32(Age)
End If
Case = "ARTStartDate"
ArtStartDate = reader.ReadElementContentAsString()
Case = "VisitDate"
ArtVisit = reader.ReadElementContentAsString()
Case = "NextAppointmentDate"
Nxt_App_Date = reader.ReadElementContentAsString()
Case = "CodeDescTxt"
Drug_Reg = reader.ReadElementContentAsString()
Case = "ResultedTestDate"
VL_Date = reader.ReadElementContentAsString()
Case = "Code"
TestCode = reader.ReadElementContentAsString()
Case = "Value1"
VL_Result = reader.ReadElementContentAsString()
End Select
If ID <> "" And DOB <> "" And Sex <> "" And Age <> "" Then
If TestCode = "80" Then
FC.Process_Insert(ID, FacID, FacName, Sex, DOB, AgeA, AgeP, ArtStartDate, ArtVisit, Nxt_App_Date, Drug_Reg, "", "", VL_Result, VL_Date)
Else
FC.Process_Insert1(ID, FacID, FacName, Sex, DOB, AgeA, AgeP, ArtStartDate, ArtVisit, Nxt_App_Date, Drug_Reg, "", "")
End If
End If
End Select
End While
End Using
Next

This is one of the Patient Xml file i try to read

xml version="1.0" encoding="utf-8"?>
<Container xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<MessageHeader>
<MessageStatusCode>INITIALMessageStatusCode>
<MessageCreationDateTime>2018-07-24T14:06:44.5685477MessageCreationDateTime>
<MessageSchemaVersion>1.2MessageSchemaVersion>
<MessageUniqueID> MessageUniqueID>
<MessageSendingOrganization>
<FacilityName> FacilityName>
<FacilityID>CIHPFacilityID>
<FacilityTypeCode>IPFacilityTypeCode>
MessageSendingOrganization>
MessageHeader>
<IndividualReport>
<PatientDemographics>
<PatientIdentifier>5553PatientIdentifier>
<TreatmentFacility>
<FacilityName> FacilityName>
<FacilityID> FacilityID>
<FacilityTypeCode>FACFacilityTypeCode>
TreatmentFacility>
<OtherPatientIdentifiers>
<Identifier>
<IDNumber />
<IDTypeCode>MRIDTypeCode>
Identifier>
OtherPatientIdentifiers>
<PatientDateOfBirth>1982-06-02PatientDateOfBirth>
<PatientSexCode>FPatientSexCode>
<PatientPrimaryLanguageCode>ENGPatientPrimaryLanguageCode>
<PatientEducationLevelCode>7PatientEducationLevelCode>
<PatientMaritalStatusCode>MPatientMaritalStatusCode>
<StateOfNigeriaOriginCode>KadunaStateOfNigeriaOriginCode>
<PatientNotes>
<Note>N/ANote>
PatientNotes>
PatientDemographics>
<Condition>
<ConditionCode>86406008ConditionCode>
<ProgramArea>
<ProgramAreaCode>HIVProgramAreaCode>
ProgramArea>
<PatientAddress>
<AddressTypeCode>HAddressTypeCode>
<WardVillage>U/SHAANUWardVillage>
<Town />
<LGACode />
<StateCode>23StateCode>
<CountryCode>NGACountryCode>
<OtherAddressInformation>N01 BADARAWA RD U/SHANUOtherAddressInformation>
PatientAddress>
<CommonQuestions>
<HospitalNumber />
<DiagnosisFacility>
<FacilityName> FacilityName>
<FacilityID> FacilityID>
<FacilityTypeCode>FACFacilityTypeCode>
DiagnosisFacility>
<DateOfFirstReport>2009-07-09DateOfFirstReport>
<PatientAge>36PatientAge>
CommonQuestions>
<ConditionSpecificQuestions>
<HIVQuestions>
<CareEntryPoint>9CareEntryPoint>
<ARTStartDate>2009-07-09ARTStartDate>
<EnrolledInHIVCareDate>2009-07-09EnrolledInHIVCareDate>
HIVQuestions>
ConditionSpecificQuestions>
<Encounters>
<HIVEncounter>
<VisitID>148011VisitID>
<VisitDate>2010-08-05VisitDate>
<DurationOnArt>56DurationOnArt>
<Weight>49Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2010-09-30NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148012VisitID>
<VisitDate>2010-09-30VisitDate>
<DurationOnArt>84DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2010-12-23NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148014VisitID>
<VisitDate>2010-12-23VisitDate>
<DurationOnArt>84DurationOnArt>
<Weight>48Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2011-03-17NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148015VisitID>
<VisitDate>2011-03-17VisitDate>
<DurationOnArt>63DurationOnArt>
<Weight>48Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2011-05-19NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148017VisitID>
<VisitDate>2011-05-19VisitDate>
<DurationOnArt>14DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2011-06-02NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148019VisitID>
<VisitDate>2011-06-02VisitDate>
<DurationOnArt>89DurationOnArt>
<Weight>49Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2011-08-30NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148021VisitID>
<VisitDate>2011-09-29VisitDate>
<DurationOnArt>21DurationOnArt>
<Weight>48Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2011-10-20NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148023VisitID>
<VisitDate>2011-10-20VisitDate>
<DurationOnArt>90DurationOnArt>
<Weight>49Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-01-19NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148024VisitID>
<VisitDate>2012-01-19VisitDate>
<DurationOnArt>27DurationOnArt>
<Weight>54Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-02-15NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148025VisitID>
<VisitDate>2012-04-11VisitDate>
<DurationOnArt>63DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-06-13NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148026VisitID>
<VisitDate>2012-06-13VisitDate>
<DurationOnArt>28DurationOnArt>
<Weight>54Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-07-11NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148028VisitID>
<VisitDate>2012-07-11VisitDate>
<DurationOnArt>61DurationOnArt>
<Weight>55Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-09-10NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148029VisitID>
<VisitDate>2012-09-10VisitDate>
<DurationOnArt>84DurationOnArt>
<Weight>51Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-12-03NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148030VisitID>
<VisitDate>2013-01-15VisitDate>
<DurationOnArt>90DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2012-02-12NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148032VisitID>
<VisitDate>2013-02-27VisitDate>
<DurationOnArt>13DurationOnArt>
<Weight>54Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2013-03-12NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148033VisitID>
<VisitDate>2013-03-12VisitDate>
<DurationOnArt>28DurationOnArt>
<Weight>55Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2013-04-09NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148034VisitID>
<VisitDate>2013-04-09VisitDate>
<DurationOnArt>28DurationOnArt>
<Weight>55Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2013-05-07NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148035VisitID>
<VisitDate>2013-06-04VisitDate>
<DurationOnArt>28DurationOnArt>
<Weight>50Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2013-07-02NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148037VisitID>
<VisitDate>2013-08-06VisitDate>
<DurationOnArt>36DurationOnArt>
<Weight>50Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2013-09-11NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148038VisitID>
<VisitDate>2018-04-30VisitDate>
<DurationOnArt>90DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2018-07-30NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148039VisitID>
<VisitDate>2018-02-26VisitDate>
<DurationOnArt>63DurationOnArt>
<Weight>60Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2018-04-30NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148040VisitID>
<VisitDate>2017-12-18VisitDate>
<DurationOnArt>70DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2018-02-26NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148041VisitID>
<VisitDate>2017-08-21VisitDate>
<DurationOnArt>56DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2017-10-16NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148042VisitID>
<VisitDate>2017-06-12VisitDate>
<DurationOnArt>70DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2017-08-21NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148043VisitID>
<VisitDate>2017-05-27VisitDate>
<DurationOnArt>16DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2017-06-12NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148044VisitID>
<VisitDate>2017-11-22VisitDate>
<DurationOnArt>39DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2017-12-31NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148045VisitID>
<VisitDate>2016-09-20VisitDate>
<DurationOnArt>69DurationOnArt>
<Weight>52Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2016-11-28NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148046VisitID>
<VisitDate>2016-05-03VisitDate>
<DurationOnArt>70DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2016-07-12NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148047VisitID>
<VisitDate>2016-05-03VisitDate>
<DurationOnArt>70DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2016-07-12NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148048VisitID>
<VisitDate>2016-02-21VisitDate>
<DurationOnArt>72DurationOnArt>
<Weight>57Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2016-05-03NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148049VisitID>
<VisitDate>2015-12-08VisitDate>
<DurationOnArt>77DurationOnArt>
<Weight>56Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2016-02-23NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148050VisitID>
<VisitDate>2015-10-13VisitDate>
<DurationOnArt>56DurationOnArt>
<Weight>56Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2015-12-08NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148051VisitID>
<VisitDate>2015-08-04VisitDate>
<DurationOnArt>70DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2015-10-13NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148052VisitID>
<VisitDate>2014-09-02VisitDate>
<DurationOnArt>70DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2014-11-11NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148053VisitID>
<VisitDate>2014-07-15VisitDate>
<DurationOnArt>49DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2014-09-02NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148054VisitID>
<VisitDate>2014-03-26VisitDate>
<DurationOnArt>55DurationOnArt>
<Weight>50Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2014-05-20NextAppointmentDate>
HIVEncounter>
<HIVEncounter>
<VisitID>148055VisitID>
<VisitDate>2014-01-29VisitDate>
<DurationOnArt>56DurationOnArt>
<Weight>0Weight>
<FunctionalStatus>WFunctionalStatus>
<WHOClinicalStage>1WHOClinicalStage>
<TBStatus>1TBStatus>
<ARVDrugRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
ARVDrugRegimen>
<NextAppointmentDate>2014-03-26NextAppointmentDate>
HIVEncounter>
Encounters>
<Regimen>
<VisitID>148011VisitID>
<VisitDate>2010-08-05VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>56PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2010-08-05PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148012VisitID>
<VisitDate>2010-09-30VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>84PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2010-09-30PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148014VisitID>
<VisitDate>2010-12-23VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>84PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2010-12-23PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148015VisitID>
<VisitDate>2011-03-17VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>63PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2011-03-17PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148017VisitID>
<VisitDate>2011-05-19VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>14PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2011-05-19PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148019VisitID>
<VisitDate>2011-06-02VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>89PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2011-06-02PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148021VisitID>
<VisitDate>2011-09-29VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>21PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2011-09-29PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148023VisitID>
<VisitDate>2011-10-20VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>90PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2011-10-20PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148024VisitID>
<VisitDate>2012-01-19VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>27PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2012-01-19PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148025VisitID>
<VisitDate>2012-04-11VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>63PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2012-04-11PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148026VisitID>
<VisitDate>2012-06-13VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>28PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2012-06-13PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148028VisitID>
<VisitDate>2012-07-11VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>61PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2012-07-11PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148029VisitID>
<VisitDate>2012-09-10VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>84PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2012-09-10PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148030VisitID>
<VisitDate>2013-01-15VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>90PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2013-01-15PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148032VisitID>
<VisitDate>2013-02-27VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>13PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2013-02-27PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148033VisitID>
<VisitDate>2013-03-12VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>28PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2013-03-12PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148034VisitID>
<VisitDate>2013-04-09VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>28PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2013-04-09PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148035VisitID>
<VisitDate>2013-06-04VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>28PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2013-06-04PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148037VisitID>
<VisitDate>2013-08-06VisitDate>
<PrescribedRegimen>
<Code>2dCode>
<CodeDescTxt>ABC/DDI/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>36PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2013-08-06PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148038VisitID>
<VisitDate>2018-04-30VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>90PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2018-04-30PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148039VisitID>
<VisitDate>2018-02-26VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>63PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2018-02-26PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148040VisitID>
<VisitDate>2017-12-18VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>70PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2017-12-18PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148041VisitID>
<VisitDate>2017-08-21VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>56PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2017-08-21PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148042VisitID>
<VisitDate>2017-06-12VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>70PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2017-06-12PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148043VisitID>
<VisitDate>2017-05-27VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>16PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2017-05-27PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148044VisitID>
<VisitDate>2017-11-22VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>39PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2017-11-22PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148045VisitID>
<VisitDate>2016-09-20VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>69PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2016-09-20PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148046VisitID>
<VisitDate>2016-05-03VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>70PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2016-05-03PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148047VisitID>
<VisitDate>2016-05-03VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>70PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2016-05-03PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148048VisitID>
<VisitDate>2016-02-21VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>72PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2016-02-21PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148049VisitID>
<VisitDate>2015-12-08VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>77PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2015-12-08PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148050VisitID>
<VisitDate>2015-10-13VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>56PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2015-10-13PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148051VisitID>
<VisitDate>2015-08-04VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>70PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2015-08-04PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148052VisitID>
<VisitDate>2014-09-02VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>70PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2014-09-02PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148053VisitID>
<VisitDate>2014-07-15VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>49PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2014-07-15PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148054VisitID>
<VisitDate>2014-03-26VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>55PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2014-03-26PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
<Regimen>
<VisitID>148055VisitID>
<VisitDate>2014-01-29VisitDate>
<PrescribedRegimen>
<Code>2bCode>
<CodeDescTxt>ABC/FTC/LPVrCodeDescTxt>
PrescribedRegimen>
<PrescribedRegimenTypeCode>ARTPrescribedRegimenTypeCode>
<PrescribedRegimenDuration>56PrescribedRegimenDuration>
<PrescribedRegimenDispensedDate>2014-01-29PrescribedRegimenDispensedDate>
<DateRegimenStarted>2009-07-09DateRegimenStarted>
Regimen>
Condition>
IndividualReport>
Container>

please help me to modify my code above to read this xml.

Thank you all

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jefferson S. Motta8y ago
your xsd:
xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema" attributeFormDefault="unqualified" elementFormDefault="qualified">
    <xsd:element name="Container">
        <xsd:complexType>
            <xsd:sequence>
                <xsd:element name="MessageHeader">
                    <xsd:complexType>
                        <xsd:sequence>
                            <xsd:element name="MessageStatusCode" type="xsd:string" />
                            <xsd:element name="MessageCreationDateTime" type="xsd:dateTime" />
                            <xsd:element name="MessageSchemaVersion" type="xsd:decimal" />
                            <xsd:element name="MessageUniqueID" type="xsd:string" />
                            <xsd:element name="MessageSendingOrganization">
                                <xsd:complexType>
                                    <xsd:sequence>
                                        <xsd:element name="FacilityName" type="xsd:string" />
                                        <xsd:element name="FacilityID" type="xsd:string" />
                                        <xsd:element name="FacilityTypeCode" type="xsd:string" />
                                    xsd:sequence>
                                xsd:complexType>
                            xsd:element>
                        xsd:sequence>
                    xsd:complexType>
                xsd:element>
                <xsd:element name="IndividualReport">
                    <xsd:complexType>
                        <xsd:sequence>
                            <xsd:element name="PatientDemographics">
                                <xsd:complexType>
                                    <xsd:sequence>
                                        <xsd:element name="PatientIdentifier" type="xsd:unsignedShort" />
                                        <xsd:element name="TreatmentFacility">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="FacilityName" type="xsd:string" />
                                                    <xsd:element name="FacilityID" type="xsd:string" />
                                                    <xsd:element name="FacilityTypeCode" type="xsd:string" />
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element name="OtherPatientIdentifiers">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="Identifier">
                                                        <xsd:complexType>
                                                            <xsd:sequence>
                                                                <xsd:element name="IDNumber" />
                                                                <xsd:element name="IDTypeCode" type="xsd:string" />
                                                            xsd:sequence>
                                                        xsd:complexType>
                                                    xsd:element>
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element name="PatientDateOfBirth" type="xsd:date" />
                                        <xsd:element name="PatientSexCode" type="xsd:string" />
                                        <xsd:element name="PatientPrimaryLanguageCode" type="xsd:string" />
                                        <xsd:element name="PatientEducationLevelCode" type="xsd:unsignedByte" />
                                        <xsd:element name="PatientMaritalStatusCode" type="xsd:string" />
                                        <xsd:element name="StateOfNigeriaOriginCode" type="xsd:string" />
                                        <xsd:element name="PatientNotes">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="Note" type="xsd:string" />
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                    xsd:sequence>
                                xsd:complexType>
                            xsd:element>
                            <xsd:element name="Condition">
                                <xsd:complexType>
                                    <xsd:sequence>
                                        <xsd:element name="ConditionCode" type="xsd:unsignedInt" />
                                        <xsd:element name="ProgramArea">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="ProgramAreaCode" type="xsd:string" />
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element name="PatientAddress">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="AddressTypeCode" type="xsd:string" />
                                                    <xsd:element name="WardVillage" type="xsd:string" />
                                                    <xsd:element name="Town" />
                                                    <xsd:element name="LGACode" />
                                                    <xsd:element name="StateCode" type="xsd:unsignedByte" />
                                                    <xsd:element name="CountryCode" type="xsd:string" />
                                                    <xsd:element name="OtherAddressInformation" type="xsd:string" />
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element name="CommonQuestions">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="HospitalNumber" />
                                                    <xsd:element name="DiagnosisFacility">
                                                        <xsd:complexType>
                                                            <xsd:sequence>
                                                                <xsd:element name="FacilityName" type="xsd:string" />
                                                                <xsd:element name="FacilityID" type="xsd:string" />
                                                                <xsd:element name="FacilityTypeCode" type="xsd:string" />
                                                            xsd:sequence>
                                                        xsd:complexType>
                                                    xsd:element>
                                                    <xsd:element name="DateOfFirstReport" type="xsd:date" />
                                                    <xsd:element name="PatientAge" type="xsd:unsignedByte" />
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element name="ConditionSpecificQuestions">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="HIVQuestions">
                                                        <xsd:complexType>
                                                            <xsd:sequence>
                                                                <xsd:element name="CareEntryPoint" type="xsd:unsignedByte" />
                                                                <xsd:element name="ARTStartDate" type="xsd:date" />
                                                                <xsd:element name="EnrolledInHIVCareDate" type="xsd:date" />
                                                            xsd:sequence>
                                                        xsd:complexType>
                                                    xsd:element>
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element name="Encounters">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element maxOccurs="unbounded" name="HIVEncounter">
                                                        <xsd:complexType>
                                                            <xsd:sequence>
                                                                <xsd:element name="VisitID" type="xsd:unsignedInt" />
                                                                <xsd:element name="VisitDate" type="xsd:date" />
                                                                <xsd:element name="DurationOnArt" type="xsd:unsignedByte" />
                                                                <xsd:element name="Weight" type="xsd:unsignedByte" />
                                                                <xsd:element name="FunctionalStatus" type="xsd:string" />
                                                                <xsd:element name="WHOClinicalStage" type="xsd:unsignedByte" />
                                                                <xsd:element name="TBStatus" type="xsd:unsignedByte" />
                                                                <xsd:element name="ARVDrugRegimen">
                                                                    <xsd:complexType>
                                                                        <xsd:sequence>
                                                                            <xsd:element name="Code" type="xsd:string" />
                                                                            <xsd:element name="CodeDescTxt" type="xsd:string" />
                                                                        xsd:sequence>
                                                                    xsd:complexType>
                                                                xsd:element>
                                                                <xsd:element name="NextAppointmentDate" type="xsd:date" />
                                                            xsd:sequence>
                                                        xsd:complexType>
                                                    xsd:element>
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                        <xsd:element maxOccurs="unbounded" name="Regimen">
                                            <xsd:complexType>
                                                <xsd:sequence>
                                                    <xsd:element name="VisitID" type="xsd:unsignedInt" />
                                                    <xsd:element name="VisitDate" type="xsd:date" />
                                                    <xsd:element name="PrescribedRegimen">
                                                        <xsd:complexType>
                                                            <xsd:sequence>
                                                                <xsd:element name="Code" type="xsd:string" />
                                                                <xsd:element name="CodeDescTxt" type="xsd:string" />
                                                            xsd:sequence>
                                                        xsd:complexType>
                                                    xsd:element>
                                                    <xsd:element name="PrescribedRegimenTypeCode" type="xsd:string" />
                                                    <xsd:element name="PrescribedRegimenDuration" type="xsd:unsignedByte" />
                                                    <xsd:element name="PrescribedRegimenDispensedDate" type="xsd:date" />
                                                    <xsd:element name="DateRegimenStarted" type="xsd:date" />
                                                xsd:sequence>
                                            xsd:complexType>
                                        xsd:element>
                                    xsd:sequence>
                                xsd:complexType>
                            xsd:element>
                        xsd:sequence>
                    xsd:complexType>
                xsd:element>
            xsd:sequence>
        xsd:complexType>
    xsd:element>
xs:schema>
https://social.msdn.microsoft.com/Forums/vstudio/en-US/976a2831-8d5b-4fba-8d21-025067697075/reading-xml-files-based-on-xsd-schema?forum=csharpgeneral

https://msdn.microsoft.com/en-us/library/ms162371.aspx

I hope bring some light!