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>