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

• Narrative Content
• XML
• JSON
• TTL

: VisitDetail - XML Representation

Raw xml | Download

<et:ViewDefinition xmlns:et="https://sql-on-fhir.org/ig/StructureDefinition"
                   xmlns="http://hl7.org/fhir">
  <name value="VisitDetail"/>
  <status value="draft"/>
  <description value="Vue se rapprochant de la table OMOP visit_detail"/>
  <resource value="Encounter"/>
  <select>
    <column>
      <path value="id"/>
      <name value="visit_detail_id"/>
    </column>
    <column>
      <path value="subject.reference"/>
      <name value="person_id"/>
    </column>
    <column>
      <path value="id"/>
      <name value="visit_occurrence_id"/>
    </column>
    <column>
      <path value="period.start"/>
      <name value="visit_detail_start_date"/>
    </column>
    <column>
      <path value="period.start"/>
      <name value="visit_detail_start_datetime"/>
    </column>
    <column>
      <path value="period.end"/>
      <name value="visit_detail_end_date"/>
    </column>
    <column>
      <path value="period.end"/>
      <name value="visit_detail_end_datetime"/>
    </column>
    <column>
      <path
            value="class.code.where($this = 'IMP').count() * 9201 + class.code.where($this = 'AMB').count() * 9202 + class.code.where($this = 'EMER').count() * 9203"/>
      <name value="visit_detail_concept_id"/>
    </column>
    <column>
      <path value="class.display"/>
      <name value="visit_detail_source_value"/>
    </column>
    <column>
      <path value="class.code"/>
      <name value="visit_detail_source_concept_id"/>
    </column>
    <column>
      <path value="44818518"/>
      <name value="visit_detail_type_concept_id"/>
    </column>
    <column>
      <path
            value="hospitalization.admitSource.coding.first().code.where($this = 'emd').count() * 8870 + hospitalization.admitSource.coding.first().code.where($this = 'gp').count() * 8782 + hospitalization.admitSource.coding.first().code.where($this = 'other').count() * 8844"/>
      <name value="admitted_from_concept_id"/>
    </column>
    <column>
      <path value="hospitalization.admitSource.coding.first().display"/>
      <name value="admitted_from_source_value"/>
    </column>
    <column>
      <path value="hospitalization.admitSource.coding.first().code"/>
      <name value="admitted_from_source_concept_id"/>
    </column>
    <column>
      <path
            value="hospitalization.dischargeDisposition.coding.first().code.where($this = 'home').count() * 8536 + hospitalization.dischargeDisposition.coding.first().code.where($this = 'exp').count() * 4216643"/>
      <name value="discharged_to_concept_id"/>
    </column>
    <column>
      <path
            value="hospitalization.dischargeDisposition.coding.first().display"/>
      <name value="discharged_to_source_value"/>
    </column>
    <column>
      <path value="hospitalization.dischargeDisposition.coding.first().code"/>
      <name value="discharged_to_source_concept_id"/>
    </column>
  </select>
</et:ViewDefinition>