Search



Versions Compared

Key

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

...

Purpose

A

Concept
t900000000000512005|Query specification type reference set|
allows a serialised query to represent the membership of a subset of
Gloss
PreSpacefalse
tSNOMED CT components
. A query contained in the
Gloss
PreSpacefalse
treference set
is run against the content of
Gloss
PreSpacefalse
tSNOMED CT
to produce a subset of
Gloss
PreSpacefalse
tconcepts
,
Gloss
PreSpacefalse
tdescriptions
or
Gloss
PreSpacefalse
trelationships
. The query is referred to an intensional definition of the subset. It can be run against future releases of
Gloss
PreSpacefalse
tSNOMED 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

Gloss
PreSpacefalse
tSimple reference set
. An enumerated representation of a subset is referred to as an extensional definition.

...

...

Data structure

A

Gloss
PreSpacefalse
tQuery specification reference set
is a
Specref
RefType(data type)
tString
 
Gloss
PreSpacefalse
treference set
containing
Specref
RefType(field)
tquery
that represent intensional definitions of subsets of
Gloss
PreSpacefalse
tcomponents
. The result of running the query is an extensional representation of the subset of
Gloss
PreSpacefalse
tcomponents
which can be represented as a
Gloss
PreSpacefalse
tSimple reference set
. Its structure is shown in the following table.

Field

Data type

Purpose

Specref
RefType(field)
tid

Specref
RefType(data type)
tUUID

A 128 bit unsigned

Specref
RefType(data type)
tInteger
, uniquely identifying this
Gloss
treference set member
.

Different versions of a reference set member share the same

Specref
RefType(field)
tid
but have different
Specref
RefType(field)
teffectiveTime
. This allows a reference set member to be modified or made
Specref
RefType(field)
tactive
(i.e. removed from the active set) at a specified time.

Specref
RefType(field)
teffectiveTime

Specref
RefType(data type)
tTime

The inclusive date or time at which this version of the identified

Gloss
treference set member
became the current version.

The current version of this

Gloss
treference set member
at time T is the version with the most recent
Specref
RefType(field)
teffectiveTime
prior to or equal to time T .

Specref
RefType(field)
tactive

Specref
RefType(data type)
tBoolean

The state of the identified

Gloss
treference set member
as at the specified
Specref
RefType(field)
teffectiveTime
.

If

Specref
RefType(field)
tactive
= 1 (true) the
Gloss
treference set member
is part of the current version of the set, if
Specref
RefType(field)
tactive
= 0 (false) the
Gloss
treference set member
is not part of the current version of the set.

Specref
RefType(field)
tmoduleId

Specref
RefType(data type)
tSCTID

Identifies the

Gloss
tSNOMED CT module
that contains this
Gloss
treference set member
as at the specified
Specref
RefType(field)
teffectiveTime
.

The value must be a

Gloss
tsubtype
of
Concept
t900000000000443000|Module (core metadata concept)|
within the metadata
Gloss
thierarchy
.

Specref
RefType(field)
trefsetId

Specref
RefType(data type)
tSCTID

Identifies the

Gloss
treference set
to which this
Gloss
treference set member
belongs.

In this case, set to a subtype of

Concept
t900000000000512005|Query specification type|

Specref
RefType(field)
treferencedComponentId

Specref
RefType(data type)
tSCTID

The identifier (

Specref
RefType(field)
trefsetId
) of the
Gloss
treference set
for which members are to be generated.

query

Specref
RefType(data type)
tString

The serialised query that can be used to (re-)generate the

Gloss
treference set
members.

A standard syntax for use in these queries is currently under development and is due for publication in late 2014.

...

The following metadata in the "Foundation metadata

Gloss
tconcept
"
Gloss
thierarchy
supports this
Gloss
treference set
:

...

Concept
t900000000000454005|Foundation metadata concept|


Caption label
CapIdquery-specification-reference-set-data-structure
CapTypeTable
Query specification reference set - Data structure


Refset spec table
Sizefs7
RefsetTypeQuery Specification Reference Set

Metadata

The following metadata in the "Foundation metadata

Gloss
PreSpacefalse
tconcept
"
Gloss
PreSpacefalse
thierarchy
supports this
Gloss
PreSpacefalse
treference set
:

Caption label
CapIdhierarchy-of-foundation-metadata-concept
CapTypeTable
Hierarchy of Foundation metadata concept


Scg expression
Borderridge

  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
nopaneltrue

Descriptor Template

...

Concept
t900000000000455006|Reference set|

...

Concept
t900000000000512005|Query specification type|

...

  • Concept
    t900000000000513000|Simple query specification|

...

The table below shows the descriptor that defines the structure of the

Concept
t900000000000512005|Query specification type reference set|
pattern.


Caption label
CapIddescriptor-template-for-query-specification-reference-sets
CapTypeTable
Descriptor Template for Query Specification Reference Sets


refsetId

referencedComponentId

attributeDescription

attributeType

attributeOrder

 

Concept
t900000000000456007|Reference set descriptor|

Concept
t900000000000512005|Query specification type reference set|

Concept
t900000000000514006|Generated reference set|

Concept
t900000000000461009|Concept type component|

0

 

Concept
t900000000000456007|Reference set descriptor|

Concept
t900000000000512005|Query specification type reference set|

Concept
t900000000000515007|Query|

Concept
t900000000000465000|String|

1

 

Note: The tables above omit the initial four columns of data present in the release file. These follow the standards versioning pattern

Specref
RefType(field)
tid
,
Specref
RefType(field)
teffectiveTime
,
Specref
RefType(field)
tactive
,
Specref
RefType(field)
tactive
. Additionally, to aid understanding, the tables above also show the
Gloss
tterm
from one of the
Gloss
tdescriptions
associated with each of the identified
Gloss
tconcept
. The release file only contains the
Gloss
tidentifier
.

...

Example Data

In the example below, "serialised query 1" is a text string that can be used to generate members for

Gloss
PreSpacefalse
tReference set
1, which is a simple member
Gloss
PreSpacefalse
treference set
(without any additional fields within its member records).


Caption label
CapIdexample-rows-from-query-specification-reference-set
CapTypeTable
Example rows from Query Specification Reference Set


refsetId

referencedComponentId

query

Concept
t900000000000513000|Simple query specification|

Concept
t|Target reference set|

Serialized text of the query ...

...

The specification of the query

Gloss
tlanguage
has yet to be defined / selected, but it should be capable of:

  • Selecting
    Gloss
    tconcepts
    using primary fields, subsumption testing,
    Gloss
    trelationships
    ,
    Specref
    RefType(field)
    trelationshipGroup
    , set operators (
    Gloss
    tunion
    ,
    Gloss
    tintersection
    , excludes), and lexical query ;
  • Selecting
    Gloss
    tdescriptions
    ,
    Gloss
    trelationships
    and
    Gloss
    treference sets
    using similar mechanisms;
  • Calculation of values for the
    Gloss
    treference set
    's extended fields. Identifying the version of the syntax and any
    Gloss
    tlanguage
    syntax variations.
  • Queries that support definitions for terminologies other than
    Gloss
    tSNOMED CT
    should also be supported. For example, queries to link or include codes in ICD-10, ICD-11, ICPC and
    Gloss
    tLOINC
    .

...

Gloss
tSNOMED CT concepts


Scg expression
< 19829001 |disorder of lung|: 116676008 |associated morphology| = << 79654002 |edema|


References