condition_occurrence
Standard Clinical Data Table
Table Columns
| field | type | required | phi | phi scrubbing operation |
|---|---|---|---|---|
| condition_occurrence_id | INTEGER | Yes | Not Stable between Data Refreshes | |
| person_id | INTEGER | Yes | Sub | |
| condition_concept_id | INTEGER | Yes | ||
| condition_start_date | DATE | No | Yes | Jitter |
| condition_start_datetime | DATETIME | Yes | Yes | Jitter |
| condition_end_date | DATE | No | Yes | Jitter |
| condition_end_datetime | DATETIME | No | Yes | Jitter |
| condition_type_concept_id | INTEGER | Yes | ||
| condition_status_concept_id | INTEGER | Yes | ||
| stop_reason | STRING | No | ||
| provider_id | INTEGER | No | Not Stable between Data Refreshes | |
| visit_occurrence_id | INTEGER | No | Not Stable between Data Refreshes | |
| visit_detail_id | INTEGER | No | Not Stable between Data Refreshes | |
| condition_source_value | STRING | No | ||
| condition_source_concept_id | INTEGER | Yes | ||
| condition_status_source_value | STRING | No | ||
| trace_id (Stanford construct for traceability) | STRING | No | Yes | Del |
| unit_id (Stanford construct for traceability) | STRING | No | ||
| load_table_id (Stanford construct for traceability) | STRING | No |
Columns Description
condition_occurrence_id
A unique identifier for each Condition Occurrence event.
person_id
A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table.
condition_concept_id
A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the ‘Condition’ domain.
condition_start_date
The date when the instance of the Condition is recorded.
condition_start_datetime
The date and time when the instance of the Condition is recorded.
condition_end_date
The date when the instance of the Condition is considered to have ended.
condition_end_datetime
The date when the instance of the Condition is considered to have ended.
condition_type_concept_id
This field is used to determine the provenance of the Condition record, as in whether the condition was from an EHR system, insurance claim, registry, or other sources.
condition_status_concept_id
A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies reflecting the point of care at which the Condition was diagnosed.
stop_reason
The reason that the Condition was no longer present, as indicated in the source data.
provider_id
A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition.
visit_occurrence_id
A foreign key to the visit in the VISIT_OCCURRENCE table during which the Condition was determined (diagnosed).
visit_detail_id
A foreign key to the visit in the VISIT_DETAIL table during which the Condition was determined (diagnosed).
condition_source_value
The source code for the Condition as it appears in the source data. It is typically ICD9 or ICD10; or the dx_id if we dont have the ICD codes.
condition_source_concept_id
A foreign key to a Condition Concept that refers to the code used in the source.
condition_status_source_value
The source code for the condition status as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is stored here for reference.
trace_id (stanford construct for traceability)
A json string with the primary keys of the table in Clarity where most of the information for a given row is sourced
unit_id (stanford construct for traceability)
Is a reference for the position in the ETL code responsible for bringing in this row level data
load_table_id (stanford construct for traceability)
Is the name of the primary Clarity table in Clarity where most of the information for a given row is sourced