OHDSI Home | Forums | Wiki | Github

How to set the value of the fields 'min_levels_of_separation' and 'max_levels_of_separation' in table 'CONCEPT_ANCESTOR'?

1,how to set the value of the fields ‘min_levels_of_separation’ and ‘max_levels_of_separation’ in table ‘CONCEPT_ANCESTOR’?

2,why is the value of the fields ‘min_levels_of_separation’ and ‘max_levels_of_separation’ not same?

Hello @whg,

  1. Generally you don’t have to set that if you’re using Standardized Vocabularies downloaded from Athena, CONCEPT_ANCESTOR is pre-built in this case. If you’re building your own vocabularies to extend the standard ones, then min/max levels of separation is set to the the length of shortest/longest chain of relationships between two concepts found in CONCEPT_RELATIONSHIP table.
  2. There was a similar question on the forum answered with an example which you might find helpful.
1 Like

Thank you! Very helpful description.

t