SQL on FHIR
3.0.0-ballot - STU 3 Ballot
SQL on FHIR
3.0.0-ballot - STU 3 Ballot
SQL on FHIR, published by HL7 International / FHIR Infrastructure. This guide is not an authorized publication; it is the continuous build for version 3.0.0-ballot built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/HL7/sql-on-fhir/ and changes regularly. See the Directory of published versions
This view acts on the CodeSystem resource to produce a table named "code_system_hierarchy".
The table contains the following columns:
| Name | Fhir Type | SQL Type | Collection | Notes |
|---|---|---|---|---|
| id | string | String | ||
| code | string | String | This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'code' for some inputs |
Selection Rules:
| Item | Coll | Type | Description |
|---|---|---|---|
  code_system_hierarchy | CodeSystem | ||
  Select | |||
   id | getResourceKey()CodeSystem identifier | ||
 Select | |||
  parent_code | codeCode of the parent concept in the hierarchy | ||
| Select | for each concept | ||
| code | codeCode of the child concept |
IG © 2023+ HL7 International / FHIR Infrastructure.
Package hl7.fhir.uv.sql-on-fhir#3.0.0-ballot based on FHIR 6.0.0-ballot5.
Generated
2026-08-13
Links: Table of Contents |
QA Report
| Version History |
|
Propose a change