====== Example ETLs ======

===== Janssen Research & Development =====

====CDM v5.0====
    * All manuals can be found in GitHub: [[https://github.com/OHDSI/ETL-CDMBuilder/tree/master/man]]
    * Currently there are manuals for:
        * Clinical Practice Research Datalink (CPRD)
        * Japan Medical Data Center (JMDC)
        * Optum Extended Socio-Economic Status (SES) and Date of Death (DOD)
        * Optum Oncology 
        * Optum Integrated (EHR Data Only)
        * Premier
        * SEER Medicare B-CELL
        * Truven MarketScan Commercial Claims & Encounters (CCAE) & Truven MarketScan Medicare (MDCR)
        * Truven MarketScan Multi-State Medicaid (MDCD)
====CDM v4.0====
  * All manuals can be found in GitHub:  [[https://github.com/OHDSI/ETL-CDMBuilder/tree/master/CDMv4/man]]
  * Currently there are manuals for:
        * Clinical Practice Research Datalink (CPRD)
        * Japan Medical Data Center (JMDC)
        * National Health and Nutrition Examination Survey (NHANES)
        * Optum Clinformatics
        * Premier
        * Truven MarketScan Commercial Claims & Encounters (CCAE) & Truven MarketScan Medicare (MDCR)
        * Truven MarketScan Multi-State Medicaid (MDCD)


===== Other Transformation Documents =====
  * [[https://github.com/OHDSI/ETL-CMS| Publicly available Centers for Medicare and Medicaid Services (CMS) 2008-2010 Data Entrepreneurs’ Synthetic Public Use File (DE-SynPUF)]] Transformation to OMOP CDM v5.
  * [[https://dl.dropboxusercontent.com/u/505070/Regenstrief%20OMOP%20ETL%20V4%200-updated%207-7-14.doc|Indiana Network for Patient Care]]
  * {{:documentation:ohdsi_etl_cdm_v5_template_v0.3_20160422.docx|OHDSI_ETL_CDM_V5_TEMPLATE (empty)}}