{
  "description": "A specification for defining portable views of FHIR data that can be easily queried using tools such as SQL.",
  "_filename": "ImplementationGuide-org.sql-on-fhir.ig.json",
  "package_name": "org.sql-on-fhir.ig",
  "definition": {
    "page": {
      "name": "toc.html",
      "page": [ {
        "name": "index.html",
        "title": "Home",
        "sourceUrl": "index.html",
        "generation": "markdown"
      }, {
        "name": "contributing.html",
        "title": "Contributing",
        "sourceUrl": "contributing.html",
        "generation": "markdown"
      }, {
        "name": "functional-model.html",
        "title": "Functional Model",
        "sourceUrl": "functional-model.html",
        "generation": "markdown"
      }, {
        "name": "glossary.html",
        "title": "Glossary",
        "sourceUrl": "glossary.html",
        "generation": "markdown"
      } ],
      "title": "Table of Contents",
      "sourceUrl": "toc.html",
      "generation": "html"
    },
    "resource": [ {
      "name": "PatientAddresses",
      "profile": [ "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-resource-format",
        "valueCode": "application/fhir+json"
      }, {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Binary"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Binary/PatientAddresses"
      },
      "description": "An example of unnesting patient addresses into multiple\nrows.\n\nThis view uses `forEach` to indicate we are unrolling these into separate rows. \nThe `join` function is used to create a single address line."
    }, {
      "name": "PatientAndContactAddressUnion",
      "profile": [ "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-resource-format",
        "valueCode": "application/fhir+json"
      }, {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Binary"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Binary/PatientAndContactAddressUnion"
      },
      "description": "An example of unnesting patient addresses and contact addresss\ninto multiple rows, which are unioned together into a single table."
    }, {
      "name": "PatientDemographics",
      "profile": [ "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-resource-format",
        "valueCode": "application/fhir+json"
      }, {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Binary"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Binary/PatientDemographics"
      },
      "description": "A minimal example of a patient demographics view.\nThis view uses the first 'official' patient name for our demographics table."
    }, {
      "name": "Shareable View Definition",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:logical"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/ShareableViewDefinition"
      },
      "description": "A profile for View Definitions intended to be shared between multiple systems. This requires that \nthe View Definition have a defined URL and name. It also requires declaration of the FHIR version \nthat the view is intended to be executed over, and the FHIR type of each column. This ensures \nconsistent interpretation of the view across different view runner implementations."
    }, {
      "name": "ShareablePatientDemographics",
      "profile": [ "https://sql-on-fhir.org/ig/StructureDefinition/ShareableViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-resource-format",
        "valueCode": "application/fhir+json"
      }, {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Binary"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Binary/ShareablePatientDemographics"
      },
      "description": "Creates the same view as the 'PatientDemographics' example, but applies both the\nShareableViewDefinition and TabularViewDefinition profiles."
    }, {
      "name": "Tabular View Definition",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:logical"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/TabularViewDefinition"
      },
      "description": "A profile for View Definitions where each resulting field must contain only a simple scalar value.\nThis is sometimes referred to as 'CSV Mode', but applies to any system that explicitly constrains \nits views or tables to tabular data."
    }, {
      "name": "UsCoreBloodPressures",
      "profile": [ "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition" ],
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-resource-format",
        "valueCode": "application/fhir+json"
      }, {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "Binary"
      } ],
      "isExample": true,
      "reference": {
        "reference": "Binary/UsCoreBloodPressures"
      },
      "description": "A simple view of blood pressure observations, with separate columns for \nsystolic and diastolic values."
    }, {
      "name": "View Definition",
      "extension": [ {
        "url": "http://hl7.org/fhir/tools/StructureDefinition/resource-information",
        "valueString": "StructureDefinition:logical"
      } ],
      "isExample": false,
      "reference": {
        "reference": "StructureDefinition/ViewDefinition"
      },
      "description": "A ViewDefinition represents a tabular projection of a FHIR resource, where the columns and inclusion \ncriteria are defined by FHIRPath expressions."
    } ],
    "extension": [ {
      "url": "http://hl7.org/fhir/tools/StructureDefinition/ig-internal-dependency",
      "valueCode": "hl7.fhir.uv.tools#0.2.0"
    } ],
    "parameter": [ {
      "code": {
        "code": "copyrightyear",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "2023+"
    }, {
      "code": {
        "code": "releaselabel",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "release"
    }, {
      "code": {
        "code": "excludettl",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "path-test",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "tests"
    }, {
      "code": {
        "code": "autoload-resources",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/capabilities"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/examples"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/extensions"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/models"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/operations"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/profiles"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/resources"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/vocabulary"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/maps"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/testing"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/history"
    }, {
      "code": {
        "code": "path-resource",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "fsh-generated/resources"
    }, {
      "code": {
        "code": "path-pages",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "template/config"
    }, {
      "code": {
        "code": "path-pages",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input/images"
    }, {
      "code": {
        "code": "path-liquid",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "template/liquid"
    }, {
      "code": {
        "code": "path-liquid",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "input/liquid"
    }, {
      "code": {
        "code": "path-qa",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "temp/qa"
    }, {
      "code": {
        "code": "path-temp",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "temp/pages"
    }, {
      "code": {
        "code": "path-output",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "output"
    }, {
      "code": {
        "code": "path-tx-cache",
        "system": "http://hl7.org/fhir/guide-parameter-code"
      },
      "value": "input-cache/txcache"
    }, {
      "code": {
        "code": "path-suppressed-warnings",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "input/ignoreWarnings.txt"
    }, {
      "code": {
        "code": "path-history",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "https://sql-on-fhir.org/ig/history.html"
    }, {
      "code": {
        "code": "template-html",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "template-page.html"
    }, {
      "code": {
        "code": "template-md",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "template-page-md.html"
    }, {
      "code": {
        "code": "apply-contact",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-context",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-copyright",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-jurisdiction",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-license",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-publisher",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-version",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "apply-wg",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "active-tables",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "fmm-definition",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "http://hl7.org/fhir/versions.html#maturity"
    }, {
      "code": {
        "code": "propagate-status",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "excludelogbinaryformat",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    }, {
      "code": {
        "code": "tabbed-snapshots",
        "system": "http://hl7.org/fhir/tools/CodeSystem/ig-parameters"
      },
      "value": "true"
    } ]
  },
  "date": "2024-10-09T15:18:18+10:00",
  "publisher": "SQL on FHIR Working Group",
  "fhirVersion": [ "5.0.0" ],
  "license": "CC0-1.0",
  "jurisdiction": [ {
    "coding": [ {
      "code": "001",
      "system": "http://unstats.un.org/unsd/methods/m49/m49.htm",
      "display": "World"
    } ]
  } ],
  "dependsOn": [ {
    "id": "hl7tx",
    "uri": "http://terminology.hl7.org/ImplementationGuide/hl7.terminology",
    "version": "6.0.2",
    "extension": [ {
      "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-dependency-comment",
      "valueMarkdown": "Automatically added as a dependency - all IGs depend on HL7 Terminology"
    } ],
    "packageId": "hl7.terminology.r5"
  }, {
    "id": "hl7ext",
    "uri": "http://hl7.org/fhir/extensions/ImplementationGuide/hl7.fhir.uv.extensions",
    "version": "5.1.0",
    "extension": [ {
      "url": "http://hl7.org/fhir/tools/StructureDefinition/implementationguide-dependency-comment",
      "valueMarkdown": "Automatically added as a dependency - all IGs depend on the HL7 Extension Pack"
    } ],
    "packageId": "hl7.fhir.uv.extensions.r5"
  } ],
  "name": "SQLonFHIR",
  "type": null,
  "experimental": null,
  "resourceType": "ImplementationGuide",
  "title": "SQL on FHIR",
  "package_version": "2.0.0",
  "status": "draft",
  "id": "8d663586-519c-4812-aaf2-fb71d7ce94d3",
  "kind": null,
  "url": "https://sql-on-fhir.org/ig/ImplementationGuide/org.sql-on-fhir.ig",
  "version": "2.0.0",
  "packageId": "org.sql-on-fhir.ig",
  "contact": [ {
    "name": "SQL on FHIR Working Group",
    "telecom": [ {
      "value": "https://sql-on-fhir.org",
      "system": "url"
    } ]
  } ]
}