...
For each snapshot view the SNOMED CT example database includes two views that select the
of a specified concept and two views that select the
of a specified concept. These views select the id and either the fully specified name or preferred synonym
of each parent or child concept. The characteristics of each of these views are shown in
Caption reference |
---|
CapRefId | parent-child-view |
---|
CapRefType | Table |
---|
|
and a general template for the SQL definitions of these views is shown in
Caption reference |
---|
CapRefId | parent-child-view |
---|
CapRefType | Template |
---|
|
. To create each of the views named in the table, the placeholders for
{termtype
} need to be replaced with values in the
Specific Settings column of the table.
...
For each snapshot view the SNOMED CT example database includes two views that select the
of a specified concept and two views that select the
of a specified concept. These views select the id and either the fully specified name or preferred synonym
of each ancestor or descendant concept. The characteristics of each of these views are shown in
Caption reference |
---|
CapRefId | transitive-closure-view |
---|
CapRefType | Table |
---|
|
and a general template for the SQL definitions of these views is shown in
Caption reference |
---|
CapRefId | transitive-closure-view |
---|
CapRefType | Template |
---|
|
. To create each of the views named in the table, the placeholders for
{termtype
} need to be replaced with values in the
Specific Settings column of the table.
...
Name Footnote Macro |
---|
Transitive closure and proximal primitive views are only available for the current snapshot.. |
| Description | Specific Settings |
{termtype} |
snap_tc_ancestor_fsn | Selects the id and fully specified name of each supertype ancestor of a concept specified by conceptId. | fsn |
snap_tc_ancestor_pref | Selects the id and preferred synonym of each supertype ancestor of a concept specified by conceptId. | |
snap_tc_descendant_fsn | Selects the id and fully specified name of each subtype descendant of a concept specified by conceptId. | fsn |
snap_tc_descendant_pref | Selects the id and preferred synonym of each subtype descendant of a concept specified by conceptId. | |
...
SQL Query |
Code Block |
---|
language | sql |
---|
theme | Confluence |
---|
| Select "Concept", conceptid, term from snap_pref where conceptId=602500716001004
UNION
Select "Ancestor", id, term from snap_tc_ancestor_pref where conceptId=602500716001004
UNION
Select "Descendant", id, term from snap_tc_descendant_pref where conceptId=602500716001004; |
|
Result |
Concept | conceptId | term |
Concept | 16001004 | Otalgia |
Ancestor | 22253000 | Pain |
Ancestor | 102957003 | Neurological finding |
Ancestor | 106147001 | Sensory nervous system finding |
Ancestor | 118234003 | Finding by site |
Ancestor | 118236001 | Ear and auditory finding |
Ancestor | 118254002 | Finding of head and neck region |
Ancestor | 138875005 | SNOMED CT Concept |
Ancestor | 247234006 | Ear finding |
Ancestor | 276435006 | Pain / sensation finding |
Ancestor | 279001004 | Pain finding at anatomical site |
Ancestor | 297268004 | Ear, nose and throat finding |
Ancestor | 301354004 | Pain of ear structure |
Ancestor | 301857004 | Finding of body region |
Ancestor | 404684003 | Clinical finding |
Ancestor | 406122000 | Head finding |
Ancestor | 699697007 | Finding of sensation by site |
Descendant | 12336008 | Referred otalgia |
Descendant | 74123003 | Otogenic otalgia |
Descendant | 162356005 | Earache symptoms |
Descendant | 162359003 | Bilateral earache |
Descendant | 430879002 | Posterior auricular pain |
Descendant | 1084561000119106 | Bilateral referred otalgia of ears |
Descendant | 1089561000119107 | Referred otalgia of left ear |
Descendant | 1092171000119100 | Referred otalgia of right ear |
...
For each snapshot view the SNOMED CT example database includes two views that select the
Gloss |
---|
t | proximal primitive parents |
---|
|
of a specified concept and two views that select the
of a specified concept. These views select the id and either the fully specified name or preferred synonym
of each parent or child concept. The
characteristics of each of these views are shown in Caption reference |
---|
CapRefId | parent-child-view |
---|
CapRefType | Table |
---|
|
and a general template for the SQL definitions of these views is shown in Caption reference |
---|
CapRefId | parent-child-view |
---|
CapRefType | Template |
---|
|
. To create each of the views named in the table, the placeholders for {termtype} need to be replaced with values in the Specific Settings column of the table. Caption reference |
---|
CapRefId | parent-child-view |
---|
CapRefType | Example |
---|
|
and Caption reference |
---|
CapRefId | transitive-closure-view |
---|
CapRefType | Example |
---|
|
demonstrate the use of these views to select the id and preferred term for a specified concept and all of its supertype parents and subtype children.For each snapshot view the SNOMED CT example database includes ... . The characteristics of each of these views are shown in
Caption reference |
---|
CapRefId | proximal-primitive-view |
---|
CapRefType | Table |
---|
|
and a general template for the SQL definitions of these views is shown in
Caption reference |
---|
CapRefId | proximal-primitive-view |
---|
CapRefType | Template |
---|
|
. To create each of the views named in the table, the placeholders for
{viewtype
} need to be replaced with values in the
Specific Settings column of the table.
...