Skip to content

oxford-pharmacoepi/cdm-etl-gold

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The .Net CDM Builder was initially developed by Janssen Research & Development as a tool to transform its observational databases into the OMOP Common Data Model. You can find the original code in https://github.com/OHDSI/ETL-CDMBuilder

The program is used to convert CPRD GOLD into OMOP CDM.

v.5.0.1

  • align CDM DDL v5.3 and 5.4 with 4b_OMOPCDM_postgresql_5_3_ddl.sql and 4b_OMOPCDM_postgresql_5_4_ddl.sql
  • Upgraded from net6.0 to net8.0

v.5.0

  • Populate Specimen
  • Support protocol, _p in database name
  • Added source release date in configuration for protocol, _p (also used in observation_period)
  • Upgraded from netcoreapp3.1 to net6.0
  • Applied to GOLD 202407 release

v.4.0

  • Enhancing read code list for mapping COVID-19 brand name (+)
  • update procedure_type_concept_id (+)
  • left empty the non-required concept_id fields empty if there is no source value to map to a concept id (+)
  • Bug fixed non-condition concepts in condition_occurrence
  • not map read code = ZZZZZ00 (+)
  • build PK, indexes and FKs in Era Tables (+)
  • Applied to GOLD 202401 release and cdm_gold_p22_001867

v.3.0

  • Support CDM v.5.4 (+)
    • (backward compatible to CDM v.5.3)
  • Map route in drugs (+)
  • Bug fixed the incorrect observation_end_date
  • [Tentative] No vaccinations in drug_era (sue to the CVX issues) (-)
  • Applied to GOLD 202307 release

v.2.0

  • Expand COVID-19 Vaccination brand infomation (+)
  • Only map events within observation period (+)
    • For Death, the observation period = observation_start_date to observation_end_date + 3 months)
  • Data Cleaning function (-)
  • Applied to GOLD 202301 release

v.1.0

  • SQL tunning
  • Autogenerated ids in OMOP CDM tables (+)
  • Data Cleaning function (+)
  • Applied to GOLD 202207 release

v.0.0

Clone from https://github.com/OHDSI/ETL-CDMBuilder

Backlogs

  • Support CDM v.5.4
  • Map Ethnicities(link to HES data)
  • Populate Specimen
  • Upgrade to net8.0

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Contributors 3

  •  
  •  
  •  

Languages