Nov 2017 vocabulary had 59 rows where domain_id = Place of Service and standard_concept = ‘S’
March 2018 vocabulary has zero rows where domain_id = Place of Service and standard_concept = ‘S’
Bringing this up because ETL procedure was checking for standard_concept = ‘S’ and this code now fails.
Putting this in CDM builders forum, even though it may better be an issue in the vocabulary git/issues because ETL developers more likely to see it here.
The problem is that the domain_id for the vocabulary ‘Place of Service’ was changed from ‘Place of Service’ to ‘Visit’ so ETL has to use either the vocabulary_id ‘Place of Service’ or change Domain_id to ‘Visit’. However, changing the Domain_id to ‘Visit’ will create a problem because there are some code, ‘01’ - ‘09’ that are in both vocabularies ‘UB04 Pt dis status’ and ‘Place of Service’ but they have different meanings.