This is an old revision of the document!
Conditions are records of a Person suggesting the presence of a disease or medical condition stated as a diagnosis, a sign or a symptom, which is either observed by a Provider or reported by the patient. Note that the Condition Domain makes no distinction between a mere observation of a symptom, a fully worked out diagnosis or anything inbetween.
| domain_id | CDM table | Field | Comment |
|---|---|---|---|
| Generic | Any | Any | Generic Concepts can be in any field that ends in concept_id. |
| Gender | PERSON | gender_concept_id | |
| Race | PERSON | race_concept_id | |
| Ethnicity | PERSON | ethnicity_concept_id | |
| Visit | VISIT_OCCURRENCE | visit_concept_id | |
| Procedure | PROCEDURE_OCCURRENCE | procedure_concept_id | |
| Modifier | PROCEDURE_OCCURRENCE | modifier_concept_id | |
| Drug | DRUG_EXPOSURE | drug_concept_id | |
| Route | DRUG_EXPOSURE | route_concept_id | |
| Unit | MEASUREMENT or OBSERVATION or SPECIMEN | unit_concept_id | Units are used in different contexts. * |
| Device | DEVICE_EXPOSURE | device_concept_id | |
| Condition | CONDITION_OCCURRENCE | condition_concept_id | |
| Measurement | MEASUREMENT | measurement_concept_id | |
| Meas Value Operator | MEASUREMENT | operator_concept_id | |
| Meas Value | MEASUREMENT | value_as_concept_id | |
| Observation | OBSERVATION | observation_concept_id | |
| Relationship | FACT_RELATIONSHIP | relationship_concept_id | |
| Place of Service | CARE_SITE | place_of_service_concept_id | |
| Provider Specialty | PROVIDER | specialty_concept_id | |
| Currency | MEASUREMENT or OBSERVATION or SPECIMEN | currency_concept_id | Currency values appear in any of the *_COST tables. * |
| Revenue Code | PROCEDURE_COST | revenue_code_concept_id | |
| Specimen | SPECIMEN | specimen_concept_id | |
| Spec Anatomic Site | SPECIMEN or MEASUREMENT or OBSERVATION | anatomic_site_concept_id or value_as_concept_id or value_as_concept_id | Anatomical Site Concepts are used to characterize the origin of a Specimen, but also the result of a Measurement or Observation. * |
| Spec Disease Status | SPECIMEN | disease_status_concept_id |