Reusable Reference Material

Page tree

Versions Compared

Old Version 1

changes.mady.by.user David Markwell

Saved on

compared with

New Version Current

changes.mady.by.user David Markwell

Saved on

Key

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

Type Specific Notes on Common Attributes

Page properties


id
effectiveTime
active
moduleId
refsetId

In this case, a subtype descendant of:

Concept
t447258008|Ordered type reference set|

referencedComponentIdThe component that is placed in order by this reference set row.


Type Specific Additional Attributes

SpacetrueSpacetrueSpacetrueSpacetrueSpacetrueSpacetrueSpacetrue

Field

Data type

Purpose

Gloss
PreSpacefalse
tMutable
LinkTypesubtle

Part of Primary Key

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.

YESNO

Specref
RefType(field)
tlinkedToId

Specref
RefType(data type)
tSCTID

The identifier of a

Gloss

PreSpace

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

This field either enables

Gloss

PreSpace

false
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

PreSpace

false
tchildren
Gloss

PreSpace

false
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

PreSpace

false
tchild
Gloss
PreSpacefalse
tconcept
. The
Specref
RefType(field)
torder
field is then used to
Specref
RefType(field)
torder
the
Gloss

PreSpace

false
tchildren
Gloss

PreSpace

false
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).

YESNO