OHDSI Home | Forums | Wiki | Github

DRG vocabulary: several concept_ids per one concept_code

Hi all!
I have an issue with DRG vocabulary:
in table CONCEPT for some CONCEPT_CODEs there are more than one CONCEPT_IDs (one id with INVALID_REASON = NULL and the others with INVALID_REASON = ‘D’)
Should we add condition “Where INVALID_REASON is NULL” to find correct CONCEPT_ID for source code?
Or we have to check that VALID_START_DATE <= source date <= VALID_END_DATE in order to select the proper CONCEPT_ID for this source code?

t