Validation Results for SQLonFHIR

Generated Thu Aug 13 15:46:22 UTC 2026, FHIR version 6.0.0-ballot5 for hl7.fhir.uv.sql-on-fhir#3.0.0-ballot (canonical = http://hl7.org/fhir/uv/sql-on-fhir (history)). See Full QA Report & IP

Quality Checks
Publisher Version:	IG Publisher Version: v2.3.2
Publication Code:	sql-on-fhir . PackageId = hl7.fhir.uv.sql-on-fhir, Canonical = http://hl7.org/fhir/uv/sql-on-fhir
Realm Check for UV:	n/a
Language Info:	Stated Languages: n/a. IG Resource Lang: en. 1 of 50 (2%) of resources have a language. Population Policy: NONE
Publication Request:	package-id hl7.fhir.uv.sql-on-fhir version 3.0.0-ballot path http://hl7.org/fhir/uv/sql-on-fhir/3.0.0-202609-ballot Pub-Mode working release status ballot Release-Label STU 3 Ballot Sequence (Group) STU 3 desc A specification for defining portable views of FHIR data that can be easily queried using tools such as SQL. first true category Infrastructure title SQL on FHIR introduction A specification for defining portable views of FHIR data that can be easily queried using tools such as SQL. ci-build http://build.fhir.org/ig/HL7/sql-on-fhir RelatedIgs (None Found) This IG has never been published Proposed path for this publication should usually be the canonical with the version or sequence appended and then some kind of label (typically '-snapshot')
Supressed Messages:	34 Suppressed Issues
Dependency Checks:	Package Version FHIR Canonical Web Base Comment hl7.fhir.uv.sql-on-fhir 3.0.0-ballot R6 http://hl7.org/fhir/uv/sql-on-fhir hl7.terminology.r5 7.3.0 M R5 http://terminology.hl7.org http://terminology.hl7.org/7.3.0 FHIR Version Mismatch hl7.fhir.uv.extensions.r5 5.3.0 M R5 http://hl7.org/fhir/extensions http://hl7.org/fhir/extensions/5.3.0 FHIR Version Mismatch hl7.terminology.r5 7.1.0 O R5 http://terminology.hl7.org http://terminology.hl7.org/7.1.0 FHIR Version Mismatch. Latest Release is 7.3.0 hl7.fhir.uv.extensions.r5 5.2.0 O R5 http://hl7.org/fhir/extensions http://hl7.org/fhir/extensions/5.2.0 FHIR Version Mismatch. Latest Release is 5.3.0 hl7.fhir.uv.extensions 5.3.0 M R5 http://hl7.org/fhir/extensions http://hl7.org/fhir/extensions/5.3.0 FHIR Version Mismatch hl7.terminology.r5 7.1.0 O R5 http://terminology.hl7.org http://terminology.hl7.org/7.1.0 FHIR Version Mismatch (as above). Latest Release is 7.3.0 hl7.fhir.uv.tools.r5 1.1.2 M R5 http://hl7.org/fhir/tools http://hl7.org/fhir/tools/1.1.2 Internal Dependency. FHIR Version Mismatch Templates: hl7.fhir.uv.sql-on-fhir.ig-template#0.1.0 -> hl7.fhir.template#current -> hl7.base.template#current -> fhir2.base.template#current
Related IGs:	n/a
Dependent IGs:	no references
Global Profiles:	(none declared)
Terminology Server(s):	https://tx.fhir.org/r5 (details)
HTA Analysis:	no Non-HL7 references found
R5 Dependencies:	(none)
Draft Dependencies:	hl7.fhir.uv.extensions#5.3.0: SDImplements (3 uses)
Modifier Extensions:	(none)
Previous Version Comparison:
IPA Comparison:	n/a
IPS Comparison:	n/a
Validation Flags:	On: autoLoad; Off: hintAboutNonMustSupport, anyExtensionsAllowed, checkAggregation, showReferenceMessages, noExperimentalContent, displayWarnings
Summary:	errors = 25, warn = 21, info = 1, broken links = 0, pinned = n/a. Show Message Ids

n/a Show Validation Information

fsh-generated/resources/ImplementationGuide-hl7.fhir.uv.sql-on-fhir.json Show Validation Information (1)

fsh-generated/resources/StructureDefinition-SQLQuery.json Show Validation Information (1)

fsh-generated/resources/StructureDefinition-SQLView.json Show Validation Information (1)

input/resources/viewdefinition/StructureDefinition-ShareableViewDefinition.xml Show Validation Information (1)

