How to populate _concept_id fields in CDM Note table?

CDM Builders
2

@TBanokina:

Note:

select * from concept where vocabulary_id='Note Type';

But: We are creating a whole hierarchy:

select a.min_levels_of_separation as a_min,
  de.concept_id as de_id, de.concept_name as de_name, de.vocabulary_id as de_vocab, de.domain_id as de_domain, de.concept_class_id as de_class
from concept an
join concept_ancestor a on a.ancestor_concept_id=an.concept_id
join concept de on de.concept_id=a.descendant_concept_id
where an.concept_id=36209248
order by min_levels_of_separation;

We will replace the old one with these soon.

Language:

select * from concept where concept_name like '%language' and vocabulary_id='SNOMED' and concept_class_id='Qualifier Value' and invalid_reason is null;

But you probably need English: 4180186

Encoding and Note Class:

Not sure. We need to ask the folks who own all these changes: @HuaXu, @rimma, @noemie? Please help

I’d leave out or set to 0 for now.