Description

A table which maintains proposed changes to the local concept dictionary. Applications can use this table to queue concepts or synonyms not yet contained in the dictionary, and provides enough metadata around this request to retrospectively recreate observational data for a given patient/encounter.

Attributes

	Column Name	Type	Default	Description
	concept_proposal_id	int
	concept_id concept.concept_id	int	NULL
	encounter_id encounter.encounter_id	int	NULL
	original_text	varchar(255)
	final_text	varchar(255)	NULL
	obs_id obs.obs_id	int	NULL
	obs_concept_id concept.concept_id	int	NULL
	state	varchar(32)	UNMAPPED
	comments	varchar(255)	NULL
	creator users.user_id	int
	date_created	datetime	0000-00-00 00:00:00
	changed_by users.user_id	int	NULL
	date_changed	datetime	NULL
primary key, required