input/resources/viewdefinition/StructureDefinition-TabularViewDefinition.xml Show Validation Information (1)

input/resources/viewdefinition/StructureDefinition-ViewDefinition.xml Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-CodeSystemHierarchy.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-ConditionFlat.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-EncounterFlat.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-PatientAddresses.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-PatientAndContactAddressUnion.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-PatientDemographics.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-PatientNamesWithIndex.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-QuestionnaireResponseItems.json Show Validation Information (1)

input/resources/viewdefinition/ViewDefinition-ShareablePatientDemographics.json Show Validation Information (5)

input/resources/viewdefinition/ViewDefinition-UsCoreBloodPressures.json Show Validation Information (1)

input/resources/viewdefinition/bundle-ViewDefinition-search-params.xml Show Validation Information (1)

Suppressed Messages (Warnings, hints, broken links)

02. ViewDefinition is defined as an additional resource, so the publisher validates SearchParameter.base against the core Version Independent Resource Types (All) value set, which cannot contain a type that is not in the core specification. Inherent to the additional-resource design; see https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %The System URI could not be determined for the code 'ViewDefinition'% (0 uses)
• %was not found in the value set 'Version Independent Resource Types (All)'% (0 uses)

03. The publisher requires every instance of an additional resource to carry a resourceDefinition property naming the versioned canonical of its definition. Adding it would put FHIR tooling metadata into the published ViewDefinition examples and pin the IG version in each of them, so the examples are left as authored; see https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %so must have a resourceDefinition of% (0 uses)

04. ViewDefinition is an additional resource rather than a core FHIR type, so the publisher rejects its use as a StructureDefinition type. Inherent to the additional-resource design; see https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %is not legal because it is not defined in the FHIR specification% (0 uses)

05. ViewDefinition is a canonical resource, but the publisher does not recognize additional resources as canonical when checking Library.relatedArtifact.resource targetProfiles. Inherent to the additional-resource design; see https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %which is not a Canonical Resource (which is required because the Library.relatedArtifact.resource element has the type canonical)% (4 uses)

06. ViewDefinition derives from MetadataResource, so the inherited cnl-1 invariant carries MetadataResource as its source and the publisher reports a mismatch against the deriving profile. Inherent to the additional-resource design; see https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %The invariant cnl-1 defined in the differential must have no source% (1 uses)
• ED_INVARIANT_DIFF_NO_SOURCE (0 uses)

07. These are valid ViewDefinition FHIRPath expressions that the publisher's generic FHIRPath evaluator cannot resolve: %rowIndex is a ViewDefinition constant, and linkId, answer and code are evaluated inside a forEach scope that the evaluator does not apply. See https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %Error evaluating FHIRPath expression: Invalid FHIRPath Constant %rowIndex% (1 uses)
• %Error evaluating FHIRPath expression: The name 'answer' is not valid% (4 uses)
• %Error evaluating FHIRPath expression: The name 'code' is not valid% (1 uses)
• %Error evaluating FHIRPath expression: The name 'linkId' is not valid% (1 uses)

08. This IG targets FHIR 6.0.0-ballot5, but no R6 build of hl7.fhir.uv.extensions, hl7.terminology or hl7.fhir.uv.tools has been released; the registry serves only R5-based versions, so the publisher auto-selects the .r5 variants. Nothing in this repository can resolve the mismatch; see https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/R6.20IGs.20depending.20on.20R5-only.20packages/with/615144821.

• IG_DEPENDENCY_VERSION_ERROR (1 uses)
• IG_DEPENDENCY_VERSION_WARNING (0 uses)
• This IG is for FHIR version% (0 uses)
• This IG is version% (0 uses)

09. The jurisdiction value set is deprecated in the core specification and this message originates there; the jurisdiction values are inherited from the HL7 universal realm conventions and cannot be changed in this IG.

• %Reference to deprecated ValueSet http://hl7.org/fhir/ValueSet/jurisdiction% (0 uses)

10. These code systems are defined in this IG rather than in THO. A TSMG exemption will be sought in the future (first publication).

• %will need to move to THO later during the process% (4 uses)

11. eld-31 is a best-practice recommendation that additional bindings carry a key. Seven of these are on inherited language elements whose additional binding is defined by the core specification without one; the other four are on the content.contentType binding this IG defines on SQLQuery and SQLView, where a key cannot be supplied because binding.additional.key exists in R6 but not in R5, and the publisher processes these Library profiles through the R5 element model and strips it.

• %Constraint failed: eld-31% (11 uses)

