<?xml version="1.0" encoding="utf-8"?><Database Name="EMR_SS_SSB" Class="LINQ_EMRDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Table Name="dbo.EMR_Complaint" Member="EMR_Complaints">
    <Type Name="EMR_Complaint">
      <Column Name="ComplaintID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ComplaintOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ComplaintDescription" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PhysicalExam" Member="EMR_PhysicalExams">
    <Type Name="EMR_PhysicalExam">
      <Column Name="PhysicalExamID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExamOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ExamDescription" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_DocComment" Member="EMR_DocComments">
    <Type Name="EMR_DocComment">
      <Column Name="CommentID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CommentOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Commnet" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ProgressNote" Member="EMR_ProgressNotes">
    <Type Name="EMR_ProgressNote">
      <Column Name="ProgressID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProgressOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Progress" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Patient_ID" Member="EMR_Patient_IDs">
    <Type Name="EMR_Patient_ID">
      <Column Name="PatientIdentifierID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IDNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IDtype" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ActiveFrom" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ActiveTo" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Patient_IDView" Member="EMR_Patient_IDViews">
    <Type Name="EMR_Patient_IDView">
      <Column Name="PatientIdentifierID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IDNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IDtype" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ActiveFrom" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ActiveTo" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Patient_OtherName" Member="EMR_Patient_OtherNames">
    <Type Name="EMR_Patient_OtherName">
      <Column Name="PatientOtherNameID" Type="System.String" DbType="VarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Title" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AliasType" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FirstName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="MiddleName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="LastName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Patient_OtherNameView" Member="EMR_Patient_OtherNameViews">
    <Type Name="EMR_Patient_OtherNameView">
      <Column Name="PatientOtherNameID" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AliasType" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FirstName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="MiddleName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="LastName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Title" Type="System.String" DbType="VarChar(10)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FamilyHistory" Member="EMR_FamilyHistories">
    <Type Name="EMR_FamilyHistory">
      <Column Name="FamilyHistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FamilyHistory" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_SocialHistory" Member="EMR_SocialHistories">
    <Type Name="EMR_SocialHistory">
      <Column Name="SocialHistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="SocialHistory" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Diagnosis" Member="EMR_Diagnosis">
    <Type Name="EMR_Diagnosi">
      <Column Name="DiagnosisID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="DiagnosisNote" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PastMedicalHistory" Member="EMR_PastMedicalHistories">
    <Type Name="EMR_PastMedicalHistory">
      <Column Name="MedicalHistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="MedicalHistory" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ComplaintView" Member="EMR_ComplaintViews">
    <Type Name="EMR_ComplaintView">
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ComplaintOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ComplaintDescription" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ComplaintID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PhysicalExamView" Member="EMR_PhysicalExamViews">
    <Type Name="EMR_PhysicalExamView">
      <Column Name="PhysicalExamID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExamOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ExamDescription" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_DocCommentView" Member="EMR_DocCommentViews">
    <Type Name="EMR_DocCommentView">
      <Column Name="CommentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CommentOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Commnet" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ProgressNoteView" Member="EMR_ProgressNoteViews">
    <Type Name="EMR_ProgressNoteView">
      <Column Name="ProgressID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProgressOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Progress" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FamilyHistoryView" Member="EMR_FamilyHistoryViews">
    <Type Name="EMR_FamilyHistoryView">
      <Column Name="FamilyHistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FamilyHistory" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_SocialHistoryView" Member="EMR_SocialHistoryViews">
    <Type Name="EMR_SocialHistoryView">
      <Column Name="SocialHistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="SocialHistory" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_DiagnosisView" Member="EMR_DiagnosisViews">
    <Type Name="EMR_DiagnosisView">
      <Column Name="DiagnosisID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="DiagnosisNote" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PastMedicalHistoryView" Member="EMR_PastMedicalHistoryViews">
    <Type Name="EMR_PastMedicalHistoryView">
      <Column Name="MedicalHistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="MedicalHistory" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Allergies" Member="EMR_Allergies">
    <Type Name="EMR_Allergy">
      <Column Name="AllegriesID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AllergyTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Allergies" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_AllergyView" Member="EMR_AllergyViews">
    <Type Name="EMR_AllergyView">
      <Column Name="AllegriesID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="NoteOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Allergies" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AllergyTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AllergyTypeName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Recommendation" Member="EMR_Recommendations">
    <Type Name="EMR_Recommendation">
      <Column Name="RecommendationID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ParentType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ParentRecordID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="SecondaryType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SecondaryItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemUnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="[Level]" Member="Level" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RecommendationInfo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_RecommendationView" Member="EMR_RecommendationViews">
    <Type Name="EMR_RecommendationView">
      <Column Name="RecommendationID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ParentType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ParentRecordID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="SecondaryType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SecondaryItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="[Level]" Member="Level" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RecommendationInfo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AllergyTypeName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="itemGroupType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemUnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_LetterTypeView" Member="EMR_LetterTypeViews">
    <Type Name="EMR_LetterTypeView">
      <Column Name="LetterTypeID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LetterTypeName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="LetterTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="LetterBody" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_LetterType" Member="EMR_LetterTypes">
    <Type Name="EMR_LetterType">
      <Column Name="LetterTypeID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="LetterTypeName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="LetterTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="LetterBody" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_GenericView" Member="EMR_GenericViews">
    <Type Name="EMR_GenericView">
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Generic" Member="EMR_Generics">
    <Type Name="EMR_Generic">
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Country" Member="EMR_Countries">
    <Type Name="EMR_Country">
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CountryCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_CountryView" Member="EMR_CountryViews">
    <Type Name="EMR_CountryView">
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CountryCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationSpeciality" Member="EMR_StationSpecialities">
    <Type Name="EMR_StationSpeciality">
      <Column Name="StationSpecialityID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationUser" Member="EMR_StationUsers">
    <Type Name="EMR_StationUser">
      <Column Name="StationUserID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="UserID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationDoctor" Member="EMR_StationDoctors">
    <Type Name="EMR_StationDoctor">
      <Column Name="StationDoctorID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationSpecialityView" Member="EMR_StationSpecialityViews">
    <Type Name="EMR_StationSpecialityView">
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationSpecialityID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityGroupID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="SpecialityGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ShowSeq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationItem" Member="EMR_StationItems">
    <Type Name="EMR_StationItem">
      <Column Name="StationItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationItemView" Member="EMR_StationItemViews">
    <Type Name="EMR_StationItemView">
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_EnrolledMonthlyPayment" Member="EMR_EnrolledMonthlyPayments">
    <Type Name="EMR_EnrolledMonthlyPayment">
      <Column Name="MonthlyPaymentID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="EnrolledPaymentID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Month" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="EnrolledCount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="EnrolledDiff" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_EnrolledMonthlyPaymentView" Member="EMR_EnrolledMonthlyPaymentViews">
    <Type Name="EMR_EnrolledMonthlyPaymentView">
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="EnrolledPaymentID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Month" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="EnrolledCount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="EnrolledDiff" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="EnrolledPaymentNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EnrolledPerson" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="BudgetYear" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="SFPercentBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TFPercentBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TotalBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FinalPayment" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="ClinicID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BudgetPerPerson" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="MonthlyPaymentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_VitalSign" Member="EMR_VitalSigns">
    <Type Name="EMR_VitalSign">
      <Column Name="VitalSignID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Weight" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BMI" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BSA" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Temperature" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Pulse" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Respiratory" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Systolic" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Diastolic" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Waist" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Oxygen" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Pain" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VitalSignOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ShortIndex" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MeanArterialPressure" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PulsePressure" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TypeID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Height_ft" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height_inches" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationLocation" Member="EMR_StationLocations">
    <Type Name="EMR_StationLocation">
      <Column Name="StationLocationID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IsStockInOutStore" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_DosageView" Member="EMR_DosageViews">
    <Type Name="EMR_DosageView">
      <Column Name="DosageID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="DosageCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DosageName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Count" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Dosage" Member="EMR_Dosages">
    <Type Name="EMR_Dosage">
      <Column Name="DosageID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="DosageCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DosageName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Count" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ClaimRequestItem" Member="EMR_ClaimRequestItems">
    <Type Name="EMR_ClaimRequestItem">
      <Column Name="ClaimRequestItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ClaimRequestID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_EnrolledPayment" Member="EMR_EnrolledPayments">
    <Type Name="EMR_EnrolledPayment">
      <Column Name="EnrolledPaymentID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="EnrolledPaymentNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EnrolledPerson" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="BudgetYear" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="BudgetPerPerson" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="SFPercentBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TFPercentBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TotalBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FinalPayment" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TotalMonthlyBalance" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FromDate_First" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_First" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_First" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_First" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Second" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Second" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Second" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Second" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Third" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Third" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Third" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Third" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Fourth" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Fourth" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Fourth" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Fourth" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Last" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Last" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Last" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Last" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_EnrolledPaymentView" Member="EMR_EnrolledPaymentViews">
    <Type Name="EMR_EnrolledPaymentView">
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="EnrolledPaymentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="EnrolledPaymentNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EnrolledPerson" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="BudgetYear" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="SFPercentBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TFPercentBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="TotalBudget" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FinalPayment" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BudgetPerPerson" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="TotalMonthlyBalance" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FromDate_First" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_First" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_First" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_First" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Second" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Second" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Second" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Third" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Third" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Second" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Third" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Third" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Fourth" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Fourth" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Fourth" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Fourth" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate_Last" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate_Last" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status_Last" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Code_Last" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_MedicalRecordHistory" Member="EMR_MedicalRecordHistories">
    <Type Name="EMR_MedicalRecordHistory">
      <Column Name="HistoryID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="HistoryDescription" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
      <Column Name="HistoryType" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PatientDetail" Member="EMR_PatientDetails">
    <Type Name="EMR_PatientDetail">
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="MRDType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsVIP" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="VIPPatientType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsAnonymous" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Tilte" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MiddleName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LastName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NameMyanmar" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Guardian" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DateOfBirth" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="IsDOBApproximate" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="BuddhistDate" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BloodGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Nationality" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PreferredLanguage" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InterpreterRequired" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Occupation" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="PatientType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Religion" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Building" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="City" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="District" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DistrictEdit" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="State" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Country" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ZipCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ResidentailPhone" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceivedHostpitalNews" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NationalID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AciveFrom" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ActiveTo" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="RegistrationOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="RegisterBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RegisterationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="InsuranceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EstablishmentAddress" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EmployerPhoneNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IDType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsRetire" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PatientDetailView" Member="EMR_PatientDetailViews">
    <Type Name="EMR_PatientDetailView">
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MRDType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MiddleName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LastName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Guardian" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NameMyanmar" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DateOfBirth" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="IsDOBApproximate" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="BuddhistDate" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="IsVIP" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="VIPPatientType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsAnonymous" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Tilte" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BloodGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Nationality" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InterpreterRequired" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Occupation" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="PatientType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Religion" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Building" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="District" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DistrictEdit" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="State" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Country" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ResidentailPhone" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NationalID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AciveFrom" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ActiveTo" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PreferredLanguage" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceivedHostpitalNews" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ZipCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="City" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RegistrationOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="RegisterBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RegisterationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UserName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="InsuranceCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="InsuranceName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="InsuranceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EstablishmentAddress" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EmployerPhoneNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="IDType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NationalityName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="NationalityCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsRetire" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Monthly_Enroll" Member="EMR_Monthly_Enrolls">
    <Type Name="EMR_Monthly_Enroll">
      <Column Name="Monthly_Enroll_ID" Type="System.String" DbType="NVarChar(100) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Month_Name" Type="System.String" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="From_Date" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="To_Date" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="ClinicID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ClinicName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="EESSN" Type="System.String" DbType="NVarChar(100) NOT NULL" CanBeNull="false" />
      <Column Name="EEName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ERSSN" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ERName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_MMU_ClaimRequestItem" Member="EMR_MMU_ClaimRequestItems">
    <Type Name="EMR_MMU_ClaimRequestItem">
      <Column Name="MMU_ClaimRequestItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="MMU_ClaimRequestID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OPDItem" Member="EMR_FeeForService_OPDItems">
    <Type Name="EMR_FeeForService_OPDItem">
      <Column Name="FeeForServiceItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ClaimRequest" Member="EMR_ClaimRequests">
    <Type Name="EMR_ClaimRequest">
      <Column Name="ClaimRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClaimRequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ClaimRequestView" Member="EMR_ClaimRequestViews">
    <Type Name="EMR_ClaimRequestView">
      <Column Name="ClaimRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClaimRequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OPDView" Member="EMR_FeeForService_OPDViews">
    <Type Name="EMR_FeeForService_OPDView">
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OPD" Member="EMR_FeeForService_OPDs">
    <Type Name="EMR_FeeForService_OPD">
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_MMU_ClaimRequest" Member="EMR_MMU_ClaimRequests">
    <Type Name="EMR_MMU_ClaimRequest">
      <Column Name="MMU_ClaimRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="MMU_ClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_MMU_ClaimRequestView" Member="EMR_MMU_ClaimRequestViews">
    <Type Name="EMR_MMU_ClaimRequestView">
      <Column Name="MMU_ClaimRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MMU_ClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForServiceDrugClaimView" Member="EMR_FeeForServiceDrugClaimViews">
    <Type Name="EMR_FeeForServiceDrugClaimView">
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForServiceDrugClaim" Member="EMR_FeeForServiceDrugClaims">
    <Type Name="EMR_FeeForServiceDrugClaim">
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForServiceItemDrugClaim" Member="EMR_FeeForServiceItemDrugClaims">
    <Type Name="EMR_FeeForServiceItemDrugClaim">
      <Column Name="FeeForServiceItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ClaimRequestItemView" Member="EMR_ClaimRequestItemViews">
    <Type Name="EMR_ClaimRequestItemView">
      <Column Name="ClaimRequestItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClaimRequestID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForServiceDrugClaimItemView" Member="EMR_FeeForServiceDrugClaimItemViews">
    <Type Name="EMR_FeeForServiceDrugClaimItemView">
      <Column Name="FeeForServiceItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_MMU_ClaimRequestItemView" Member="EMR_MMU_ClaimRequestItemViews">
    <Type Name="EMR_MMU_ClaimRequestItemView">
      <Column Name="MMU_ClaimRequestItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MMU_ClaimRequestID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ConsultationFee" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OPDItemView" Member="EMR_FeeForService_OPDItemViews">
    <Type Name="EMR_FeeForService_OPDItemView">
      <Column Name="FeeForServiceItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ConsultationFee" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OG_OPD" Member="EMR_FeeForService_OG_OPDs">
    <Type Name="EMR_FeeForService_OG_OPD">
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OG_OPDItem" Member="EMR_FeeForService_OG_OPDItems">
    <Type Name="EMR_FeeForService_OG_OPDItem">
      <Column Name="FeeForServiceItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OG_OPDView" Member="EMR_FeeForService_OG_OPDViews">
    <Type Name="EMR_FeeForService_OG_OPDView">
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_VitalSignView" Member="EMR_VitalSignViews">
    <Type Name="EMR_VitalSignView">
      <Column Name="VitalSignID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Weight" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BMI" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BSA" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Temperature" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Pulse" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Respiratory" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Systolic" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Diastolic" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Waist" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Oxygen" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Pain" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="VisitStatus" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DateOfBirth" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VitalSignOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ShortIndex" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MeanArterialPressure" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PulsePressure" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TypeID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height_ft" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height_inches" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BloodGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationLocationView" Member="EMR_StationLocationViews">
    <Type Name="EMR_StationLocationView">
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationLocationID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LocationType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="TownshipCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="IsStockInOutStore" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="ClinicTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_LabClaimItem" Member="EMR_LabClaimItems">
    <Type Name="EMR_LabClaimItem">
      <Column Name="LabClaimItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="LabClaimID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_IndentClaimRequest" Member="EMR_IndentClaimRequests">
    <Type Name="EMR_IndentClaimRequest">
      <Column Name="IndentClaimRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IndentClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IndentClaimRequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_IndentClaimRequestView" Member="EMR_IndentClaimRequestViews">
    <Type Name="EMR_IndentClaimRequestView">
      <Column Name="IndentClaimRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IndentClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IndentClaimRequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_IndentClaimRequestItemView" Member="EMR_IndentClaimRequestItemViews">
    <Type Name="EMR_IndentClaimRequestItemView">
      <Column Name="IndentClaimRequestItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IndentClaimRequestID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IndentClaimRequestNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Price" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalInQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="StockInNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_IndentClaimRequestItem" Member="EMR_IndentClaimRequestItems">
    <Type Name="EMR_IndentClaimRequestItem">
      <Column Name="IndentClaimRequestItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IndentClaimRequestID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Schedule" Member="EMR_Schedules">
    <Type Name="EMR_Schedule">
      <Column Name="ScheduleID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ScheduleNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ScheduleInfo" Member="EMR_ScheduleInfos">
    <Type Name="EMR_ScheduleInfo">
      <Column Name="ScheduleInfoID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ScheduleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ScheduleInfoNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Day" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StartTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="EndTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Count" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ScheduleView" Member="EMR_ScheduleViews">
    <Type Name="EMR_ScheduleView">
      <Column Name="ScheduleID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ScheduleNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNameEnglish" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ScheduleInfoView" Member="EMR_ScheduleInfoViews">
    <Type Name="EMR_ScheduleInfoView">
      <Column Name="ScheduleInfoID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ScheduleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ScheduleInfoNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Day" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StartTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="EndTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Count" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ScheduleNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNameEnglish" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Appointment" Member="EMR_Appointments">
    <Type Name="EMR_Appointment">
      <Column Name="AppointmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Date" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="AppointmentDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="AppointmentTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ScheduleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ScheduleInfoID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Descritption" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Reminder" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="AppointmentNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="gender" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_AppointmentView" Member="EMR_AppointmentViews">
    <Type Name="EMR_AppointmentView">
      <Column Name="AppointmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Date" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="AppointmentDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="AppointmentTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNameEnglish" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ScheduleInfoID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Descritption" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Reminder" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="AppointmentNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="gender" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ScheduleInfoNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ScheduleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ScheduleNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Visit" Member="EMR_Visits">
    <Type Name="EMR_Visit">
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Sec_SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Ter_SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PrintLeaveLetter" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="VisitRecordStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FollowUpVisitNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ServiceType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsEnroll" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ProcedureType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MigrationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OGVisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_VisitView" Member="EMR_VisitViews">
    <Type Name="EMR_VisitView">
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PreferredLanguage" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NationalID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DateOfBirth" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Building" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="State" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmergencyContact" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EstablishmentAddress" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PrintLeaveLetter" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromLeaveDay" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ToLeaveDay" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IDType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitRecordStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FollowUpVisitNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ServiceType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ClinicTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Sec_SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Ter_SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Sec_SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Sec_SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Sec_SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Ter_SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Ter_SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Ter_SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsEnroll" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ProcedureType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OGVisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_AppConfig" Member="EMR_AppConfigs">
    <Type Name="EMR_AppConfig">
      <Column Name="AppConfigID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="AppConfigNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigSubType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_AppConfigView" Member="EMR_AppConfigViews">
    <Type Name="EMR_AppConfigView">
      <Column Name="AppConfigID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AppConfigNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigSubType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_APPStep" Member="EMR_APPSteps">
    <Type Name="EMR_APPStep">
      <Column Name="ApprovalStepID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="RoleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="State" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="AppConfigID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsEnd" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_APPStepView" Member="EMR_APPStepViews">
    <Type Name="EMR_APPStepView">
      <Column Name="ApprovalStepID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RoleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="State" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="AppConfigID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsEnd" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="AppConfigNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigSubType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ApprovalUserRoleName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_LabClaim" Member="EMR_LabClaims">
    <Type Name="EMR_LabClaim">
      <Column Name="LabClaimID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="LabClaimNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LabClaimOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_LabClaimView" Member="EMR_LabClaimViews">
    <Type Name="EMR_LabClaimView">
      <Column Name="LabClaimID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LabClaimNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AccountHolder" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccountNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ClinicType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LabClaimOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_CapitationItem" Member="EMR_CapitationItems">
    <Type Name="EMR_CapitationItem">
      <Column Name="CapitationItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CapitationItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="CapitationItemUnit" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemPrice" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_CapitationItemView" Member="EMR_CapitationItemViews">
    <Type Name="EMR_CapitationItemView">
      <Column Name="CapitationItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CapitationItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="CapitationItemUnit" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemPrice" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationCapitationItem" Member="EMR_StationCapitationItems">
    <Type Name="EMR_StationCapitationItem">
      <Column Name="StationCapitationItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationCapitationItemView" Member="EMR_StationCapitationItemViews">
    <Type Name="EMR_StationCapitationItemView">
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationCapitationItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="CapitationItemUnit" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapitationItemPrice" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationDoctorView" Member="EMR_StationDoctorViews">
    <Type Name="EMR_StationDoctorView">
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationDoctorID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNameEnglish" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmergencyContact" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Email" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MedicalLicenseNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LicenseExpireDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_LabClaimItemView" Member="EMR_LabClaimItemViews">
    <Type Name="EMR_LabClaimItemView">
      <Column Name="LabClaimItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LabClaimID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LabClaimNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_VisitForAllDataView" Member="EMR_VisitForAllDataViews">
    <Type Name="EMR_VisitForAllDataView">
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PreferredLanguage" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NationalID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DateOfBirth" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OrderID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmergencyContact" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="InvoiceStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromLeaveDay" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ToLeaveDay" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Occupation" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Building" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="State" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="VisitRecordStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PrintLeaveLetter" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="IsRetire" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="FollowUpVisitNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ServiceType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Sec_SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Ter_SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Sec_SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Sec_SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Sec_SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Ter_SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Ter_SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Ter_SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsEnroll" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ProcedureType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="BloodGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_VitalSignForAllDataView" Member="EMR_VitalSignForAllDataViews">
    <Type Name="EMR_VitalSignForAllDataView">
      <Column Name="VitalSignID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Weight" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BMI" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="BSA" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Temperature" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Pulse" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Respiratory" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Systolic" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Diastolic" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Waist" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Oxygen" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Pain" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="VisitStatus" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OrderID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DateOfBirth" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VitalSignOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ShortIndex" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MeanArterialPressure" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PulsePressure" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ContactInfo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmergencyContact" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TypeID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Height_inches" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Height_ft" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="BloodGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Station" Member="EMR_Stations">
    <Type Name="EMR_Station">
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Contract_Start" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Contract_End" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CanPrintLeaveLetter" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PaymentMethod" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EnrolledCount" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationView" Member="EMR_StationViews">
    <Type Name="EMR_StationView">
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Contract_Start" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Contract_End" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="TownshipCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="TownshipName2" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CanPrintLeaveLetter" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ClinicTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PaymentMethod" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EnrolledCount" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SeqNo" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Approval" Member="EMR_Approvals">
    <Type Name="EMR_Approval">
      <Column Name="ApproveID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="APPConfigID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovalStepID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ApprovedRemark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AppUserID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CorrentTask" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_ApprovalView" Member="EMR_ApprovalViews">
    <Type Name="EMR_ApprovalView">
      <Column Name="ApproveID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="APPConfigID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovalStepID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CorrentTask" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="RoleRemark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ApprovedRemark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AppUserID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="AppConfigNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AppConfigSubType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ApprovalUserName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="State" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IsEnd" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="NeedApprovalUser" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="NeedApprovalRemark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="RoleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_StationUserView" Member="EMR_StationUserViews">
    <Type Name="EMR_StationUserView">
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationUserID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="UserID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UserName" Type="System.String" DbType="NVarChar(150) NOT NULL" CanBeNull="false" />
      <Column Name="UserCode" Type="System.String" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="DepartmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ClinicTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RoleName" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="RoleID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProfileURL" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_HSA3View" Member="EMR_HSA3Views">
    <Type Name="EMR_HSA3View">
      <Column Name="LetterID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="DateofAccident" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ClaimantStatement" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="NatureofInjury" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="BriefClinicalFinding" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="ClinicPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ClinicPercentageWord" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ClinicConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HOPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="HOPercentageWord" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="HOConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_DD" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_MM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ApprovedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ApprovedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StatementOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="DisablementTypeClinic" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="DisablementTypeHO" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_HSA3" Member="EMR_HSA3s">
    <Type Name="EMR_HSA3">
      <Column Name="LetterID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="DateofAccident" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ClaimantStatement" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="NatureofInjury" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="BriefClinicalFinding" Type="System.String" DbType="NVarChar(400)" CanBeNull="true" />
      <Column Name="ClinicPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ClinicPercentageWord" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ClinicConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HOPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="HOPercentageWord" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="HOConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StatementOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="DisablementTypeClinic" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="DisablementTypeHO" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PatientLetter" Member="EMR_PatientLetters">
    <Type Name="EMR_PatientLetter">
      <Column Name="LetterID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="VisitiID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Body" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="IsNeedHelper" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="HelperName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="HelperID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LetterOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CauseOfDeath" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="NextOfKin" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Relationship" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReferralStationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CheckDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReturnToWorkDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ExpectedBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="BeforeBirthFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="BeforeBirthToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ActualBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="NoOfBaby" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AfterBirthFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AfterBirthToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AdoptedDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ChildAgeMonth" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ChildAgeDay" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AdoptedFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AdoptedToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="WifeBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PaternityFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PaternityToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HSA1Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SecondCheckHASTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ChkHSA1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="WifeExpBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="WifeNoOfBaby" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="HSA2Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HSA2BirthType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicDisablementPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ClinicConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HODisablementPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="HOConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="NeedApproved" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="ApprovedStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedNeedText" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="isEdited" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Ward_HSA6_ID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsReferalFollowup" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="IsReferalFUType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromExpenseType" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromPatientExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="FromPatientTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromHelperExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="FromHelperTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ProvisionalDiagnosis" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ClinicalFindings" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ToExpenseType" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ToPatientExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ToPatientTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="EndDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="AccidentDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CheckRevisit" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="RevisitDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CheckRevisitNo" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="MigrationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DurationDate" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="APPConfigID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_PatientLetterView" Member="EMR_PatientLetterViews">
    <Type Name="EMR_PatientLetterView">
      <Column Name="LetterID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitiID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Title" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Body" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="LetterTypeName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ApprovedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="HelperID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="IsNeedHelper" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="HelperName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ApprovedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="ApprovedByNRC" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedByAddress" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SpecialityTitleMM" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LetterOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CauseOfDeath" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="NextOfKin" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Relationship" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DOB_YYYY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ReferralStationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReferralStationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CheckDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReturnToWorkDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ExpectedBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="BeforeBirthFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="BeforeBirthToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ActualBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="NoOfBaby" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AfterBirthFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AfterBirthToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AdoptedDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ChildAgeMonth" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ChildAgeDay" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AdoptedFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AdoptedToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="WifeBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PaternityFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PaternityToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="WifeExpBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="WifeNoOfBaby" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="HSA2Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HSA2BirthType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicDisablementPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ClinicConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HODisablementPercentage" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="HOConfirmDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HSA1Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ChkHSA1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityTitle" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="NeedApproved" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="ApprovedStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedNeedText" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="SecondCheckHASTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="isEdited" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Ward_HSA6_ID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LocationType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsReferalFollowup" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="IsReferalFUType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Expr1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromExpenseType" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromPatientExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="FromPatientTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromHelperExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="FromHelperTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ProvisionalDiagnosis" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ClinicalFindings" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ToExpenseType" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ToPatientExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ToPatientTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="EndDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="ClinicTypeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="AccidentDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CheckRevisit" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="RevisitDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CheckRevisitNo" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReferalStationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="MigrationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DurationDate" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="APPConfigID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Capitation_OG_OPD" Member="EMR_Capitation_OG_OPDs">
    <Type Name="EMR_Capitation_OG_OPD">
      <Column Name="CapOGOPDID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CapOGOPDNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapOGOPDClaimOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Capitation_OG_OPDItem" Member="EMR_Capitation_OG_OPDItems">
    <Type Name="EMR_Capitation_OG_OPDItem">
      <Column Name="CapOGOPDItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="CapOGOPDID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Capitation_OG_OPDView" Member="EMR_Capitation_OG_OPDViews">
    <Type Name="EMR_Capitation_OG_OPDView">
      <Column Name="CapOGOPDID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CapOGOPDNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapOGOPDClaimOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ClinicTypeName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="IsSSBclinic" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="StationStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_Capitation_OG_OPDItemView" Member="EMR_Capitation_OG_OPDItemViews">
    <Type Name="EMR_Capitation_OG_OPDItemView">
      <Column Name="CapOGOPDItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CapOGOPDID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CapOGOPDNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ServiceType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProcedureType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.EMR_FeeForService_OG_OPDItemView" Member="EMR_FeeForService_OG_OPDItemViews">
    <Type Name="EMR_FeeForService_OG_OPDItemView">
      <Column Name="FeeForServiceItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="InvoiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ServiceType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ProcedureType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Function Name="dbo.Daily_Patient_Visit" Method="Daily_Patient_Visit">
    <Parameter Name="startdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="enddate" Type="System.DateTime" DbType="Date" />
    <ElementType Name="Daily_Patient_VisitResult">
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="VisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Daily_Patient_Visit_By_Status" Method="Daily_Patient_Visit_By_Status">
    <Parameter Name="startdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="enddate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="VisitStatus" Parameter="visitStatus" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Daily_Patient_Visit_By_StatusResult">
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="VisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Daily_Patient_VisitByStation" Method="Daily_Patient_VisitByStation">
    <Parameter Name="startdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="enddate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="StationID" Parameter="stationID" Type="System.String" DbType="NVarChar(100)" />
    <ElementType Name="Daily_Patient_VisitByStationResult">
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="VisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Daily_Patient_Visit_By_StationDetail" Method="Daily_Patient_Visit_By_StationDetail">
    <Parameter Name="startdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="enddate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="VisitStatus" Parameter="visitStatus" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="ClinicID" Parameter="clinicID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Daily_Patient_Visit_By_StationDetailResult">
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="VisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Daily_Patient_VisitDisease" Method="Daily_Patient_VisitDisease">
    <Parameter Name="startdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="enddate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="VisitStatus" Parameter="visitStatus" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="ClinicID" Parameter="clinicID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Daily_Patient_VisitDiseaseResult">
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="VisitCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.spGetEnrolledList" Method="spGetEnrolledList">
    <Parameter Name="clinicName" Type="System.String" DbType="NVarChar(MAX)" />
    <Parameter Name="fromDate" Type="System.String" DbType="VarChar(50)" />
    <Parameter Name="toDate" Type="System.String" DbType="VarChar(50)" />
    <ElementType Name="spGetEnrolledListResult">
      <Column Name="enrolledpaymentno" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="paymentnoCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="clinicName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="medicalReimbursementType" Type="System.String" DbType="VarChar(12) NOT NULL" CanBeNull="false" />
      <Column Name="requestedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="reimbursementAmount" Type="System.Decimal" DbType="Decimal(23,6)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.spGetEnrolledPaymentByNo" Method="spGetEnrolledPaymentByNo">
    <Parameter Name="enrolledpaymentcode" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="spGetEnrolledPaymentByNoResult">
      <Column Name="enrolledpaymentno" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="clinicCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="clinicName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="budgetYear" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AIP" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="reimbursementRatePerPerson" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="reimbursementpaymentByYear" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="SFPercentreimbursementpayment" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="medicalReimbursementType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_Patient_History" Method="Report_Patient_History">
    <Parameter Name="patientId" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="visit_id" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_Patient_HistoryResult">
      <Column Name="PatientID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Occupation" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="VisitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Daily_InvoiceItem_By_StationDetail" Method="Daily_InvoiceItem_By_StationDetail">
    <Parameter Name="startdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="enddate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="VisitStatus" Parameter="visitStatus" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="ClinicID" Parameter="clinicID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="Type" Parameter="type" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Daily_InvoiceItem_By_StationDetailResult">
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(38,0)" CanBeNull="true" />
      <Column Name="TotalQty" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Total" Type="System.Decimal" DbType="Decimal(38,0)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.spGetfeeForService" Method="spGetfeeForService">
    <Parameter Name="ClaimRequestNo" Parameter="claimRequestNo" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="spGetfeeForServiceResult">
      <Column Name="requestDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HospitalclinicName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="requestAmount" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="toDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="townshipCode" Type="System.String" DbType="VarChar(5) NOT NULL" CanBeNull="false" />
      <Column Name="officeCode" Type="System.String" DbType="VarChar(3) NOT NULL" CanBeNull="false" />
      <Column Name="paymentMethod" Type="System.String" DbType="VarChar(4) NOT NULL" CanBeNull="false" />
      <Column Name="accountHolderName" Type="System.String" DbType="VarChar(3) NOT NULL" CanBeNull="false" />
      <Column Name="representativeName" Type="System.String" DbType="VarChar(3) NOT NULL" CanBeNull="false" />
      <Column Name="accountNumber" Type="System.String" DbType="VarChar(8) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.FeeForServiceOPDDetailList" Method="FeeForServiceOPDDetailList">
    <Parameter Name="ClaimRequestNo" Parameter="claimRequestNo" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="FeeForServiceOPDDetailListResult">
      <Column Name="visitDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="eessn" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="VisitType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="opdvisit" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="EI" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="IM" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="IV" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Infusion" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Antibiotic" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="DiagnosisNote" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="ssbCode" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="remark" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="OPDCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="ECGCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="UCGCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="USGCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="LabCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="XRayCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="OGTTCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="RBSCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="OtherCost" Type="System.Decimal" DbType="Decimal(38,0) NOT NULL" CanBeNull="false" />
      <Column Name="totalCost" Type="System.Decimal" DbType="Decimal(38,0)" CanBeNull="true" />
      <Column Name="drugs" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Lab" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="UrgentCare" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Nebulizer" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="MinorSurgery" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="Dressing" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="hsa1" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="hsa2" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="refHplGov" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="refHplPvt" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="refSpGov" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="refSpPvt" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="medLeave" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.feeForServiceOPDHeader" Method="feeForServiceOPDHeader">
    <Parameter Name="ClaimRequestNo" Parameter="claimRequestNo" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="feeForServiceOPDHeaderResult">
      <Column Name="requestDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FeeForServiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HospitalclinicName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="TownshipName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="requestAmount" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="toDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="townshipCode" Type="System.String" DbType="VarChar(5) NOT NULL" CanBeNull="false" />
      <Column Name="officeCode" Type="System.String" DbType="VarChar(3) NOT NULL" CanBeNull="false" />
      <Column Name="paymentMethod" Type="System.String" DbType="VarChar(4) NOT NULL" CanBeNull="false" />
      <Column Name="accountHolderName" Type="System.String" DbType="VarChar(3) NOT NULL" CanBeNull="false" />
      <Column Name="representativeName" Type="System.String" DbType="VarChar(3) NOT NULL" CanBeNull="false" />
      <Column Name="accountNumber" Type="System.String" DbType="VarChar(8) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.feeForServiceLabList" Method="feeForServiceLabList">
    <Parameter Name="ClaimRequestNo" Parameter="claimRequestNo" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="InvoiceNO" Parameter="invoiceNO" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="feeForServiceLabListResult">
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_SHA_2" Method="Report_SHA_2">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="LetterID" Parameter="letterID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_SHA_2Result">
      <Column Name="StationName" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HSA1Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="fromdate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="todate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HSA1Type1" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName2" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="CheckDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReturnToWorkDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="" Member="Column1" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ExpectedBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="BeforeBirthFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="BeforeBirthToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ActualBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="NoOfBaby" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AfterBirthFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AfterBirthToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="duration" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ChildAgeDay" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ChildAgeMonth" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AdoptedDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AdoptedFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AdoptedToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="duration2" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="PaternityFromDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PaternityToDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="WifeBirthDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="HSA2Type" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="HSA2BirthType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName1" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_SHA_4" Method="Report_SHA_4">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="LetterID" Parameter="letterID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_SHA_4Result">
      <Column Name="StationName" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="date_only" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="time_only" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="am_pm_only" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CauseOfDeath" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="NextOfKin" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Relationship" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(656)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StationName1" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_SHA_5" Method="Report_SHA_5">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="PatientID" Parameter="patientID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_SHA_5Result">
      <Column Name="StationName" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="PerSSINo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MRDType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RegistrationOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MobileNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FatherName" Type="System.String" DbType="NChar(100)" CanBeNull="true" />
      <Column Name="Occupation" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="Establishment" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EstablishmentAddress" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="EmployerPhoneNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="VisitNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="VisitOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Medication" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(551)" CanBeNull="true" />
      <Column Name="Pulse" Type="System.String" DbType="NVarChar(54)" CanBeNull="true" />
      <Column Name="BloodPressure" Type="System.String" DbType="NVarChar(105)" CanBeNull="true" />
      <Column Name="Weight" Type="System.String" DbType="NVarChar(53)" CanBeNull="true" />
      <Column Name="Height" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Temperature" Type="System.String" DbType="NVarChar(53)" CanBeNull="true" />
      <Column Name="heightasfeet" Type="System.String" DbType="NVarChar(106)" CanBeNull="true" />
      <Column Name="BloodGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName1" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="HSADay" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
      <Column Name="HSAType" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
      <Column Name="Complaint" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_SHA_6" Method="Report_SHA_6">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="LetterID" Parameter="letterID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_SHA_6Result">
      <Column Name="StationName" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ProvisionalDiagnosis" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="referralstationname" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="locationname" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="SSINo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_HSA_9" Method="Report_HSA_9">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="LetterID" Parameter="letterID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_HSA_9Result">
      <Column Name="StationName" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ClinicalFindings" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="referralstationname" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="locationname" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="SSINo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="AddressNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Lane" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Road" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="Area" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_KHAYA_1" Method="Report_KHAYA_1">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="LetterID" Parameter="letterID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_KHAYA_1Result">
      <Column Name="StationName" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="LetterNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="DoctorName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="age" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Gender" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PatientName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="date_only" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="time_only" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="am_pm_only" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CauseOfDeath" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="NextOfKin" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Relationship" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(656)" CanBeNull="true" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="HelperName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="HelperID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="StationAddress" Type="System.String" DbType="NVarChar(2000)" CanBeNull="true" />
      <Column Name="isHelperNeed" Type="System.String" DbType="NVarChar(4) NOT NULL" CanBeNull="false" />
      <Column Name="NationalID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedByAddress" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="FromExpenseType" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromPatientExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="FromPatientTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="FromHelperExpense" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="FromHelperTransport" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Report_SHA_1" Method="Report_SHA_1">
    <Parameter Name="UserID" Parameter="userID" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="LetterID" Parameter="letterID" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Report_SHA_1Result">
      <Column Name="StationName" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="PatientName" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="HSA1Type" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="PerSSINo" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="EmployerCodeNo" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="LetterNo" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="SpecialityCodeNo" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="fromdate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="todate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="FatherName" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="DoctorName" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="HSA1Type1" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="StationName1" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="ApprovedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="Gender" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="Establishment" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="CheckDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ReturnToWorkDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="HSAtype" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="duration" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="preletterno" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="Road" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="Area" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="state" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="building" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="mobileno" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="specialitytitle" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="city" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="CheckRevisit" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="CheckRevisitNo" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="AccidentDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="RevisitDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ApprovalRemark" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="ExamDescription" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
      <Column Name="LetterOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="FirstName" Type="System.String" DbType="VarChar(1) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.SP_GETMonthlyVisitSummarybyClinicType" Method="SP_GETMonthlyVisitSummarybyClinicType">
    <Parameter Name="FromDate" Parameter="fromDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="ToDate" Parameter="toDate" Type="System.DateTime" DbType="Date" />
    <ElementType Name="SP_GETMonthlyVisitSummarybyClinicTypeResult">
      <Column Name="RowNumber" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />
      <Column Name="ClinicType" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="MaleCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="FemaleCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="TotalCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="TransferCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.spCalculateCostByType" Method="spCalculateCostByType">
    <Parameter Name="InvoiceNo" Parameter="invoiceNo" Type="System.String" DbType="NVarChar(100)" />
    <ElementType Name="spCalculateCostByTypeResult">
      <Column Name="DrugCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="ECGCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="USGCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="UCGCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="XRayCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="LabCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="RBSCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="ConsultationFee" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="ProcedureCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
      <Column Name="OGTTCost" Type="System.Decimal" DbType="Decimal(10,2)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.SP_GetMonthlyBirthServiceVisit" Method="SP_GetMonthlyBirthServiceVisit">
    <Parameter Name="FromDate" Parameter="fromDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="ToDate" Parameter="toDate" Type="System.DateTime" DbType="Date" />
    <ElementType Name="SP_GetMonthlyBirthServiceVisitResult">
      <Column Name="RowNumber" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />
      <Column Name="ClinicName" Type="System.String" DbType="NVarChar(255)" CanBeNull="true" />
      <Column Name="NSVDCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="LCSCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="AbortionCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="VaccumCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="EctopicCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="TotalChildBirthCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="SpecialistOGOPDCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="TransferCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="TotalCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
</Database>