Concept map


Contents

Description

Stores information relating an OpenMRS concept to a reference (standard) vocabulary such as ICD, LOINC, or SNOMED.

Attributes

Column Name Type Default Description
Primary Key concept_map_id int Unique ID for this table.
Required concept_id concept.concept_id int Original concept which is able to be mapped to a reference vocabulary.
Required source concept_source.concept_source_id int Source ID for the reference vocabulary.
source_concept varchar(255) NULL The value of the reference concept.
notes varchar(255) NULL Various notes related to the mapping.
Required creator users.user_id int User who created the mapping.
Required date_created datetime 0000-00-00 00:00:00 Date when the mapping was created.
changed_by users.user_id int NULL User who last changed the mapping.
date_changed datetime NULL Date the mapping was last changed.
Required voided bit It's true if the mapping has been terminated for use in the system.
voided_by users.user_id int NULL User who terminated the mapping.
date_voided datetime 0000-00-00 00:00:000 Date the mapping was voided.
void_reason varchar (255) NULL Reason why the mapping was voided.
Primary Key primary key, Required required