12. eld-33 is a best-practice recommendation that flags any binding on an element with more than one bindable type. The bindings on ViewDefinition.versionAlgorithm[x] and the sql-text choice elements are inherited from the R5 base resources and are deliberate.

• %Constraint failed: eld-33% (6 uses)

13. The core mimetypes value set is unbounded and cannot be expanded by any terminology server. The required binding is intentional and is supplemented by an extensible additional binding to the SQL content type codes.

• %Binding http://hl7.org/fhir/ValueSet/mimetypes% (2 uses)

14. The recursive ViewDefinition.select contentReference produces multiple anchors with the same name in the generated narrative, so the auto-generated hyperlink matches more than one target. This is a rendering artifact of the logical model.

• %Hyperlink '#ViewDefinition.select' at 'div/table/tr/td/a' for 'select' resolves to multiple targets% (1 uses)

15. These template-provided HTML fragments (IP statements, dependency table, globals table) are generated by the template but are not referenced by any page in this IG's layout.

• %is not included anywhere in the produced implementation guide% (3 uses)

16. The CodeSystem fhirpath-types was incorrectly tagged as experimental: https://jira.hl7.org/browse/FHIR-58168

• %Reference to experimental CodeSystem http://hl7.org/fhir/CodeSystem/fhirpath-types|6.0.0-ballot5 (27 uses)
• MSG_EXPERIMENTAL (0 uses)

17. FHIR R6 Additional Resource mechanisms are still WIP

• %The System URI could not be determined for the code 'ViewDefinition' in the ValueSet 'http://hl7.org/fhir/ValueSet/version-independent-all-resource-types|6.0.0-ballot5' (0 uses)
• %The value provided ('ViewDefinition') was not found in the value set 'Version Independent Resource Types (All)' (http://hl7.org/fhir/ValueSet/version-independent-all-resource-types|6.0.0-ballot5), and a code is required from this value set (error message = The System URI could not be determined for the code 'ViewDefinition' in the ValueSet 'http://hl7.org/fhir/ValueSet/version-independent-all-resource-types|6.0.0-ballot5'; The provided code '#ViewDefinition' was not found in the value set 'http://hl7.org/fhir/ValueSet/version-independent-all-resource-types|6.0.0-ballot5') (0 uses)
• Terminology_TX_NoValid_16 (0 uses)
• UNABLE_TO_INFER_CODESYSTEM (0 uses)

18. This is a combinations of bugs - Resource definitions must be namespaced in hl7.org/fhir, and publisher is not processing the JSON version of the example additional resource correctly.

• % ViewDefinition: The value for resourceDefinition of 'http://hl7.org/fhir/StructureDefinition/ViewDefinition|3.0.0-ballot' does not match the required value of 'http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/ShareableViewDefinition|3.0.0-ballot'. In addition, this is not an additional resource, and shouldn't have a resourceDefinition at all (1 uses)
• VALIDATION_ADDITIONAL_RESOURCE_NO_WRONG (1 uses)

19. The publisher's built-in ViewDefinition validator does not apply the forEach/forEachOrNull scope when checking column path cardinality, so columns that are single-valued within their forEach scope (e.g. system and code within a forEachOrNull of code.coding) are flagged as potentially multi-valued. False positive with the same root cause as 07; verified against the current example set. See https://chat.fhir.org/#narrow/channel/179219-analytics-on-FHIR/topic/Validation.20errors.20for.20additional.20resources/with/615144653.

• %might return multiple values for the column% (13 uses)

20. Same forEach scoping defect as 19: the text column in the QuestionnaireResponseItems example selects item.text (a string) inside a forEach scope, but the validator resolves the path against the resource root, where text is the Narrative.

• %is a complex type ('Narrative'). This is not supported in some Runners% (1 uses)

21. Message-ID variant of eld-33 (see 12): the binding on ViewDefinition.versionAlgorithm[x] is inherited from the R5 base resources and is deliberate.

• SD_ED_BIND_MULTIPLE_TYPES (1 uses)

22. The ViewDefinition instances in this IG are examples of an additional resource, which the publisher does not associate with the ViewDefinition StructureDefinition as linked examples.

• %contains no explicitly linked examples for this profile% (1 uses)

Errors sorted by type

ED_INVARIANT_DIFF_NO_SOURCE

IG_DEPENDENCY_VERSION_ERROR

MSG_DRAFT

SD_ED_EXPERIMENTAL_BINDING

SD_ED_TYPE_PROFILE_WRONG_TARGET

VALIDATION_ADDITIONAL_RESOURCE_NO_WRONG

VIEWDEFINITION_PATH_ERROR