Intersection of https://sql-on-fhir.org/ig/StructureDefinition/TabularViewDefinition and https://sql-on-fhir.org/ig/StructureDefinition/TabularViewDefinition

This is the set of resources that conform to both Tabular View Definition (https://sql-on-fhir.org/ig/StructureDefinition/TabularViewDefinition) and Tabular View Definition (https://sql-on-fhir.org/ig/StructureDefinition/TabularViewDefinition).

Structure

NameFlagsCard.TypeDescription & Constraintsdoco
.. ViewDefinition 0..*View Definition
... url 0..1uriCanonical identifier for this view definition, represented as a URI (globally unique)
... identifier 0..1IdentifierAdditional identifier for the view definition
... name C0..1stringName of view definition (computer and database friendly)
sql-name: Name is limited to letters, numbers, or underscores and cannot start with an underscore -- i.e. with a regular expression of: ^[A-Za-z][A-Za-z0-9_]*$ This makes it usable as table names in a wide variety of databases.
... meta 0..1MetaMetadata about the view definition
... status 1..1codedraft | active | retired | unknown
Binding: ?? (required)
... experimental 0..1booleanFor testing purposes, not real usage
... publisher 0..1stringName of the publisher/steward (organization or individual)
... contact 0..*ContactDetailContact details for the publisher
... description 0..1markdownNatural language description of the view definition
... useContext 0..*UsageContextThe context that the content is intended to support
... copyright 0..1markdownUse and/or publishing restrictions
... resource 1..1codeFHIR resource for the ViewDefinition
Binding: ?? (required)
... fhirVersion 0..*codeFHIR version(s) of the resource for the ViewDefinition
Binding: ?? (required)
... constant 0..*BackboneElementConstant that can be used in FHIRPath expressions
ele-1: All FHIR elements must have a @value or children
.... extension 0..*ExtensionAdditional content defined by implementations
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
.... modifierExtension ?!Σ0..*ExtensionExtensions that cannot be ignored even if unrecognized
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
.... name C1..1stringName of constant (referred to in FHIRPath as %[name])
sql-name: Name is limited to letters, numbers, or underscores and cannot start with an underscore -- i.e. with a regular expression of: ^[A-Za-z][A-Za-z0-9_]*$ This makes it usable as table names in a wide variety of databases.
.... value[x] 1..1Value of constant
..... valueBase64Binarybase64Binary
..... valueBooleanboolean
..... valueCanonicalcanonical(Any)
..... valueCodecode
..... valueDatedate
..... valueDateTimedateTime
..... valueDecimaldecimal
..... valueIdid
..... valueInstantinstant
..... valueIntegerinteger
..... valueInteger64integer64
..... valueOidoid
..... valueStringstring
..... valuePositiveIntpositiveInt
..... valueTimetime
..... valueUnsignedIntunsignedInt
..... valueUriuri
..... valueUrlurl
..... valueUuiduuid
... select C1..*BackboneElementA collection of columns and nested selects to include in the view.
sql-expressions: Can only have at most one of `forEach` or `forEachOrNull`.
ele-1: All FHIR elements must have a @value or children
.... extension 0..*ExtensionAdditional content defined by implementations
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
.... modifierExtension ?!Σ0..*ExtensionExtensions that cannot be ignored even if unrecognized
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
.... column C0..*BackboneElementA column to be produced in the resulting table.
ele-1: All FHIR elements must have a @value or children
no-collections: Tabular view columns must not be collections.
primitives-only: Tabular view columns only contain primitive values.
..... extension 0..*ExtensionAdditional content defined by implementations
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
..... modifierExtension ?!Σ0..*ExtensionExtensions that cannot be ignored even if unrecognized
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
..... path 1..1stringFHIRPath expression that creates a column and defines its content
..... name C1..1stringColumn name produced in the output
sql-name: Name is limited to letters, numbers, or underscores and cannot start with an underscore -- i.e. with a regular expression of: ^[A-Za-z][A-Za-z0-9_]*$ This makes it usable as table names in a wide variety of databases.
..... description 0..1markdownDescription of the column
..... collection 0..1booleanIndicates whether the column may have multiple values.
..... type 0..1uriA FHIR StructureDefinition URI for the column's type.
..... tag 0..*BackboneElementAdditional metadata describing the column
ele-1: All FHIR elements must have a @value or children
...... extension 0..*ExtensionAdditional content defined by implementations
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
...... modifierExtension ?!Σ0..*ExtensionExtensions that cannot be ignored even if unrecognized
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
...... name 1..1stringName of tag
...... value 1..1stringValue of tag
.... select 0..*Nested select relative to a parent expression.
.... (Choice of one) 0..1
..... forEach 0..1stringA FHIRPath expression to retrieve the parent element(s) used in the containing select. The default is effectively `$this`.
..... forEachOrNull 0..1stringSame as forEach, but will produce a row with null values if the collection is empty.
.... unionAll 0..*Creates a union of all rows in the given selection structures.
... where 0..*BackboneElementA series of zero or more FHIRPath constraints to filter resources for the view.
ele-1: All FHIR elements must have a @value or children
.... extension 0..*ExtensionAdditional content defined by implementations
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
.... modifierExtension ?!Σ0..*ExtensionExtensions that cannot be ignored even if unrecognized
ele-1: All FHIR elements must have a @value or children
ext-1: Must have either extensions or value[x], not both
.... path 1..1stringA FHIRPath expression defining a filter condition
.... description 0..1stringA human-readable description of the above where constraint.

doco Documentation for this format