Hi @mmckillop
So, it sounds like you want to limit the CONDITION_OCCURRENCE records by
using the CONDITION_TYPE_CONCEPT_ID, which tells you where the data came
from. There’s many type concepts available, but none specifically are
‘discharge diagnosis’. I know some groups, like at CUMC, delineate
diagnoses based on what they come in with (EHR chief complaint,
http://www.ohdsi.org/web/atlas/#/concept/42894222) and what they leave with
(Primary condition http://www.ohdsi.org/web/atlas/#/concept/44786627).
Within the claims database I work with, we identify conditions based on if
the clams was inpatient or outpatient service, as well as its position
(primary vs. secondary) on the claim. For example, here’s the condition
type concept I use to find the ‘discharge diagnosis’, which would be the
primary diagnosis from an inpatient visit (
http://www.ohdsi.org/web/atlas/#/concept/38000183).