OHDSI Home | Forums | Wiki | Github

Analysis for CDM

(Micheal ) #1

Hello, OHDSI
Now, I would analyze patient numbers for each condition especially chronic disease(Hypertension, diabetes mellitus, Cardiovascular disease) with synpuf data.
However, it was difficult to decide which table I have to use for that.
Does anyone have idea which data I have to use with?

Thank you

(Seng Chan You) #2

My choice is Condition_occurrence table.

(Micheal ) #3

What about Condition_era table?

(Seng Chan You) #4

Do you have any reason that you want to use condition_era over condition_occurrence?
Condition_era table is a secondary table, derived from condition_occurrence.
I think condition_occurrence table would be enough for you, now.

(Micheal ) #5

I thought condition_era is more specific for patients’ status like period of time.
There’s how long the patients get the condition, and duration in the condition_era.