Page History
...
Caption label | ||||
---|---|---|---|---|
| ||||
Composite Description Views for Selecting Concept Descriptions |
Name
| Description | Specific Settings | |||
{typeId} | { acceptabilityId } | ||||
snap_fsn | This view selects the fully specified name of a concept (identified by conceptId) | = 900000000000003001 | = 900000000000548007 | ||
snap_pref | This view selects the preferred synonym of a concept (identified by conceptId) | = 900000000000013009 | = 900000000000548007 | ||
snap_syn | This view selects other acceptable synonyms of a concept (identified by conceptId) | = 900000000000013009 | = 900000000000549004 | ||
snap_synall | This view selects all synonyms of a concept (identified by conceptId) | = 900000000000013009 | IN (900000000000548007, 900000000000549004)
|
Caption label | ||||
---|---|---|---|---|
| ||||
Description Selection Composite View Template |
...
Caption label | ||||
---|---|---|---|---|
| ||||
Selecting Description Data for a Concept |
SQL Query | ||||||||||
| ||||||||||
Result | ||||||||||
conceptId | FSN | id | term | |||||||
95570007 | FSN | 839752010 | Kidney stone (disorder) | |||||||
95570007 | Pref | 158296018 | Kidney stone | |||||||
95570007 | Syn | 158297010 | Renal stone | |||||||
95570007 | Syn | 158298017 | Nephrolith | |||||||
95570007 | Syn | 158299013 | Renal calculus | |||||||
95570007 | Syn | 512193015 | Calculus of kidney | |||||||
95570007 | Syn | 512194014 | Nephrolithiasis | |||||||
95570007 | Syn | 512195010 | Kidney calculus |
Views that Facilitate Searching for Concepts
...
. The specific characteristics of these views is shown in
Caption reference | ||||
---|---|---|---|---|
|
Caption reference | ||||
---|---|---|---|---|
|
Caption reference | ||||
---|---|---|---|---|
|
...
Caption label | ||||
---|---|---|---|---|
| ||||
Composite Description Views that Facilitate Searching for Concepts |
Name
| Description | Specific Settings | ||
{typeId} | ||||
snap_syn_search_active | This view includes active preferred and acceptable synonyms of active concepts. It excludes fully specified names and also excludes all descriptions associated with concepts that are inactive in the specified snapshot. | = 900000000000013009 | ||
snap_term_search_active | This view includes active preferred and acceptable synonyms of active concepts. | IN (900000000000003001, 900000000000013009)
|
Caption label | ||||
---|---|---|---|---|
| ||||
Description Search Composite View Template |
...
Caption label | ||||
---|---|---|---|---|
| ||||
Searching Terms to Find Concepts |
SQL Query | |||||||||
| |||||||||
Result | |||||||||
conceptId | matching term | FSN | |||||||
54329005 | Acute anterior myocardial infarction | Acute myocardial infarction of anterior wall (disorder) | |||||||
54329005 | Acute myocardial infarction of anterior wall | Acute myocardial infarction of anterior wall (disorder) | |||||||
703164000 | Acute anterior ST segment elevation myocardial infarction | Acute ST segment elevation myocardial infarction of anterior wall (disorder) | |||||||
703164000 | Acute STEMI (ST elevation myocardial infarction) of anterior wall | Acute ST segment elevation myocardial infarction of anterior wall (disorder) | |||||||
703164000 | Acute ST segment elevation myocardial infarction of anterior wall | Acute ST segment elevation myocardial infarction of anterior wall (disorder) | |||||||
703252002 | Acute myocardial infarction of anterior wall involving right ventricle | Acute myocardial infarction of anterior wall involving right ventricle (disorder) | |||||||
703252002 | Acute myocardial infarction of anterior wall with right ventricular involvement | Acute myocardial infarction of anterior wall involving right ventricle (disorder) | |||||||
703165004 | Acute ST segment elevation myocardial infarction of anterior wall involving right ventricle | Acute ST segment elevation myocardial infarction of anterior wall involving right ventricle (disorder) | |||||||
703165004 | Acute anterior ST segment elevation myocardial infarction with right ventricular involvement | Acute ST segment elevation myocardial infarction of anterior wall involving right ventricle (disorder) | |||||||
703165004 | Acute STEMI (ST elevation myocardial infarction) of anterior wall with right ventricular involvement | Acute ST segment elevation myocardial infarction of anterior wall involving right ventricle (disorder) | |||||||
285981000119103 | Acute ST segment elevation myocardial infarction involving left anterior descending coronary artery | Acute ST segment elevation myocardial infarction involving left anterior descending coronary artery (disorder) |
...
Display Footnotes Macro |
---|