User Tools

Site Tools


Meeting Notes September 03, 2019


  • Mike Gurley pointed out the script written by Dymytry Dymshyts to populate missing metadata concepts. For the following issue: See here:
  • Rimma Belenkaya asked that logic for the SQL ETL should skip any schema with an ambiguous site/histology combination in more than one NAACCR schema. Not just ambiguous site/histology combinations. The group agreed to this. See here:
    • There was discussion on whether to move Drug Treatment NAACCR item codes into the new 'Regimen' domain. For the following issue: Mike Gurley raised that if we do this it leaves us without anything to put into the DRUG_EXPOSURE table. So we should skip making any entry in DRUG_EXPOSURE for Drug Treatment NAACCR item codes. Rimma argued that if this is the case we should not move the DRUG Treatment NAACCR item codes into the Regimen domain. We should make them non-standard Drug domain entries and guide ETL developers to insert them as concept_id=0 but with the NAACCR concept in drug_source_concept_id. And then create new or reuse high-level entries in the Regimen domain for the entry into Episode. Rimma and Mike asked to create an entry in CONCEPT_RELATIONSHIP between the Drug Treatment NAACCR item codes and the high-level entries in the Regimen domain. Christian Reich and Dymytry argued that the CONCEPT_RELATIONSHIP entry is dirty and should not be done. Insteady, they suggested ETL developers hardcode the mapping in their ETL logic. Dymytry suggested re-using the high-level 'Regimen Modality' concepts as the high-level concepts.
    • Dymytry reported that all of the symposium vocabulary tasks would be fixed and published by 9/5/2019.
    • Jermey Warner gave more detail and explanation about ambiguities in pointed out by Christian. See here:
  • Robert Miller reported that he had pushed his R script to the workgroup repository for preparing NAACCR flat file data to the common ETL input format. See here:
documentation/oncology/meeting_notes_2019_sep-03.txt · Last modified: 2019/09/05 17:23 by mgurley