Search



Versions Compared

Key

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

...

Field

Data type

Purpose

Part of Primary Key

Specref
tid

A 128 bit unsigned Integer, uniquely identifying this reference set member.

Different versions of a reference set member share the same id but have different effectiveTime. This allows a reference set member to be modified or made inactive (i.e. removed from the active set) at a specified time.

NOYES (Full /Snapshot)

Specref
teffectiveTime

The inclusive date or time at which this version of the identified reference set member became the current version.

Note: In distribution files the effectiveTime should follow the short ISO date format (YYYYMMDD) and should not include the hours, minutes, seconds or timezone indicator.

The current version of this reference set member at time T is the version with the most recent effectiveTime prior to or equal to time T .

YES

YES (Full)

Optional (Snapshot) 

Specref
tactive

The state of the identified reference set member as at the specified effectiveTime .

If active = 1 (true) the reference set member is part of the current version of the set, if active = 0 (false) the reference set member is not part of the current version of the set.

YESNO

Specref
tmoduleId

Identifies the SNOMED CT module that contains this reference set member as at the specified effectiveTime .

The value must be a subtype of 900000000000443000 | Module (core metadata concept)| within the metadata hierarchy.

YESNO

Specref
trefsetId

Identifies the reference set to which this reference set member belongs.

In this case, a subtype descendant of: 1292992004 | Component annotation with string value reference set (foundation metadata concept) |

NONO

Specref
treferencedComponentId

A reference to the SNOMED CT component to be included in the reference set.

The component (concept, description, relationship) to which the annotation applies.

NONO

Specref
tlanguageDialectCode

languageCode

String

Specifies the language of the Annotation text using the two character ISO-639-1 code. Note that this specifies a language level only, not a country code.  However, a dialect or country codecan also be included by following the standard RFC 5646, although this is an optional inclusion.  The new concept 1304275002 |Language or dialect code (foundation metadata concept)| has been added for the metadata for this refset.

NOTE:  This field should be blank wherever a language code is not applicable, but never NULL.

YES

NO

Specref
ttypeId

Any descendant of1295447006 |Annotation attribute (attribute)|  minus 1295449009 |Additional relationship attribute (attribute)| and its descendantin the attribute hierarchy. 

NONO

Specref
tvalue

String

The Annotation text itself, with a maximum size of 32Kb, represented in UTF-8 encoding.

YESNO

...

refsetId

referencedComponentId

attributeDescription

attributeTypeattributeOrder

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

900000000000460005 |

Concept type component

Component type (foundation metadata concept)|

excluding the postcoordinated expression and rerfset member type components

0

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

1296895003 1304275002 |Language or dialect code (foundation metadata concept)|

900000000000465000 |String (foundation metadata concept)|

1

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

1296892000 |Annotation type (foundation metadata concept)|

900000000000461009 |Concept type component|

2

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

900000000000519001 |Annotation value (foundation metadata concept)|

900000000000465000 |String (foundation metadata concept)|

3

...

id

effectiveTime

active

moduleId

refsetId

referencedComponentId

languageCodelanguageDialectCode

annotationTypeId

Annotation

00000000-1111-2222-3333-444444444444

20240131

1

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

784371009 |Huntington disease-like 1 (disorder)|

en

|Attribution (attribute)|https://www.orpha.net/

"Inserm Orphanet"

00000000-1111-2222-3333-444444444444

20240131

1

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

103741018 |Radius, NOS|

en

|Inactivation note (attribute)|

"Non-conformance to the description convention for structure concept. The suffix NOS for classification should not be used."

00000000-1111-2222-3333-444444444444

20240131

1

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

425523004 |Entire bone organ of spine (body structure)|

en

|Inactivation note (attribute)|

"No suitable replacement concept identified"

00000000-1111-2222-3333-444444444444

20240131

1

1292992004 | Component annotation with string value reference set (foundation metadata concept) |

370137002 |Extension Namespace {1000000} (namespace concept)|

en

|Namespace owner (attribute)|

NHS Digital (UK)

...