Page History
...
Field | Data type | Purpose | Part of Primary Key | |||||||
| 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. | NO | YES (Full /Snapshot) | |||||||
| 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) | |||||||
| 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. | YES | NO | |||||||
| 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. | YES | NO | |||||||
| 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) | | NO | NO | |||||||
| A reference to the SNOMED CT component to be included in the reference set. The component (concept, description, relationship) to which the annotation applies. | NO | NO | |||||||
| 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 | |||||||
| Any descendant of1295447006 |Annotation attribute (attribute)| minus 1295449009 |Additional relationship attribute (attribute)| and its descendantin the attribute hierarchy. | NO | NO | |||||||
| String | The Annotation text itself, with a maximum size of 32Kb, represented in UTF-8 encoding. | YES | NO |
...
refsetId | referencedComponentId | attributeDescription | attributeType | attributeOrder |
1292992004 | Component annotation with string value reference set (foundation metadata concept) | | 900000000000518009 |Annotated component|900000000000461009 | 900000000000460005 | Concept type componentComponent 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) |
...