Search



Versions Compared

Key

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

...

An

Gloss
PreSpacefalse
tOrdered reference set
is an Integer
Gloss
PreSpacefalse
tComponent
Gloss
PreSpacefalse
treference set
is used to represent ordered lists and alternative hierarchies. Its structure is shown in the following table.


Caption label
CapIdordered-reference-set-data-structure
CapTypeTable
Ordered reference set - Data structure


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
PreSpacefalse
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
PreSpacefalse
treference set member
became the current version.

The current version of this

Gloss
PreSpacefalse
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
PreSpacefalse
treference set member
as at the specified
Specref
RefType(field)
teffectiveTime
.

If

Specref
RefType(field)
tactive
= 1 (true) the
Gloss
PreSpacefalse
treference set member
is part of the current version of the set, if
Specref
RefType(field)
tactive
= 0 (false) the
Gloss
PreSpacefalse
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
PreSpacefalse
tSNOMED CT module
that contains this
Gloss
PreSpacefalse
treference set member
as at the specified
Specref
RefType(field)
teffectiveTime
.

The value must be a

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

Specref
RefType(field)
trefsetId

Specref
RefType(data type)
tSCTID

Identifies the

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

In this case, set to a

Gloss
PreSpacefalse
tsubtype
of
Concept
t447258008|Ordered type reference set|

Specref
RefType(field)
treferencedComponentId

Specref
RefType(data type)
tSCTID

The identifier of a

Gloss
PreSpacefalse
tSNOMED CT component
that is included in the ordered list of alternative hierarchy.

Specref
RefType(field)
torder

Integer

Specifies the sort

Specref
RefType(field)
torder
of the list. The list is ordered by applying an ascending sort of the
Specref
RefType(field)
torder
value.

The value of

Specref
RefType(field)
torder
=1 represents the highest priority. A value of '0' is not allowed. Duplicate values are permitted and the sort order between two members with the same order value is not defined.

If the

Specref
RefType(field)
tlinkedToId
value is not 0, sorting occurs within subgroups that share the same
Specref
RefType(field)
tlinkedToId
.

Note: The name "order" is a reserved word in some database environments. Please consider this when using this column.

Specref
RefType(field)
tlinkedToId

Specref
RefType(data type)
tSCTID

The identifier of a

Gloss
PreSpacefalse
tSNOMED CT component
that acts as a grouper or hierarchy node, collecting together a subgroup from within the list.

This field either enables

Gloss
PreSpacefalse
treference set member
linked into a number of subgroups. These subgroups can be nested allowing representation of alternative hierarchies.

To link members into a subgroup, all components in the same subgroup should reference the same

Gloss
PreSpacefalse
tcomponent
. This can either be a component that represents the name of that subgroup or the first member of the subgroup. In the latter case, the first row of each subgroup will contain the same identifier in
Specref
RefType(field)
treferencedComponentId
and
Specref
RefType(field)
tlinkedToId
and with
Specref
RefType(field)
torder
=1.

To link a number of

Gloss
PreSpacefalse
tchildren
Gloss
PreSpacefalse
tconcepts
to a single parent
Gloss
PreSpacefalse
tconcept
, one member record should exist per
Gloss
PreSpacefalse
tchild
, with the
Specref
RefType(field)
treferencedComponentId
field referencing the parent and this field referencing the
Gloss
PreSpacefalse
tchild
Gloss
PreSpacefalse
tconcept
. The
Specref
RefType(field)
torder
field is then used to
Specref
RefType(field)
torder
the
Gloss
PreSpacefalse
tchildren
Gloss
PreSpacefalse
tconcepts
under the parent
Gloss
PreSpacefalse
tconcept
.

For ordered lists that do not require grouping or hierarchical arrangement the value of

Specref
RefType(field)
tlinkedToId
should be the digit zero (0).

...

The following metadata in the "Foundation metadata

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

Caption label
CapIdordered-references-sets-in-the-metadata-hierarchy
CapTypeTable
Ordered References Sets in the Metadata Hierarchy

Refset spec table
Sizefs7
RefsetTypeOrdered Reference Set

...

The tables below show the descriptor that defines the structure of the

Concept
t447258008|Ordered type reference set|
ShowFormatinline
pattern and an example of descriptor for a 
Gloss
PreSpacefalse
treference set
that follows this pattern.

Caption label
CapIdrefset-descriptor-rows-for-ordered-reference-set
CapTypeTable
Refset Descriptor rows for Ordered Reference Set


refsetId

referencedComponentId

attributeDescription

attributeType

attributeOrder

Concept
t900000000000456007|Reference set descriptor|

Concept
t447258008|Ordered type reference set|

Concept
t449608002|Referenced component|

Concept
t900000000000460005|Component type|

0

 

Concept
t900000000000456007|Reference set descriptor|
 

Concept
t447258008|Ordered type reference set|

Concept
t447255006|Priority order reference set attribute|

Concept
t900000000000478000|Unsigned integer|

1

Concept
t900000000000456007|Reference set descriptor|

Concept
t447258008|Ordered type reference set|

Concept
t447257003|"Linked to" reference set attribute|

Concept
t900000000000460005|Component type|

2

Example Data


Caption label
CapIdsample-content-for-an-ordered-reference-set
CapTypeTable
Sample Content for an Ordered Reference Set


refsetId

referencedComponentId (Referenced component)

order (Attribute order)

linkedTo ("Linked to" reference set attribute)

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

1

Concept
t123946008|Disorder by body site|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

2

Concept
t370117001|Disorder of system|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

3

Concept
t278919001|Communication disorder|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

4

Concept
t74732009|Mental disorder|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

5

Concept
t39898005|Sleep disorder|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

6

Concept
t370118006|Disorder of pregnancy / labor / delivery / puerperium|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

7

Concept
t370119003|Fetal / neonatal / perinatal disorder|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

8

Concept
t370120009|Endocrine / nutritional / metabolic disorder|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

9

Concept
t370121008|Disorder of blood / lymphatics / immune system|

Concept
t447570008|SNOMED CT top level navigation hierarchy ordered reference set|

Concept
t64572001|Disease|

10

Concept
t281867008|Multisystem disorder|

...