Where do I find the code that creates the concept_ancestor table

kmace · April 16, 2020, 12:07am

Hi there, from the documentation about the concept_ancestor table:

This table is entirely derived from the CONCEPT, CONCEPT_RELATIONSHIP and RELATIONSHIP tables.

(https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT_ANCESTOR)

Is there somewhere I can find that code? I’m trying to figure out why my results are different when traversing the concept_relationship dag, and using the ancestor table directly.

Christian_Reich · April 16, 2020, 5:45am

github.com

OHDSI/Vocabulary-v5.0/blob/master/working/packages/vocabulary_pack/pConceptAncestor.sql

CREATE OR REPLACE FUNCTION vocabulary_pack.pconceptancestor (
  is_small boolean = false
)
RETURNS void AS
$body$
DECLARE
  iVocabularies VARCHAR(1000) [ ];
  crlf VARCHAR (4) := '<br>';
  iSmallCA_emails CONSTANT VARCHAR(1000) :=(SELECT var_value FROM devv5.config$ WHERE var_name='concept_ancestor_email');
  cRet TEXT;
  cRet2 TEXT;
  cCAGroups INT:=50;
  cRecord record;
  cStartTime timestamp;
  cWorkTime float;
BEGIN

  cStartTime:=clock_timestamp();

  IF is_small THEN

This file has been truncated. show original

Probably not a lot of fun reverse engineering this. What’s the difference you are finding?