SCT Node
This table contains a subset of our SNOMED CT concept codes.It contains 9,302 records and includes several columns:
- SCT_ID: This column contains the SNOMED CT ID.
- SCT_Code: This column is an auxiliary column used in this table, not related to SNOMED CT terminology.
- SCT_DescriptionA_Type1: This column shows the description of SNOMED CT IDs with their semantic tag in parentheses.
- SCT_DescriptionA_Type2: This column shows the description of SNOMED CT IDs without their semantic tag in parentheses.
- SCT_DescriptionB: This column shows another description of SNOMED CT IDs, which exists only for some of them.
- SCT_Semantic_Tags: This column contains the semantic tags of SNOMED CT IDs.
- SCT_Type: This column categorizes SNOMED CT into three categories: root (only one ID, 138875005), top-level concept (we have 18 SNOMED CTs), and concept (all other IDs besides root and top-level concepts).
- SCT_Level: This index shows the distance of a SNOMED CT ID from the root SNOMED CT ID (138875005). A SNOMED CT ID may have more than one level.