Active FSN parenthesis in Snomed CT July 2015 Release

gistfile1.txt

select distinct SUBSTRING_INDEX(term, '(', -1) from description_s as d left join concept_s as c on d.conceptid = c.id where d.typeid = 900000000000003001 and d.active = 1 and c.active = 1 limit 1000;
+--------------------------------+
| SUBSTRING_INDEX(term, '(', -1) |
+--------------------------------+
| finding)                       |
| body structure)                |
| disorder)                      |
| procedure)                     |
| morphologic abnormality)       |
| regime/therapy)                |
| attribute)                     |
| qualifier value)               |
| observable entity)             |
| substance)                     |
| occupation)                    |
| assessment scale)              |
| physical object)               |
| organism)                      |
| ethnic group)                  |
| SNOMED RT+CTV3)                |
| physical force)                |
| environment)                   |
| event)                         |
| person)                        |
| religion/philosophy)           |
| specimen)                      |
| social concept)                |
| life style)                    |
| tumor staging)                 |
| cell)                          |
| geographic location)           |
| staging scale)                 |
| navigational concept)          |
| product)                       |
| cell structure)                |
| namespace concept)             |
| inactive concept)              |
| special concept)               |
| racial group)                  |
| linkage concept)               |
| link assertion)                |
| record artifact)               |
| situation)                     |
| environment / location)        |
| foundation metadata concept)   |
| core metadata concept)         |
| metadata)                      |
+--------------------------------+
43 rows in set (3.29 sec)