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 |