MVP-CIEL concept dictionary for Raxa EMR

Objective

Millennium Villages Project (MVP) and Columbia International eHealth Laboratory (CIEL) recommend sharing of medical terminologies (or concepts) to match international standards such as ICD-10, SNOMED CT, LOINC, RxNORM and CVX. The Unified Medical Language System (UMLS) is a compendium of many controlled vocabularies in the biomedical sciences. It may also be viewed as a comprehensive thesaurus of biomedical concepts. UMLS further provides facilities for natural language processing. It is intended to be used mainly by developers of systems in medical informatics.

Few of the standards

ICD-10 is the 10th revision of the International Statistical Classification of Diseases and Related Health Problems (ICD), a medical classification list by the World Health Organization (WHO). It codes for diseases, signs and symptoms, abnormal findings, complaints, social circumstances, and external causes of injury or diseases .
SNOMED CT (Systematized Nomenclature of Medicine -- Clinical Terms), is a systematically organised computer processable collection of medical terms providing codes, terms, synonyms and definitions covering diseases, findings, procedures, microorganisms, substances, etc.
Logical Observation Identifiers Names and Codes (LOINC) is a database and universal standard for identifying medical laboratory observations.
RxNorm provides normalized names for clinical drugs and links its names to many of the drug vocabularies commonly used in pharmacy management and drug interaction software

Add standard concepts in Raxa EMR

Required concepts can be imported into database by using openmrs_concepts_1.9.0_20120727.sql.zip
- Steps to follow
  1. Extract zip
  2. Open mysql console and type following commands
    use openmrs; /*openmrs is default db name, change if you customised your setup. Check runtime-properties to check the name if you face any problem*/
    source <file_location_without_quotes>
    
    Classification of concept in above mentioned db
    Name    Count
    Test                         882
    Procedure                 95
    Drug                         7890
    Diagnosis                  37366
    Finding                      904
    Anatomy 266
    Question                    564
    LabSet                       10
    MedSet    15
    ConvSet                      99
    Misc                           782
    Symptom                  27
    Symptom/Finding      46
    Specimen                17
    Misc Order                33
    Workflow                  3
    State 7
    Program   2
    Aggregate Measurement 4
    
    We are interested in classifying concepts in multiple hierarchy levels for better tagging of concepts, which will be very helpful in machine learning and similar future plans of Raxa. We are in process of finding most efficient way to do it esp for Outpatient Module.