Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Janssen CDM Documentation
Home
CPRD GOLD
Person
Observation Period
Care Site
Location
Provider
Visit_Detail
Visit_Occurrence
CPRD to STEM
Clinical
Referral
Immunisation
Test
Additional
Therapy
Death
CPRD Aurum
Person
Observation Period
Care Site
Location
Provider
Visit_Detail
Visit_Occurrence
CPRD Aurum to STEM
Observation
Problem
Consultation
Drug Issue
Death
IBM CCAE & MDCR
Person
Observation Period
Payer Plan Period
Care Site
Location
Provider
Visit Detail
Visit Occurrence
Cost
Death
IBM CCAE & MDCR to STEM
Enrollment Detail
Drug Claims
Outpatient Services
Inpatient Services
Inpatient Admissions
Facility Header
Lab
Health Risk Assessment
IBM MDCD
Person
Observation Period
Payer Plan Period
Care Site
Location
Provider
Visit Detail
Visit Occurrence
Cost
Death
IBM MDCD to STEM
Enrollment Detail
Drug Claims
Outpatient Services
Inpatient Services
Inpatient Admissions
Facility Header
Long Term Care
JMDC
Person
Observation Period
Care Site
Payer_Plan_Period
Provider
Visit_Occurrence
Condition_Occurrence
Procedure_Occurrence
Measurement
Observation
Drug_Exposure
Death
Cost
Device Exposure
Optum Clinformatics
Person
Observation Period
Payer Plan Period
Care Site
Location
Provider
Visit_Detail
Visit_Occurrence
Optum Clinformatics to STEM
Medical_Claims
Med_Diagnosis
Med_Procedure
Inpatient_Confinement
Lab_Results
Rx_Claims
HRA
SES
Death
Optum EHR
Person
Observation Period
Location
Death
Provider
Visit Detail
Visit Occurrence
Optum EHR to STEM
Diagnosis
Procedure
Labs
Microbiology
Observations
Immunizations
NLP_Measurement
Medication_Administration
Prescriptions_Written
Patient_Reported_Medications
NLP_Drug_Rationale
Optum EHR Drug Exposure
Optum EHR Device Exposure
Optum EHR to Note_NLP
Oncology module ETL
Insurance
Premier
CDM Source
Condition Era
Condition Occurrence
Cost
Death
Device Exposure
Dose Era
Drug Era
Drug Exposure
Measurement
Note
Observation Period
Observation
Payer Plan Period
Person
Procedure Occurrence
Provider
Specimen
Visit Occurrence
Appendix
Patient Loss
Useful Queries
CDM to CDM
Person
Location
Observation Period
Death
Care Site
Payer Plan Period
Provider
Visit Occurrence
Visit Detail
Cost
CDM to CDM to STEM
Condition Occurrence
Device Exposure
Measurement
Drug Exposure
Procedure Occurrence
Observation
STEM to CDM
Drug Era Logic
Janssen OMOP ETL Builder
Mapping an existing CDM instance with a new vocabulary or data quality fixes
It is often the case that we want to
Table of contents
Person
Location
Observation Period
Death
Care Site
Payer Plan Period
Provider
Visit Occurrence
Visit Detail
Cost
CDM to CDM to STEM