You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Where and how to store Suspected Diagnosis in OMOP CDM
CDM or THEMIS convention?
THEMIS
Table or Field level?
Table
Is this a general convention?
No
Summary of issues
Where and how to store Suspected Diagnosis in OMOP CDM
Summary of answer
Christian: suggested to put them in OBSERVATION table. Keep the CONDITION_OCCURRENCE table clean.
(All agreed to add 'value_source_value' field in OBSERVATION table and store the verbatim result in this field)
Melanie: let’s find/create a concept for “suspected diagnosis”, give it a domain_id = Observation and put the suspected Condition in the Observation.value_as_concept_id field. We already do this to represent Medical History, Surgical History, Family History, etc. Let’s keep our representation of the data consistent.
(
The direct representation of the suspected disease will remain intact in the Observation.value_as_concept_id (when the Condition maps to a concept_id) or Observation.value_as_string (when the Condition is string format) field. The Observation.concept_id = ‘suspected diagnosis’ or something.
I see 'value_source_value' field is added in v5.4 OBSERVATION table now. Thus, the OBSERVATION.value_as_string should be NULL and set OBSERVATION.value_source_value = 'Acute Myocardial Infarction' according to above example. Because this suspected diagnosis is mapped and store in OBSERVATION.value_as_concept_id field.
@MelaniePhilofsky, @clairblacketer, in one of my previous ETL project, I stored the (suspected) condition into CONDITION_OCCURRENCE.condition_concept_id field and set condition_status_concept_id= 32899 (Preliminary diagnosis). So, does it mean I need to use the above discussed convention (into OBSERVATION table) to store Suspected Diagnosis in the future?
The text was updated successfully, but these errors were encountered:
@jiawei-qian Preliminary diagnosis could be different than suspected diagnosis. I am moving this to the Needs More Work column since there is not a ratified convention. Themis needs to decided how to correctly represent these data in the OMOP CDM.
Where and how to store Suspected Diagnosis in OMOP CDM
CDM or THEMIS convention?
THEMIS
Table or Field level?
Table
Is this a general convention?
No
Summary of issues
Summary of answer
Christian: suggested to put them in OBSERVATION table. Keep the CONDITION_OCCURRENCE table clean.
(All agreed to add 'value_source_value' field in OBSERVATION table and store the verbatim result in this field)
Melanie: let’s find/create a concept for “suspected diagnosis”, give it a domain_id = Observation and put the suspected Condition in the Observation.value_as_concept_id field. We already do this to represent Medical History, Surgical History, Family History, etc. Let’s keep our representation of the data consistent.
(
The direct representation of the suspected disease will remain intact in the Observation.value_as_concept_id (when the Condition maps to a concept_id) or Observation.value_as_string (when the Condition is string format) field. The Observation.concept_id = ‘suspected diagnosis’ or something.
Example:
Observation.concept_id = ‘suspected diagnosis’
Observation.value_as_concept_id = 312327
Observation.value_as_string = Acute Myocardial Infarction
)
Related links
OHDSI Forum (Christian): https://forums.ohdsi.org/t/suspected-diagnosis-and-its-place-in-the-omop-cdm/11323/2
OHDSI Forum (Melanie): https://forums.ohdsi.org/t/suspected-diagnosis-and-its-place-in-the-omop-cdm/11323/15
Other comments/notes
I see 'value_source_value' field is added in v5.4 OBSERVATION table now. Thus, the OBSERVATION.value_as_string should be NULL and set OBSERVATION.value_source_value = 'Acute Myocardial Infarction' according to above example. Because this suspected diagnosis is mapped and store in OBSERVATION.value_as_concept_id field.
![Image](https://private-user-images.githubusercontent.com/84256452/323165821-d25dfdbf-a79f-47a7-a231-7e0349fa088d.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk2OTQzMTIsIm5iZiI6MTcxOTY5NDAxMiwicGF0aCI6Ii84NDI1NjQ1Mi8zMjMxNjU4MjEtZDI1ZGZkYmYtYTc5Zi00N2E3LWEyMzEtN2UwMzQ5ZmEwODhkLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjI5VDIwNDY1MlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWIwYzliMzgwNTBjMWVjZDY0NjkzNjhkMTQ0ZGU5ZTJiMzE1OWNkMTNlNGQyNDNlNDY4ZGI5NTUwNTUxZDdiNGImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.a8YJGbk2bU5fWsSntOrpfnR8kUWMphhnWI9qOls0w5k)
@MelaniePhilofsky, @clairblacketer, in one of my previous ETL project, I stored the (suspected) condition into CONDITION_OCCURRENCE.condition_concept_id field and set condition_status_concept_id= 32899 (Preliminary diagnosis). So, does it mean I need to use the above discussed convention (into OBSERVATION table) to store Suspected Diagnosis in the future?
The text was updated successfully, but these errors were encountered: