OnRamp

Purpose of this document

Introduction here.

ETL guideline for Conditions When writing CONDITION_OCCURRENCE records, you will come across the following mapping scenarios for the condition_concept_id field: Map to cancer condition If your data have source codes or unstructured free text fields, try mapping them to proper cancer conditions (those with histology and topography), before you revert to one-legged or shallow concepts. If you must choose between a malignant and a primary malignant concept of the same histology and topography pick the malignant and ignore the primary malignant version. If different records of the same cancer contain concepts of different granularity depth (e.g. sometimes as Acinar cell carcinoma of body of pancreas and sometimes as Malignant tumor of pancreas) don't worry and don't try to harmonize. Combine histology and topography concepts to proper cancer condition In many source data, histology and topography records are provided separately and no proper cancer diagnosis is given. Alternatively, histology concepts are given as one-legged conditions, and topography concepts are provided as shallow concepts, or a combination of the above. In these cases, it is up to you to generate the condition concepts by combining the components. Often time, they are not recorded on the same day, so you must create a time corridor to find the histology/topography pairs. Combine them as follows: If you have ICDO3 histology and topography records only, you can just concatenate their concept codes with a dash and look up the condition concept. For example, you have histology concept Acinar cell carcinoma with concept code "8550/3" and topography concept Body of pancreas with concept code "C25.1" in the same patient within a corridor of, say, a month, you create a combined concept code "8550/3-C25.1" and look up Acinar cell carcinoma of body of pancreas. If you have ICDO3 condition concepts with a "NULL" in the concept code, extract only the histology or topography component and do as above. If you have a mixture of SNOMED and ICDO3 or only SNOMED concepts, you can use the combination table made available here. If you cannot find valid concepts using the ICDO3 or SNOMED method, the combination is not valid and nothing should be written out. Split extra attributes from conditions beyond histology and topography Many source data contain condition concepts or free diagnosis text listing more attributes than histology and topography. You must split them off and write only the proper cancer condition concept. For example, PUVA therapy-associated squamous cell carcinoma should be recorded as a condition concept Squamous cell carcinoma, Kaposi's sarcoma with AIDS as Kaposi's sarcoma and AIDS, and Local recurrence of malignant tumor of gallbladder as Malignant tumor of gallbladder. The superfluous attributes must be written as Cancer Modifiers, Episodes or other Conditions (see below). In future OHDSI Standardized Vocabulary releases, all these will be non-standard with correct "Maps to" relationships, but for now you can use the table available here. </td>