Understanding the CONDITION_OCCURRENCE table and condition types

[Suranga]

Hi all,

We’re looking at the condition occurrence table, and trying to understand how the condition type field in this table gets populated.

The description for this field, as per [0] runs “A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the condition was recorded, the level of standardization, and the type of occurrence.”

Does this mean that it is up to us to determine which condition types we want to support? basically, there is no pre-defined list of types that we all MUST use?

[0] http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:condition_occurrence

[Christian_Reich]

@Suranga:

You wish.

The condition types have their own vocabulary:

select * from concept where vocabulary_id='Condition Type' -- Version 5.0 notation.

If you don’t see what you need let us know and we add.

[Suranga]

Thanks! well, I had hoped. And sometimes hope can be a wonderful thing