Purpose
An 733618005 | Ordered association type reference set (foundation metadata concept)| can be used to specify ordered associations between different components. These can be used to specify several interrelated subsets of components and to define alternative hierarchies for navigation while searching for an appropriate conceptor description.
Data structure
An Ordered association reference setis a component integerreference setthat is used to represent ordered lists of associations and alternative hierarchies. Its structure is shown in the following table.
Field | Data type | Purpose | Part of Primary Key | |
id | 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 active (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 memberbecame the current version. The current version of this reference set memberat 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 memberas at the specified effectiveTime . If active = 1 (true) the reference set memberis part of the current version of the set, if active = 0 (false) the reference set memberis not part of the current version of the set. | YES | NO | ||
Identifies the SNOMED CT modulethat contains this reference set memberas at the specified effectiveTime . The value must be a subtypeof 900000000000443000 | Module (core metadata concept)| within the metadata hierarchy. | YES | NO | ||
Identifies the reference setto which this reference set memberbelongs. In this case, a subtype descendant of 447258008 | Ordered type reference set| . | NO | NO | ||
A reference to the SNOMED CT componentto be included in the reference set. | NO | NO | ||
The identifier of the target componentof the association that acts as a grouper or hierarchy node, collecting together a subgroup from within the list. This field either enables reference set memberlinked 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 component. 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 referencedComponentId and targetComponentId and with order =1. To link a number of childrenconceptsto a single parent concept, one member record should exist per child, with the referencedComponentId field referencing the parent and this field referencing the childconcept. The order field is then used to order the childrenconceptsunder the parent concept. | NO | NO | ||
Specifies the sort order of the list. The list is ordered by applying an ascending sort of the order value. The value of order =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 targetComponentId value is not 0, sorting occurs within subgroups that share the same linkedToId. Note: The name "order" is a reserved word in some database environments. Please consider this when using this column. | YES | NO |
Metadata
The following metadata in the "Foundation metadata concept" hierarchysupports this reference set:
Reference Set Descriptor and Example Data
Notes on the tables used to show descriptors and examples
The reference set example tables on this page have been revised as follows to aid clarity and understanding:
- The first four columns which are present in all release files are not shown. The omitted columns (id, effectiveTime, active, moduleId) are used in the same way in all referenced sets to support identification, versioning and packaging. They do not directly affect the specific features of a particular reference set or reference set type.
- Reference set columns that contain SNOMED CT identifiers are expanded to show details of the concept or description referenced by that identifier. In some cases, the term is shown in the same column using the expression syntax, in other cases an additional column with a name suffix '_term' has been added. In the standard reference set files only the identifier is present in the column and there is no added column for the term. When using reference sets, the term and other details of the component are looked up from the relevant component release files.
Descriptor Template
The tables below show the descriptor that defines the structure of the
447258008
|
Ordered type reference set|
pattern and an example of descriptor for a specific reference setthat follows this pattern.
refsetId | referencedComponentId | attributeDescription | attributeType | attributeOrder |
|---|---|---|---|---|
0 | ||||
1 | ||||
2 |
Example
Ordered association reference sets can be used to specify and display a customized navigation hierarchy. Alternative hierarchical representations of SNOMED CT can support data entry by satisfying the requirements of a specific use case, and addressing some of the challenges of displaying an unordered polyhierarchy (as defined by SNOMED CT's subtype structure). The figure below shows the way a navigation hierarchy is represented. The example reference set contains a set of description components used to describe finger structures. The | All fingers | components is linked to the | Hand |, and the | Thumb | is linked to the | All fingers component | The | Thumb | is placed first because it has the order value 1. Similarly, the components for | Second finger |, | Third finger |, | Fourth finger | and | Fifth finger | are also linked to the | All finger | component in the order specified by the order value. As shown in the figure the direction of the associations goes from the referenceComponentId to the linkedToId, so the components referenced by the linkedToId are used to form the groups specified in the hierarchy id effective Time active moduleId refsetId referencedComponentId targetComponentId order … 20160731 1 19999999103 159999999105 70327001 All fingers 141819019 Hand 1 … 20160731 1 19999999103 159999999105 127053016 Thumb 70327001 All fingers 1 … 20160731 1 19999999103 159999999105 138873019 Second finger 70327001 All fingers 2 … 20160731 1 19999999103 159999999105 108884010 Third finger 70327001 All fingers 3 … 20160731 1 19999999103 159999999105 136021011 Fourth finger 70327001 All fingers 4 … 20160731 1 19999999103 159999999105 21356012 Fifth finger 70327001 All fingers 5 refsetId_term referencedComponentId_term targetComponentId_term Associations as ordered reference set Associations as ordered reference set Associations as ordered reference set Associations as ordered reference set Associations as ordered reference set Associations as ordered reference set 
Feedback
Overview
Content Tools
Apps