<?xml version="1.0" encoding="WINDOWS-1252"?>
<xs:schema xmlns="http://xmlns.oracle.com/ord/meta/dicomImage" targetNamespace="http://xmlns.oracle.com/ord/meta/dicomImage" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xdb="http://xmlns.oracle.com/xdb" elementFormDefault="qualified" attributeFormDefault="unqualified" xdb:storeVarrayAsTable="true" xdb:flags="14688563" xdb:schemaURL="http://xmlns.oracle.com/ord/meta/dicomImage" xdb:schemaOwner="ORDSYS" xdb:numProps="124">
  <xs:annotation>
    <xs:documentation>    Date: 21 Sept 2005    Version: 10gR2_release_10.2.0.2    Name: dicomImage.xsd    Author: Dongbai Guo    Introduction      This schema defines the set of DICOM metadata for      ORDImage function getDicomMetadata().      The purpose of this set of functions is to extract from a DICOM image a set of      attributes to describe the image in XML, allowing easy browsing and retrieval.          Question mark &quot;?&quot; means optional items         The DICOM schema does not enforce the DICOM standard.  By default, conformance      is enforced by the getDicomMetadata code.  If DICOM conformance is disabled by      invoking the setDicomValidation method,we will extract metadata from      images with missing or null mandatory DICOM attributes, and/or non-conformant      DICOM attributes.  For attributes with non-conformant values, the raw data      will be placed in the rawValue attribute of the tag.    Structure Overview      DICOM_IMAGE        ORD_DICOM_HEADER          VERSION          DICOM_STANDARD_VERSION          DICOM_STANDARD_RELEASE        FILE_META_HEADER          MEDIA_STORAGE_SOP_CLASS_UID          MEDIA_STORAGE_SOP_INSTANCE_UID          TRANSFER_SYNTAX_UID          IMPLEMENTATION_CLASS_UID          IMPLEMENTATION_VERSION_NAME          SOURCE_APPLICATION_ENTITY_TITLE        PATIENT          NAME          ID          BIRTH_DATE          SEX        GENERAL_STUDY          INSTANCE_UID          DATE          TIME          REFERING_PHYSICIANS_NAME          ID          ACCESSION_NUMBER          DESCRIPTION?        PATIENT_STUDY?          ADMITTING_DIAGNOSES_DESCRIPTION          ADMITTING_DIAGNOSES_CODE_SEQUENCE        GENERAL_SERIES          MODALITY          INSTANCE_UID          DATE          TIME          PERFORMING_PHYSICIANS_NAME          BODY_PART_EXAMINED          PATIENT_POSITION          PERFORMED_PROCEDURE_STEP_ID          PERFORMED_PROCEDURE_STEP_START_DATE          PERFORMED_PROCEDURE_STEP_START_TIME          PERFORMED_PROCEDURE_STEP_DESCRIPTION          PERFORMED_PROTOCOL_CODE_SEQUENCE        GENERAL_EQUIPMENT?          MANUFACTURER        GENERAL_IMAGE?          INSTANCE_NUMBER          ACQUISITION_NUMBER          ACQUISITION_DATE          ACQUISITION_TIME          ACQUISITION_DATETIME          PATIENT_ORIENTATION          FRAME_LATERALITY          ANATOMIC_REGION        IMAGE_PIXEL?          SAMPLES_PER_PIXEL          PHOTOMETRIC_INTERPRETATION          ROWS          COLUMNS          BIT_ALLOCATED          BIT_STORED          HIGH_BIT          PIXEL_REPRESENTATION       		PLANAR_CONFIGURATION          PIXEL_ASPECT_RATIO        SOP_COMMON          CLASS_UID          INSTANCE_UID						          SPECIFIC_CHARACTER_SET    List of DICOM attribute tags appeared in this schema      (0002, 0002)  MEDIA_STORAGE_SOP_CLASS_UID      (0002, 0003)  MEDIA_STORAGE_SOP_INSTANCE_UID      (0002, 0010)  TRANSFER_SYNTAX_UID      (0002, 0012)  IMPLEMENTATION_CLASS_UID      (0002, 0013)  IMPLEMENTATION_VERSION_NAME      (0002, 0016)  SOURCE_APPLICATION_ENTITY_TITLE      (0008, 0005)  SPECIFIC_CHARACTER_SET      (0008, 0016)  SOP CLASS_UID      (0008, 0018)  SOP INSTANCE_UID      (0008, 0020)  STUDY DATE      (0008, 0021)  SERIES DATE      (0008, 0022)  ACQUISITION_DATE      (0008, 002A)  ACQUISITION_DATETIME      (0008, 0030)  STUDY TIME      (0008, 0031)  SERIES TIME      (0008, 0032)  ACQUISITION_TIME      (0008, 0050)  ACCESSION_NUMBER      (0008, 0060)  MODALITY      (0008, 0070)  MANUFACTURER      (0008, 0090)  REFERING_PHYSICIANS_NAME      (0008, 1030)  STUDY DESCRIPTION      (0008, 1050)  PERFORMING_PHYSICIANS_NAME      (0008, 1080)  ADMITTING_DIAGNOSES_DESCRIPTION      (0008, 1084)  ADMITTING_DIAGNOSES_CODE_SEQUENCE      (0008, 2218)  ANATOMIC_REGION      (0010, 0010)  PATIENT NAME      (0010, 0020)  PATIENT ID      (0010, 0030)  PATIENT BIRTH_DATE      (0010, 0040)  PATIENT SEX      (0018, 0015)  BODY_PART_EXAMINED      (0018, 5100)  PATIENT_POSITION          (0020, 000D)  STUDY INSTANCE_UID      (0020, 000E)  SERIES INSTANCE_UID      (0020, 0010)  STUDY ID      (0020, 0012)  ACQUISITION_NUMBER      (0020, 0013)  INSTANCE_NUMBER      (0020, 0020)  PATIENT_ORIENTATION      (0020, 9072)  FRAME_LATERALITY      (0028, 0002)  SAMPLES_PER_PIXEL      (0028, 0004)  PHOTOMETRIC_INTERPRETATION      (0028, 0006)  PLANAR_CONFIGURATION      (0028, 0010)  ROWS      (0028, 0011)  COLUMNS      (0028, 0034)  PIXEL_ASPECT_RATIO      (0028, 0100)  BIT_ALLOCATED      (0028, 0101)  BIT_STORED      (0028, 0102)  HIGH_BIT      (0028, 0103)  PIXEL_REPRESENTATION      (0040, 0244)  PERFORMED_PROCEDURE_STEP_START_DATE      (0040, 0245)  PERFORMED_PROCEDURE_STEP_START_TIME      (0040, 0253)  PERFORMED_PROCEDURE_STEP_ID      (0040, 0254)  PERFORMED_PROCEDURE_STEP_DESCRIPTION      (0040, 0260)  PERFORMED_PROTOCOL_CODE_SEQUENCE          </xs:documentation>
  </xs:annotation>
  <xs:element name="DICOM_IMAGE" xdb:defaultTable="" xdb:propNumber="2656" xdb:global="true" xdb:SQLName="DICOM_IMAGE" xdb:SQLType="DICOM_IMAGE84_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:defaultTableSchema="ORDSYS">
    <xs:complexType xdb:SQLType="DICOM_IMAGE84_T" xdb:SQLSchema="ORDSYS">
      <xs:sequence>
        <xs:element name="ORD_DICOM_HEADER" xdb:propNumber="2543" xdb:global="false" xdb:SQLName="ORD_DICOM_HEADER" xdb:SQLType="ORD_DICOM_HEADER85_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="ORD_DICOM_HEADER85_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- XML document version number is "1.0" for database release 10gR2 -->
              <xs:element name="VERSION" type="SH" xdb:propNumber="2540" xdb:global="false" xdb:SQLName="VERSION" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
              <!-- The DICOM Base Standard version this XML document is derived from is "3". -->
              <xs:element name="DICOM_STANDARD_VERSION" type="SH" xdb:propNumber="2541" xdb:global="false" xdb:SQLName="DICOM_STANDARD_VERSION" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
              <!-- The DICOM Base Standard this XML document is derived from is 2004. -->
              <xs:element name="DICOM_STANDARD_RELEASE" type="SH" xdb:propNumber="2542" xdb:global="false" xdb:SQLName="DICOM_STANDARD_RELEASE" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FILE_META_HEADER" minOccurs="0" xdb:propNumber="2556" xdb:global="false" xdb:SQLName="FILE_META_HEADER" xdb:SQLType="FILE_META_HEADER86_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="FILE_META_HEADER86_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0002, 0002), mandatory-->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="MEDIA_STORAGE_SOP_CLASS_UID" minOccurs="0" nillable="true" xdb:propNumber="2545" xdb:global="false" xdb:SQLName="MEDIA_STORAGE_SOP_CLASS_UID" xdb:SQLType="MEDIA_STORAGE_SOP_CLASS87_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="MEDIA_STORAGE_SOP_CLASS87_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2544" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0002, 0003), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="MEDIA_STORAGE_SOP_INSTANCE_UID" minOccurs="0" nillable="true" xdb:propNumber="2547" xdb:global="false" xdb:SQLName="MEDIA_STORAGE_SOP_INSTANCE_UID" xdb:SQLType="MEDIA_STORAGE_SOP_INSTA88_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="MEDIA_STORAGE_SOP_INSTA88_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2546" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0002, 0010), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="TRANSFER_SYNTAX_UID" minOccurs="0" nillable="true" xdb:propNumber="2549" xdb:global="false" xdb:SQLName="TRANSFER_SYNTAX_UID" xdb:SQLType="TRANSFER_SYNTAX_UID89_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="TRANSFER_SYNTAX_UID89_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2548" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0002, 0012), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="IMPLEMENTATION_CLASS_UID" minOccurs="0" nillable="true" xdb:propNumber="2551" xdb:global="false" xdb:SQLName="IMPLEMENTATION_CLASS_UID" xdb:SQLType="IMPLEMENTATION_CLASS_UI90_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="IMPLEMENTATION_CLASS_UI90_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2550" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0002, 0013), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="IMPLEMENTATION_VERSION_NAME" minOccurs="0" nillable="true" xdb:propNumber="2553" xdb:global="false" xdb:SQLName="IMPLEMENTATION_VERSION_NAME" xdb:SQLType="IMPLEMENTATION_VERSION_91_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="IMPLEMENTATION_VERSION_91_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="SH">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2552" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0002, 0016), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="SOURCE_APPLICATION_ENTITY_TITLE" minOccurs="0" nillable="true" xdb:propNumber="2555" xdb:global="false" xdb:SQLName="SOURCE_APPLICATION_ENTITY92" xdb:SQLType="SOURCE_APPLICATION_ENTI93_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="SOURCE_APPLICATION_ENTI93_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="AE">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2554" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PATIENT" minOccurs="0" xdb:propNumber="2565" xdb:global="false" xdb:SQLName="PATIENT" xdb:SQLType="PATIENT94_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="PATIENT94_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0010, 0010), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="NAME" minOccurs="0" nillable="true" xdb:propNumber="2558" xdb:global="false" xdb:SQLName="NAME" xdb:SQLType="NAME95_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="NAME95_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="PN">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2557" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0010, 0020), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ID" minOccurs="0" nillable="true" xdb:propNumber="2560" xdb:global="false" xdb:SQLName="ID" xdb:SQLType="ID96_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ID96_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="LO">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2559" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0010, 0030), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="BIRTH_DATE" minOccurs="0" nillable="true" xdb:propNumber="2562" xdb:global="false" xdb:SQLName="BIRTH_DATE" xdb:SQLType="BIRTH_DATE97_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="BIRTH_DATE97_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="DA">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2561" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0010, 0040), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="SEX" minOccurs="0" nillable="true" xdb:propNumber="2564" xdb:global="false" xdb:SQLName="SEX" xdb:SQLType="SEX98_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="SEX98_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2563" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GENERAL_STUDY" minOccurs="0" xdb:propNumber="2580" xdb:global="false" xdb:SQLName="GENERAL_STUDY" xdb:SQLType="GENERAL_STUDY99_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="GENERAL_STUDY99_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0020, 000D) mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="INSTANCE_UID" minOccurs="0" nillable="true" xdb:propNumber="2567" xdb:global="false" xdb:SQLName="INSTANCE_UID" xdb:SQLType="INSTANCE_UID100_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="INSTANCE_UID100_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2566" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0020), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="DATE" minOccurs="0" nillable="true" xdb:propNumber="2569" xdb:global="false" xdb:SQLName="DATE101" xdb:SQLType="DATE102_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="DATE102_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="DA">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2568" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0030), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="TIME" minOccurs="0" nillable="true" xdb:propNumber="2571" xdb:global="false" xdb:SQLName="TIME" xdb:SQLType="TIME103_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="TIME103_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="TM">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2570" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0090), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="REFERING_PHYSICIANS_NAME" minOccurs="0" nillable="true" xdb:propNumber="2573" xdb:global="false" xdb:SQLName="REFERING_PHYSICIANS_NAME" xdb:SQLType="REFERING_PHYSICIANS_NAM104_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="REFERING_PHYSICIANS_NAM104_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="PN">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2572" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0020, 0010), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ID" minOccurs="0" nillable="true" xdb:propNumber="2575" xdb:global="false" xdb:SQLName="ID" xdb:SQLType="ID105_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ID105_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="SH">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2574" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0050), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ACCESSION_NUMBER" minOccurs="0" nillable="true" xdb:propNumber="2577" xdb:global="false" xdb:SQLName="ACCESSION_NUMBER" xdb:SQLType="ACCESSION_NUMBER106_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ACCESSION_NUMBER106_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="SH">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2576" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 1030) optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="DESCRIPTION" minOccurs="0" nillable="true" xdb:propNumber="2579" xdb:global="false" xdb:SQLName="DESCRIPTION" xdb:SQLType="DESCRIPTION107_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="DESCRIPTION107_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="LO">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2578" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PATIENT_STUDY" minOccurs="0" xdb:propNumber="2584" xdb:global="false" xdb:SQLName="PATIENT_STUDY" xdb:SQLType="PATIENT_STUDY108_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="PATIENT_STUDY108_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0008, 1080), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ADMITTING_DIAGNOSES_DESCRIPTION" minOccurs="0" maxOccurs="unbounded" nillable="true" xdb:propNumber="2582" xdb:global="false" xdb:SQLName="ADMITTING_DIAGNOSES_DESCR109" xdb:SQLType="ADMITTING_DIAGNOSES_DES110_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false" xdb:SQLCollType="ADMITTING_DIAGNOSES_111_COLL" xdb:SQLCollSchema="ORDSYS">
                <xs:complexType xdb:SQLType="ADMITTING_DIAGNOSES_DES110_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="LO">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2581" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 1084), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ADMITTING_DIAGNOSES_CODE_SEQUENCE" minOccurs="0" nillable="true" type="CODE_SQ" xdb:propNumber="2583" xdb:global="false" xdb:SQLName="ADMITTING_DIAGNOSES_CODE_112" xdb:SQLType="CODE_SQ82_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false"/>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GENERAL_SERIES" minOccurs="0" xdb:propNumber="2608" xdb:global="false" xdb:SQLName="GENERAL_SERIES" xdb:SQLType="GENERAL_SERIES113_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="GENERAL_SERIES113_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0008, 0060), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="MODALITY" minOccurs="0" nillable="true" xdb:propNumber="2586" xdb:global="false" xdb:SQLName="MODALITY" xdb:SQLType="MODALITY114_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="MODALITY114_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2585" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0020, 000E), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="INSTANCE_UID" minOccurs="0" nillable="true" xdb:propNumber="2588" xdb:global="false" xdb:SQLName="INSTANCE_UID" xdb:SQLType="INSTANCE_UID115_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="INSTANCE_UID115_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2587" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0021), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="DATE" minOccurs="0" nillable="true" xdb:propNumber="2590" xdb:global="false" xdb:SQLName="DATE116" xdb:SQLType="DATE117_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="DATE117_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="DA">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2589" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0031), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="TIME" minOccurs="0" nillable="true" xdb:propNumber="2592" xdb:global="false" xdb:SQLName="TIME" xdb:SQLType="TIME118_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="TIME118_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="TM">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2591" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 1050), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PERFORMING_PHYSICIANS_NAME" minOccurs="0" maxOccurs="unbounded" nillable="true" xdb:propNumber="2594" xdb:global="false" xdb:SQLName="PERFORMING_PHYSICIANS_NAME" xdb:SQLType="PERFORMING_PHYSICIANS_N119_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false" xdb:SQLCollType="PERFORMING_PHYSICIAN120_COLL" xdb:SQLCollSchema="ORDSYS">
                <xs:complexType xdb:SQLType="PERFORMING_PHYSICIANS_N119_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="PN">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2593" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0018, 0015), optional -->
              <!-- Note will not replace with modality specific values -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="BODY_PART_EXAMINED" minOccurs="0" nillable="true" xdb:propNumber="2596" xdb:global="false" xdb:SQLName="BODY_PART_EXAMINED" xdb:SQLType="BODY_PART_EXAMINED121_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="BODY_PART_EXAMINED121_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2595" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0018, 5100), conditional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PATIENT_POSITION" minOccurs="0" nillable="true" xdb:propNumber="2598" xdb:global="false" xdb:SQLName="PATIENT_POSITION" xdb:SQLType="PATIENT_POSITION122_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PATIENT_POSITION122_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2597" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0040, 0253), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PERFORMED_PROCEDURE_STEP_ID" minOccurs="0" nillable="true" xdb:propNumber="2600" xdb:global="false" xdb:SQLName="PERFORMED_PROCEDURE_STEP_ID" xdb:SQLType="PERFORMED_PROCEDURE_STE123_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PERFORMED_PROCEDURE_STE123_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="SH">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2599" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0040, 0244), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PERFORMED_PROCEDURE_STEP_START_DATE" minOccurs="0" nillable="true" xdb:propNumber="2602" xdb:global="false" xdb:SQLName="PERFORMED_PROCEDURE_STEP_124" xdb:SQLType="PERFORMED_PROCEDURE_STE125_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PERFORMED_PROCEDURE_STE125_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="DA">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2601" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0040, 0245), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PERFORMED_PROCEDURE_STEP_START_TIME" minOccurs="0" nillable="true" xdb:propNumber="2604" xdb:global="false" xdb:SQLName="PERFORMED_PROCEDURE_STEP_126" xdb:SQLType="PERFORMED_PROCEDURE_STE127_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PERFORMED_PROCEDURE_STE127_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="TM">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2603" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0040, 0254), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PERFORMED_PROCEDURE_STEP_DESCRIPTION" minOccurs="0" nillable="true" xdb:propNumber="2606" xdb:global="false" xdb:SQLName="PERFORMED_PROCEDURE_STEP_128" xdb:SQLType="PERFORMED_PROCEDURE_STE129_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PERFORMED_PROCEDURE_STE129_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="LO">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2605" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0040, 0260), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PERFORMED_PROTOCOL_CODE_SEQUENCE" minOccurs="0" nillable="true" type="CODE_SQ" xdb:propNumber="2607" xdb:global="false" xdb:SQLName="PERFORMED_PROTOCOL_CODE_S130" xdb:SQLType="CODE_SQ82_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false"/>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GENERAL_EQUIPMENT" minOccurs="0" xdb:propNumber="2611" xdb:global="false" xdb:SQLName="GENERAL_EQUIPMENT" xdb:SQLType="GENERAL_EQUIPMENT131_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="GENERAL_EQUIPMENT131_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0008, 0070), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="MANUFACTURER" minOccurs="0" nillable="true" xdb:propNumber="2610" xdb:global="false" xdb:SQLName="MANUFACTURER" xdb:SQLType="MANUFACTURER132_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="MANUFACTURER132_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="LO">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2609" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GENERAL_IMAGE" minOccurs="0" xdb:propNumber="2627" xdb:global="false" xdb:SQLName="GENERAL_IMAGE" xdb:SQLType="GENERAL_IMAGE133_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="GENERAL_IMAGE133_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0020, 0013), nullable -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="INSTANCE_NUMBER" minOccurs="0" nillable="true" xdb:propNumber="2613" xdb:global="false" xdb:SQLName="INSTANCE_NUMBER" xdb:SQLType="INSTANCE_NUMBER134_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="INSTANCE_NUMBER134_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="IS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2612" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0020, 0012), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ACQUISITION_NUMBER" minOccurs="0" nillable="true" xdb:propNumber="2615" xdb:global="false" xdb:SQLName="ACQUISITION_NUMBER" xdb:SQLType="ACQUISITION_NUMBER135_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ACQUISITION_NUMBER135_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="IS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2614" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0022), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ACQUISITION_DATE" minOccurs="0" nillable="true" xdb:propNumber="2617" xdb:global="false" xdb:SQLName="ACQUISITION_DATE" xdb:SQLType="ACQUISITION_DATE136_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ACQUISITION_DATE136_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="DA">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2616" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0032), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ACQUISITION_TIME" minOccurs="0" nillable="true" xdb:propNumber="2619" xdb:global="false" xdb:SQLName="ACQUISITION_TIME" xdb:SQLType="ACQUISITION_TIME137_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ACQUISITION_TIME137_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="TM">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2618" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 002A), optional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ACQUISITION_DATETIME" minOccurs="0" nillable="true" xdb:propNumber="2621" xdb:global="false" xdb:SQLName="ACQUISITION_DATETIME" xdb:SQLType="ACQUISITION_DATETIME138_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ACQUISITION_DATETIME138_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="DT">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2620" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0020, 0020), conditional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PATIENT_ORIENTATION" minOccurs="0" maxOccurs="2" nillable="true" xdb:propNumber="2623" xdb:global="false" xdb:SQLName="PATIENT_ORIENTATION" xdb:SQLType="PATIENT_ORIENTATION139_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false" xdb:SQLCollType="PATIENT_ORIENTATION140_COLL" xdb:SQLCollSchema="ORDSYS">
                <xs:complexType xdb:SQLType="PATIENT_ORIENTATION139_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2622" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0020, 9072) conditional-->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="FRAME_LATERALITY" minOccurs="0" nillable="true" xdb:propNumber="2625" xdb:global="false" xdb:SQLName="FRAME_LATERALITY" xdb:SQLType="FRAME_LATERALITY141_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="FRAME_LATERALITY141_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2624" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 2218) Frame anatomy macro, conditional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ANATOMIC_REGION" minOccurs="0" nillable="true" type="CODE_SQ" xdb:propNumber="2626" xdb:global="false" xdb:SQLName="ANATOMIC_REGION" xdb:SQLType="CODE_SQ82_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false"/>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IMAGE_PIXEL" minOccurs="0" xdb:propNumber="2648" xdb:global="false" xdb:SQLName="IMAGE_PIXEL" xdb:SQLType="IMAGE_PIXEL142_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="IMAGE_PIXEL142_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0028, 0002), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="SAMPLES_PER_PIXEL" minOccurs="0" nillable="true" xdb:propNumber="2629" xdb:global="false" xdb:SQLName="SAMPLES_PER_PIXEL" xdb:SQLType="SAMPLES_PER_PIXEL143_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="SAMPLES_PER_PIXEL143_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2628" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0004), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PHOTOMETRIC_INTERPRETATION" minOccurs="0" nillable="true" xdb:propNumber="2631" xdb:global="false" xdb:SQLName="PHOTOMETRIC_INTERPRETATION" xdb:SQLType="PHOTOMETRIC_INTERPRETAT144_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PHOTOMETRIC_INTERPRETAT144_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2630" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0010), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="ROWS" minOccurs="0" nillable="true" xdb:propNumber="2633" xdb:global="false" xdb:SQLName="ROWS145" xdb:SQLType="ROWS146_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="ROWS146_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2632" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0011), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="COLUMNS" minOccurs="0" nillable="true" xdb:propNumber="2635" xdb:global="false" xdb:SQLName="COLUMNS" xdb:SQLType="COLUMNS147_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="COLUMNS147_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2634" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0100), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="BIT_ALLOCATED" minOccurs="0" nillable="true" xdb:propNumber="2637" xdb:global="false" xdb:SQLName="BIT_ALLOCATED" xdb:SQLType="BIT_ALLOCATED148_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="BIT_ALLOCATED148_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2636" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0101), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="BIT_STORED" minOccurs="0" nillable="true" xdb:propNumber="2639" xdb:global="false" xdb:SQLName="BIT_STORED" xdb:SQLType="BIT_STORED149_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="BIT_STORED149_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2638" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0102), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="HIGH_BIT" minOccurs="0" nillable="true" xdb:propNumber="2641" xdb:global="false" xdb:SQLName="HIGH_BIT" xdb:SQLType="HIGH_BIT150_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="HIGH_BIT150_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2640" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0103), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PIXEL_REPRESENTATION" minOccurs="0" nillable="true" xdb:propNumber="2643" xdb:global="false" xdb:SQLName="PIXEL_REPRESENTATION" xdb:SQLType="PIXEL_REPRESENTATION151_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PIXEL_REPRESENTATION151_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2642" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (7FE0, 0010) PIXEL_DATA, not included -->
              <!-- (0028, 0006), conditional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PLANAR_CONFIGURATION" minOccurs="0" nillable="true" xdb:propNumber="2645" xdb:global="false" xdb:SQLName="PLANAR_CONFIGURATION" xdb:SQLType="PLANAR_CONFIGURATION152_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="PLANAR_CONFIGURATION152_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="US">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2644" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0028, 0034), conditional -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="PIXEL_ASPECT_RATIO" minOccurs="0" maxOccurs="2" nillable="true" xdb:propNumber="2647" xdb:global="false" xdb:SQLName="PIXEL_ASPECT_RATIO" xdb:SQLType="PIXEL_ASPECT_RATIO153_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false" xdb:SQLCollType="PIXEL_ASPECT_RATIO154_COLL" xdb:SQLCollSchema="ORDSYS">
                <xs:complexType xdb:SQLType="PIXEL_ASPECT_RATIO153_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="IS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2646" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SOP_COMMON" minOccurs="0" xdb:propNumber="2655" xdb:global="false" xdb:SQLName="SOP_COMMON" xdb:SQLType="SOP_COMMON155_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
          <xs:complexType xdb:SQLType="SOP_COMMON155_T" xdb:SQLSchema="ORDSYS">
            <xs:sequence>
              <!-- (0008, 0016), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="CLASS_UID" minOccurs="0" nillable="true" xdb:propNumber="2650" xdb:global="false" xdb:SQLName="CLASS_UID" xdb:SQLType="CLASS_UID156_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="CLASS_UID156_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2649" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0018), mandatory -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="INSTANCE_UID" minOccurs="0" nillable="true" xdb:propNumber="2652" xdb:global="false" xdb:SQLName="INSTANCE_UID" xdb:SQLType="INSTANCE_UID157_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false">
                <xs:complexType xdb:SQLType="INSTANCE_UID157_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="UI">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2651" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <!-- (0008, 0005) -->
              <!-- DICOM standard requires this attribute to be mandatory and not null -->
              <xs:element name="SPECIFIC_CHARACTER_SET" minOccurs="0" maxOccurs="unbounded" nillable="true" xdb:propNumber="2654" xdb:global="false" xdb:SQLName="SPECIFIC_CHARACTER_SET" xdb:SQLType="SPECIFIC_CHARACTER_SET158_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false" xdb:SQLCollType="SPECIFIC_CHARACTER_S159_COLL" xdb:SQLCollSchema="ORDSYS">
                <xs:complexType xdb:SQLType="SPECIFIC_CHARACTER_SET158_T" xdb:SQLSchema="ORDSYS">
                  <xs:simpleContent>
                    <xs:extension base="CS">
                      <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2653" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <!-- Complex data type -->
  <!-- code sequence -->
  <xs:complexType name="CODE_SQ" xdb:SQLType="CODE_SQ82_T" xdb:SQLSchema="ORDSYS">
    <xs:sequence>
      <xs:element name="CODE_SEQUENCE" type="CODE_SEQUENCE" maxOccurs="unbounded" xdb:propNumber="2658" xdb:global="false" xdb:SQLName="CODE_SEQUENCE" xdb:SQLType="CODE_SEQUENCE81_T" xdb:SQLSchema="ORDSYS" xdb:memType="258" xdb:MemInline="false" xdb:SQLInline="true" xdb:JavaInline="false" xdb:SQLCollType="CODE_SEQUENCE83_COLL" xdb:SQLCollSchema="ORDSYS"/>
    </xs:sequence>
    <xs:attribute name="rawValue" type="xs:string" xdb:propNumber="2657" xdb:global="false" xdb:SQLName="rawValue" xdb:SQLType="VARCHAR2" xdb:memType="1"/>
  </xs:complexType>
  <xs:complexType name="CODE_SEQUENCE" xdb:SQLType="CODE_SEQUENCE81_T" xdb:SQLSchema="ORDSYS">
    <xs:sequence>
      <xs:element name="ITEM_NUMBER" type="xs:positiveInteger" xdb:propNumber="2659" xdb:global="false" xdb:SQLName="ITEM_NUMBER" xdb:SQLType="NUMBER" xdb:memType="2" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
      <xs:element name="CODE_VALUE" type="xs:string" xdb:propNumber="2660" xdb:global="false" xdb:SQLName="CODE_VALUE" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
      <xs:element name="CODING_SCHEME" type="xs:string" xdb:propNumber="2661" xdb:global="false" xdb:SQLName="CODING_SCHEME" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
      <xs:element name="CODING_SCHEME_VERSION" type="xs:string" minOccurs="0" xdb:propNumber="2662" xdb:global="false" xdb:SQLName="CODING_SCHEME_VERSION" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
      <xs:element name="CODING_MEANING" type="xs:string" minOccurs="0" xdb:propNumber="2663" xdb:global="false" xdb:SQLName="CODING_MEANING" xdb:SQLType="VARCHAR2" xdb:memType="1" xdb:MemInline="true" xdb:SQLInline="true" xdb:JavaInline="true"/>
    </xs:sequence>
  </xs:complexType>
  <!-- Simple data types -->
  <!-- Application Entity -->
  <xs:simpleType name="AE">
    <xs:restriction base="xs:string">
      <xs:maxLength value="16"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- Coded String -->
  <xs:simpleType name="CS">
    <xs:restriction base="xs:token">
      <xs:maxLength value="16"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- DAte -->
  <xs:simpleType name="DA">
    <xs:restriction base="xs:date"/>
  </xs:simpleType>
  <!-- DateTime -->
  <xs:simpleType name="DT">
    <xs:restriction base="xs:dateTime"/>
  </xs:simpleType>
  <!-- Integer String -->
  <xs:simpleType name="IS">
    <xs:restriction base="xs:integer"/>
  </xs:simpleType>
  <!-- LOng string -->
  <xs:simpleType name="LO">
    <xs:restriction base="xs:string">
      <xs:maxLength value="64"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- Person Name -->
  <xs:simpleType name="PN">
    <xs:restriction base="xs:token">
      <xs:maxLength value="64"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- SHort String -->
  <xs:simpleType name="SH">
    <xs:restriction base="xs:string">
      <xs:maxLength value="16"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- Short String -->
  <xs:simpleType name="SS">
    <xs:restriction base="xs:short"/>
  </xs:simpleType>
  <!-- TiMe -->
  <xs:simpleType name="TM">
    <xs:restriction base="xs:time"/>
  </xs:simpleType>
  <!-- UId -->
  <xs:simpleType name="UI">
    <xs:restriction base="xs:token">
      <xs:maxLength value="64"/>
      <xs:pattern value="([0-9]+\.)*[0-9]+"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- Unsigned Short -->
  <xs:simpleType name="US">
    <xs:restriction base="xs:unsignedShort"/>
  </xs:simpleType>
</xs:schema>
