Table 1.
Gold Standard EHRa | Registry field | OMOP table.column |
Gender | Sex | person.gender_concept_id |
Ethnicity | Spanish Origin | person.ethnicity_concept_id |
Race | Race | person.race_concept_id |
Date of Diagnosis | Date of Diagnosisb | condition_occurrence. condition_start_date |
Basis of Diagnosis | Dx Confimation DX Staging/Proc Summb | procedure_occurrence. procedure_occurrence_id |
Cancer Site | Cancer Site ICD-0-3 SEERc Site Group | condition_occurrence. condition_concept_id |
Cancer Histology/Morphology | Cancer Histology (ICD-0-3) | condition_occurrence. condition_concept_id |
Therapeutic Agent/Modality | Text/Code of Chemo At Hospitalb | drug_exposure. drug_concept_id |
Beginning and End Dates of Treatment | Chemo Start Date/Chemo End Dateb | drug_exposure. drug_exposure_start_date/drug_exposure. drug_exposure_end_date |
aEHR: electronic health record.
bIndicates that the field is listed but no or incomplete information was populated (ie, “suspense” registry cases).
cSEER: Surveillance, Epidemiology, and End Results.