on Epic, SNOMED, LOINC, etc. from KUMC visit to UNMC

[Dan Connolly]

I updated 
TerminologyAlignment<http://informatics.gpcnetwork.org/trac/Project/wiki/TerminologyAlignment>
 with notes from KUMC/UNMC discussions last Fri/Sat.

Highlight:


At UNMC, over 99.9% of the millions of problem list entries have linked snomed 
codes:

select count(*)
from problem_list pl

join EXTERNAL_CNCPT_MAP em
on pl.DX_ID = em.entity_value_str
 and em.entity_ini = 'HLX'
join concept_mapped cm
on cm.mapping_id = em.mapping_id
join snomed_concept sno
on sno.concept_ID = cm.concept_id;


--
Dan