OHDSI Home | Forums | Wiki | Github

Maximum values for CDM dictionaries ids

Hello there,

I need to know the maximum integer value used for the CDM dictionaries ids
This would be useful to define optimal structures for datasets conversions to CDM and also address possible limitations in statistical packages if the ids are used as numbers instead of characters.

Thank you guys!
Antonella

Hi Antonella. Currently, in CDM, the maximum integer value used for concept_id is nine-digit.

select max(length(concept_id::varchar)) from concept;
t