In the tutorial of ETL, " [Tutorial-ETL]/[materials]/[Implementation]/ Insert_Condition_Occurrence_Lauren.sql"(https://github.com/OHDSI/Tutorial-ETL/blob/master/materials/Implementation/Insert_Condition_Occurrence_Lauren.sql), there are “when srctostdvm.target_concept_id is null”, I am confused about that what table is srctostdvm and where it from. So, if anybody feels free, would you please tell me? Thanks a lot.
Hello @libeiwu,
‘srctostdvm’ is an alias for table cdm_synthea.source_to_standard_vocab_map. Scroll down to lines 51-56 to see the join clause.
Thanks!
Another question is, how to generate cdm_synthea.source_to_standard_vocab_map, and cdm_synthea.source_to_source_vocab_map?Thanks.
Scripts inside /materials/Queries/ look like examples for source_to_standard_vocab_map / source_to_source_vocab_map.
Also, you may want to check out slides 50-58 from the OHDSI Symposium slide deck, they seem to give a bit more context. The videos for this tutorial can be found here:
https://www.ohdsi.org/extraction-transformation-and-load-process-etl/