CommonDataModel icon indicating copy to clipboard operation
CommonDataModel copied to clipboard

Update CDM Observation table, ETL conventions for a person's "history of event"

Open MelaniePhilofsky opened this issue 1 year ago • 0 comments

The historical event for a person should be recorded in the Observation table using the following as guidance to properly populate the observation_concept_id field: (i) an all-in-one bucket History of event concept that implies the semantics of a historical event, context, qualifier, or value; (ii) a hierarchy of enhanced historical concepts that bring additional time context (History of event within... and History of event longer than...)." The historical event will be recorded in the value_as_concept_id field.

MelaniePhilofsky avatar Jul 19 '23 16:07 MelaniePhilofsky