...
Purpose
A
| Scg expression |
|---|
ShowParts | id+term| Concept |
|---|
| t | 900000000000512005|Query |
|---|
|
allows a serialised query to represent the membership of a subset of
| Gloss |
|---|
| PreSpace | false |
|---|
| t | SNOMED CT components |
|---|
|
. A
query contained in the
| Gloss |
|---|
| PreSpace | false |
|---|
| t | reference set |
|---|
|
is run against the content of
to produce a subset of
,
| Gloss |
|---|
| PreSpace | false |
|---|
| t | descriptions |
|---|
|
or
| Gloss |
|---|
| PreSpace | false |
|---|
| t | relationships |
|---|
|
. The query is referred to an intensional definition of the subset. It can be run against future releases of
to generate an updated set of subset members.
The members of the resulting subset may also be represented in an enumerated form as a
| Gloss |
|---|
| PreSpace | false |
|---|
| t | Simple reference set |
|---|
|
. An enumerated representation of a subset is referred to as an extensional definition.
...
Data structure
A
| Gloss |
|---|
| PreSpace | false |
|---|
| t | Query specification reference set |
|---|
|
is a | Specref |
|---|
| RefType | (data type) |
|---|
| t | String |
|---|
|
| Gloss |
|---|
| PreSpace | false |
|---|
| t | reference set |
|---|
|
containing ...
A is a String (data type) containing query (field) that represent intensional definitions of subsets of
. The result of running the
query is an extensional representation of the subset of
which can be represented as a
| Gloss |
|---|
| PreSpace | false |
|---|
| t | Simple reference set |
|---|
|
. Its structure is shown in the following table.
...
...
...
Field
...
Data type
...
Purpose
...
id (field)
...
UUID (data type)
...
A 128 bit unsigned Integer (data type), uniquely identifying this .
Different versions of a reference set member share the same id (field) but have different effectiveTime (field). This allows a reference set member to be modified or made active (field) (i.e. removed from the active set) at a specified time.
...
effectiveTime (field)
...
Time (data type)
...
The inclusive date or time at which this version of the identified became the current version.
The current version of this at time T is the version with the most recent effectiveTime (field) prior to or equal to time T .
...
active (field)
...
Boolean (data type)
...
The state of the identified as at the specified effectiveTime (field) .
If active (field) = 1 (true) the is part of the current version of the set, if active (field) = 0 (false) the is not part of the current version of the set.
...
moduleId (field)
...
SCTID (data type)
...
Identifies the that contains this as at the specified effectiveTime (field) .
The value must be a of
| Scg expression |
|---|
|
900000000000443000|Module (core metadata concept)| |
within the metadata . ...
refsetId (field)
...
SCTID (data type)
...
Identifies the to which this belongs.
In this case, set to a subtype of
| Scg expression |
|---|
|
900000000000512005|Query specification type| |
...
referencedComponentId (field)
...
SCTID (data type)
...
The identifier ( refsetId (field)) of the for which members are to be generated.
...
query
...
String (data type)
...
The serialised query that can be used to (re-)generate the members.
A standard syntax for use in these queries is currently under development and is due for publication in late 2014.
| Caption label |
|---|
| CapId | query-specification-reference-set-data-structure |
|---|
| CapType | Table |
|---|
|
Query specification reference set - Data structure |
| Refset spec table |
|---|
| Size | fs7 |
|---|
| RefsetType | Query Specification Reference Set |
|---|
|
|
Metadata
The following metadata in the "Foundation metadata
" supports this | Gloss |
|---|
| PreSpace | false |
|---|
| t | reference set |
|---|
|
:| Caption label |
|---|
| CapId | hierarchy-of-foundation-metadata-concept |
|---|
| CapType | Table |
|---|
|
Hierarchy of Foundation metadata concept |
| Scg expression |
|---|
|
900000000000454005 |Foundation metadata concept|
900000000000455006 |Reference set|
900000000000512005 |Query specification type|
900000000000513000 |Simple query specification|
|
| Excerpt Include |
|---|
| REUSE:Notes on Reference Set Example Tables |
|---|
| REUSE:Notes on Reference Set Example Tables |
|---|
| nopanel | true |
|---|
|
Descriptor Template
...
The following metadata in the "Foundation metadata " supports this :
...
| Scg expression |
|---|
|
900000000000454005|Foundation metadata concept| |
...
| Scg expression |
|---|
|
900000000000455006|Reference set| |
...
| Scg expression |
|---|
|
900000000000512005|Query specification type| |
...
| Scg expression |
|---|
|
900000000000513000|Simple query specification| |
Figure 14. Hierarchy of Foundation metadata concept
...
The table below shows the descriptor that defines the structure of the
scg-expressionShowPartsid+term | pattern.
...
...
...
...
...
...
...
| query-specification-reference-sets | | CapType | Table |
|---|
|
Descriptor Template for Query Specification Reference Sets |
...
refsetId | referencedComponentId | attributeDescription | attributeType | attributeOrder |
|---|
| | Scg expression |
|---|
ShowParts | id+term| Concept |
|---|
| t | 900000000000456007|Reference |
|---|
|
|
| Scg expression |
|---|
ShowParts | id+term scg-expressionShowPartsid+term | | 900000000000514006|Generated |
|
|
scg-expressionShowPartsid+term | | 900000000000461009|Concept |
|
|
| | Scg expression |
|---|
ShowParts | id+term| Concept |
|---|
| t | 900000000000456007|Reference |
|---|
|
|
scg-expressionShowPartsid+term | | Scg expression |
|---|
ShowParts | id+term| Concept |
|---|
| t | 900000000000515007|Query| |
|---|
|
|
| Scg expression |
|---|
ShowParts | id+term| Concept |
|---|
| t | 900000000000465000|String| |
|---|
|
| 1 |
Note: The tables above omit the initial four columns of data present in the release file. These follow the standards versioning pattern id (field), effectiveTime (field), active (field), active (field). Additionally, to aid understanding, the tables above also show the from one of the associated with each of the identified . The release file only contains the .
...
Example Data
In the example below, "serialised query 1" is a text string that can be used to generate members for | Gloss |
|---|
| PreSpace | false |
|---|
| t | Reference set |
|---|
|
1, which is a simple member
| Gloss |
|---|
| PreSpace | false |
|---|
| t | reference set |
|---|
|
(without any additional fields within its member records).
...
| Caption label |
|---|
| CapId | example-rows-from-query-specification-reference-set |
|---|
| CapType | Table |
|---|
|
Example rows from Query Specification Reference Set |
...
...
refsetId | referencedComponentId | query |
|---|
| Scg expression |
|---|
ShowParts | term| Concept |
|---|
| t | 900000000000513000|Simple |
|---|
|
|
| Scg expression |
|---|
ShowParts | term Serialized text of the query ... | ...
The specification of the query has yet to be defined / selected, but it should be capable of:
- Selecting using primary fields, subsumption testing, , relationshipGroup (field), set operators ( , , excludes), and lexical query ;
- Selecting , and using similar mechanisms;
- Calculation of values for the 's extended fields. Identifying the version of the syntax and any syntax variations.
- Queries that support definitions for terminologies other than should also be supported. For example, queries to link or include codes in ICD-10, ICD-11, ICPC and .
...
| Scg expression |
|---|
< 19829001 |disorder of lung|: 116676008 |associated morphology| = << 79654002 |edema| |
|
References
- See Expression Constraint Language - Specification and Guide for details of the language used to specify intensional definitions of concept subsets.