Query Construction across Multiple Terminologies Dr Dai Evans

Query Construction across Multiple Terminologies Dr Dai Evans PRIMIS

• V 2, CTV 3, EMIS drugs Process • Avoid NHS browser ( V 2 flaws) • Use bespoke mapping tools integrated with browsers & query library management system • Use Excel tables with additional metadata • Biannual update processes with more frequent drug handling where important

Process Specification – Qo. F, Research, Audit. . V 2* CTV 3 EMIS drugs * Has to work as a minimum. .

Problems CTV 3 highlights terms missing from V 2 specs. Missing maps Extinct terms in CTV 3 Markedly different hierarchies – CTV 3 not always better Contemplate differing contexts of terms. . i. e. Just “Diagnostic Terms” vs “all related terms” What do you do about Synonymous terms? MIQUEST brings in local codes

Wide range of requests H 33% (1780. ) 173 A 173 c H 47 y 0 H 3120 H 44%

Synonyms CTV 3 V 2

Diab etes Diabetes Q 441 L 1808

Specification Problems • Historic problem with Flu Reports v 2 • CVA/TIA • Chr. Neurol Disease A, B, C D, E, F CTV 3 A, B, E, H C, D, F, G

Code Compilation Tools • Accurate • Mapping embedded • Handle manipulation & display of complex hierarchies • Handle inclusion/exclusion across multiple parents • Bi-dimensional version control (new codes, hierarchy shifts, retirement; specification) • SPEED

SNOMED querying • Perceived huge breadth of codes • ? Retired codes • ? Post co-ordination • Data entry advice/templates/facilitation • Possible subset usage (1 st pass/2 nd pass) • Constrained roll-out & implementation • Extraction/Data entry can be preordained in certain scenarios (e. g. Qo. F)