| Field | Data type | Purpose | Mutable | PK* |
|---|---|---|---|---|
| id | UUID | 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) |
| effectiveTime | Time | 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 (YYYYMM DD) 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) |
| active | Boolean | 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 |
| moduleId | SCTID | 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 |
| refsetId | SCTID | Identifies the reference set to which this reference set member belongs. A subtype descendant of: | NO | NO |
| referencedComponentId | SCTID | A reference to the SNOMED CT component to be included in the reference set. | NO | NO |
| order | Integer | 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 linkedToId 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 |
| linkedToId | SCTID | The identifier of a SNOMED CT component that acts as a grouper or hierarchy node, collecting together a subgroup from within the list. This field either enables reference 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 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 linkedToId and with order =1. To link a number of children concepts to a single parent concept, one member record should exist per child, with the referencedComponentId field referencing the parent and this field referencing the child concept. The order field is then used to order the children concepts under the parent concept. For ordered lists that do not require grouping or hierarchical arrangement the value of linkedToId should be the digit zero (0). | YES | NO |