SQL on FHIR
2.1.0-pre - release International flag

SQL on FHIR - Local Development build (v2.1.0-pre) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

Example Binary: ConditionFlat

This content is an example of the View Definition Logical Model and is not a FHIR Resource

    
{
  "resourceType": "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition",
  "select": [
    {
      "column": [
        {
          "path": "getResourceKey()",
          "name": "id"
        },
        {
          "path": "subject.getReferenceKey(Patient)",
          "name": "patient_id"
        },
        {
          "path": "encounter.getReferenceKey(Encounter)",
          "name": "encounter_id"
        },
        {
          "path": "onset.ofType(dateTime)",
          "name": "onset_datetime",
          "type": "dateTime"
        }
      ]
    },
    {
      "column": [
        {
          "name": "system",
          "path": "system",
          "type": "uri"
        },
        {
          "path": "code",
          "name": "code"
        }
      ],
      "forEachOrNull": "code.coding"
    },
    {
      "column": [
        {
          "path": "code",
          "name": "category"
        }
      ],
      "forEachOrNull": "category.coding"
    },
    {
      "column": [
        {
          "path": "code",
          "name": "clinical_status"
        }
      ],
      "forEachOrNull": "clinicalStatus.coding"
    },
    {
      "column": [
        {
          "path": "code",
          "name": "verification_status"
        }
      ],
      "forEachOrNull": "verificationStatus.coding"
    }
  ],
  "name": "condition_flat",
  "status": "draft",
  "resource": "Condition"
}