Conditions mapped to SNOMED CT standard concepts, with source ICD-10-CM and ICD-O-3 codes retained in condition_source_value. Built from the longitudinal record, checked with the OHDSI Data Quality Dashboard.
10 upstream · 3 downstream · Show in the estate graph
Source · Systems of record, untouched
Bronze · Raw landing, append-only
Silver · Cleaned and conformed
Gold · Certified data products
Serve · Reports, research and AI
SG-OMOP-RESEARCH-READReleased only as a study dataset with study-specific IDs.
Standard concept mapped (not 0)
Conformance
person_id exists in person
Completeness
Start date not after death date
Validity
Refreshed within SLA
Timeliness
Pass at 98% or better, warn from 90%. A failing check blocks certification.
| Column | Type | Description | Class |
|---|---|---|---|
| condition_occurrence_id | bigint | Row key | None |
| person_id | bigint | OMOP person key (not the MRN) | None |
| condition_concept_id | integer | SNOMED CT standard concept | None |
| condition_start_date | date | Start date | PHI |
| condition_source_value | varchar(50) | Source ICD code as recorded | None |