Data Management with FHIR
0.1.0 - ci-build France (la) flag

Data Management with FHIR - version de développement local (intégration continue v0.1.0) construite par les outils de publication FHIR (HL7® FHIR® Standard). Voir le répertoire des versions publiées

: ConditionOccurrence - XML Representation

Raw xml | Download


<et:ViewDefinition xmlns:et="https://sql-on-fhir.org/ig/StructureDefinition"
                   xmlns="http://hl7.org/fhir">
  <name value="ConditionOccurrence"/>
  <status value="draft"/>
  <description
               value="Vue se rapprochant de la table OMOP condition_occurrence"/>
  <resource value="Condition"/>
  <select>
    <column>
      <path value="id"/>
      <name value="condition_occurrence_id"/>
    </column>
    <column>
      <path value="subject.reference"/>
      <name value="person_id"/>
    </column>
    <column>
      <path value="encounter.reference"/>
      <name value="visit_occurrence_id"/>
    </column>
    <column>
      <path value="encounter.reference"/>
      <name value="visit_detail_id"/>
    </column>
    <column>
      <path value="recordedDate"/>
      <name value="condition_start_date"/>
    </column>
    <column>
      <path value="0"/>
      <name value="condition_concept_id"/>
    </column>
    <column>
      <path value="code.coding.first().display"/>
      <name value="condition_source_value"/>
    </column>
    <column>
      <path value="code.coding.first().code"/>
      <name value="condition_source_concept_id"/>
    </column>
    <column>
      <path value="code.coding.first().system"/>
      <name value="condition_coding_source_system"/>
    </column>
    <column>
      <path value="32817"/>
      <name value="condition_type_concept_id"/>
    </column>
    <column>
      <path
            value="category.first().coding.first().code.where($this = 'DP').count() * 4307107 + category.first().coding.first().code.where($this = 'DA').count() * 4230359"/>
      <name value="condition_status_concept_id"/>
    </column>
    <column>
      <path value="category.first().coding.first().display"/>
      <name value="condition_status_source_value"/>
    </column>
  </select>
  <where>
    <path
          value="code.coding.where(code = 'Z87.2' or code = 'Z37.0' or code = 'Z88.0').exists().not()"/>
  </where>
</et:ViewDefinition>