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

: VisitDetail - JSON Representation

Raw json | Download

{
  "resourceType" : "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition",
  "name" : "VisitDetail",
  "status" : "draft",
  "description" : "Vue se rapprochant de la table OMOP visit_detail",
  "resource" : "Encounter",
  "select" : [
    {
      "column" : [
        {
          "path" : "id",
          "name" : "visit_detail_id"
        },
        {
          "path" : "subject.reference",
          "name" : "person_id"
        },
        {
          "path" : "id",
          "name" : "visit_occurrence_id"
        },
        {
          "path" : "period.start",
          "name" : "visit_detail_start_date"
        },
        {
          "path" : "period.start",
          "name" : "visit_detail_start_datetime"
        },
        {
          "path" : "period.end",
          "name" : "visit_detail_end_date"
        },
        {
          "path" : "period.end",
          "name" : "visit_detail_end_datetime"
        },
        {
          "path" : "class.code.where($this = 'IMP').count() * 9201 + class.code.where($this = 'AMB').count() * 9202 + class.code.where($this = 'EMER').count() * 9203",
          "name" : "visit_detail_concept_id"
        },
        {
          "path" : "class.display",
          "name" : "visit_detail_source_value"
        },
        {
          "path" : "class.code",
          "name" : "visit_detail_source_concept_id"
        },
        {
          "path" : "44818518",
          "name" : "visit_detail_type_concept_id"
        },
        {
          "path" : "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" : "admitted_from_concept_id"
        },
        {
          "path" : "hospitalization.admitSource.coding.first().display",
          "name" : "admitted_from_source_value"
        },
        {
          "path" : "hospitalization.admitSource.coding.first().code",
          "name" : "admitted_from_source_concept_id"
        },
        {
          "path" : "hospitalization.dischargeDisposition.coding.first().code.where($this = 'home').count() * 8536 + hospitalization.dischargeDisposition.coding.first().code.where($this = 'exp').count() * 4216643",
          "name" : "discharged_to_concept_id"
        },
        {
          "path" : "hospitalization.dischargeDisposition.coding.first().display",
          "name" : "discharged_to_source_value"
        },
        {
          "path" : "hospitalization.dischargeDisposition.coding.first().code",
          "name" : "discharged_to_source_concept_id"
        }
      ]
    }
  ]
}