Search



Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
_c9862d6e-865f-42ec-b039-1faedd870fb5
_c9862d6e-865f-42ec-b039-1faedd870fb5
Purpose

A 900000000000512005 $$ Query specification type reference set $$

Scg expression
ShowPartsid+term
900000000000512005|Query specification type reference set|
allows a serialised query to represent the membership of a subset of SNOMED CT components . A query contained in the reference set is run against the content of SNOMED CT to produce a subset of concepts , descriptions or relationships . The query is referred to an intensional definition of the subset. It can be run against future releases of SNOMED CT to generate an updated set of subset members.

The members of the resulting subset may also be represented in an enumerated form as a Simple reference set . An enumerated representation of a subset is referred to as an extensional definition.

Anchor
_944c2242-eb5c-4dcd-8c98-83134a1869f0
_944c2242-eb5c-4dcd-8c98-83134a1869f0
Data structure

A Query specification reference set is a String reference set containing queries (data type) containing query (field) that represent intensional definitions of subsets of components . The result of running the query is an extensional representation of the subset of components which can be represented as a Simple reference set . Its structure is shown in the following table.

integer reference set member effectiveTimes inactive reference set member reference set member reference set member reference set member reference set member SNOMED CT module reference set member subtype of 900000000000443000 $$ Module (core metadata concept) $$ hierarchy reference set reference set member 900000000000512005 $$ Query specification type $$ SCTID reference set reference set

Anchor
_944c2242-eb5c-4dcd-8c98-83134a1869f0__2
_944c2242-eb5c-4dcd-8c98-83134a1869f0__2
Table 43. Query specification reference set - Data structure

 

 

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
ShowPartsid+term
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
ShowPartsid+term
900000000000512005|Query specification type|

referencedComponentId (field)

SCTID (data type)

referencedComponentId

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.

Anchor
_244489f5-8635-41de-9ee6-7763c3ecbd79
_244489f5-8635-41de-9ee6-7763c3ecbd79
Metadata

The following metadata in the "Foundation metadata concept " hierarchy supports this reference set :

  • Anchor
    _244489f5-8635-41de-9ee6-7763c3ecbd79__5
    _244489f5-8635-41de-9ee6-7763c3ecbd79__5
    Scg expression
    ShowPartsid+term
    900000000000454005
    $$
    |Foundation metadata concept
    $$
    |
    Anchor
    _244489f5-8635-41de-9ee6-7763c3ecbd79__a
    _244489f5-8635-41de-9ee6-7763c3ecbd79__a
    • Scg expression
      ShowPartsid+term
      900000000000455006
      $$
      |Reference set
      $$
      |
      Anchor
      _244489f5-8635-41de-9ee6-7763c3ecbd79__d
      _244489f5-8635-41de-9ee6-7763c3ecbd79__d
      • Scg expression
        ShowPartsid+term
        900000000000512005|Query specification type|
        900000000000512005 $$ Query specification type $$
        Anchor
        _244489f5-8635-41de-9ee6-7763c3ecbd79__7
        _244489f5-8635-41de-9ee6-7763c3ecbd79__7
        • Scg expression
          ShowPartsid+term
          900000000000513000
          $$
          |Simple query specification
          $$
          |

Figure 14. Hierarchy of Foundation metadata concept

Anchor
_451cc169-c8f1-4b1e-93d8-7ae10bd70fe7
_451cc169-c8f1-4b1e-93d8-7ae10bd70fe7
Descriptor template

The table below shows the descriptor that defines the structure of the 900000000000512005 $$ Query specification type reference set $$

Scg expression
ShowPartsid+term
900000000000512005|Query specification type reference set|
pattern.

900000000000465000 $$ String $$

Anchor
_451cc169-c8f1-4b1e-93d8-7ae10bd70fe7__1
_451cc169-c8f1-4b1e-93d8-7ae10bd70fe7__1
Table 44. Descriptor Template for Query Specification Reference Sets

 

 

 

 

refsetId

referencedComponentId

attributeDescription

attributeType

attributeOrder

 

900000000000456007 $$ Reference set descriptor $$

900000000000512005 $$ Query specification type reference set $$

900000000000514006 $$ Generated reference set $$

900000000000461009 $$ Concept type component $$

0

 

Scg expression
ShowPartsid+term
900000000000456007|Reference set descriptor|

Scg expression
ShowPartsid+term
900000000000512005|Query specification type reference set|

Scg expression
ShowPartsid+term
900000000000514006|Generated reference set|

Scg expression
ShowPartsid+term
900000000000461009|Concept type component|

0

 

Scg expression
ShowPartsid+term
900000000000456007|Reference set descriptor|

Scg expression
ShowPartsid+term
900000000000512005|Query specification type reference set|

Scg expression
ShowPartsid+term
900000000000515007|Query|

Scg expression
ShowPartsid+term
900000000000465000|String|

900000000000456007 $$ Reference set descriptor $$

900000000000512005 $$ Query specification type reference set $$

900000000000515007 $$ Query $$

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 , moduleId(field), active (field). Additionally, to aid understanding, the tables above also show the term from one of the descriptions associated with each of the identified concept . The release file only contains the identifier .

Anchor
_270fa207-4075-47c9-92bf-de81d7ba4efd
_270fa207-4075-47c9-92bf-de81d7ba4efd
Example usage

In the example below, "serialised query 1" is a text string that can be used to generate members for Reference set 1, which is a simple member reference set (without any additional fields within its member records).

$$ Target reference set $$

Anchor
_270fa207-4075-47c9-92bf-de81d7ba4efd__f
_270fa207-4075-47c9-92bf-de81d7ba4efd__f
Table 45. Example rows from Query Specification Reference Set

 

 

refsetId

referencedComponentId

query

Scg expression
ShowPartsterm
900000000000513000|Simple query specification|

Scg expression
ShowPartsterm
|Target reference set|

$$ Simple query specification $$

Serialized text of the query ...

Anchor
_9d039496-2686-4abd-9fbb-71013d2c1f44
_9d039496-2686-4abd-9fbb-71013d2c1f44
Query language specification

The specification of the query language has yet to be defined / selected, but it should be capable of:

Note: During 2014 work is underway to develop and pilot a standard approach to representation of queries including queries for generation of subset of SNOMED CT concepts .