Starter FHIR Implementation Guide
1.0.1 - draft International flag

Starter FHIR Implementation Guide, published by Jembi Health Systems. This guide is not an authorized publication; it is the continuous build for version 1.0.1 built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/jembi/Starter-FHIR-IG/ and changes regularly. See the Directory of published versions

Binary: SQL - List all Patients and their Identifiers

    
{
  "resourceType": "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/ViewDefinition",
  "url": "http://jembi.org/fhir/ViewDefinition/AllPatientIdentifiers",
  "title": "SQL - List all Patients and their Identifiers",
  "description": "A SQL query to find all patients and list out their identifiers (server-generated and business).",
  "name": "all_patients",
  "status": "active",
  "experimental": true,
  "resource": "Patient",
  "select": [
    {
      "column": [
        {
          "description": "The patient's server identifier",
          "name": "patient_id",
          "path": "id",
          "type": "id"
        }
      ]
    },
    {
      "forEach": "identifier",
      "column": [
        {
          "description": "The patient's business identifiers",
          "name": "identifier",
          "path": "value",
          "type": "string"
        }
      ]
    }
  ]
}