For full OMOP CDM v5.5 specifications, please see our website
What's Changed
Summary
- 7 fields added to existing OMOP tables, all non-required.
- 3 tables added, all to store vocabulary metadata.
- 2 table/field definitions changed.
- No fields or tables have been removed or renamed.
MEASUREMENT
- +
value_as_source_concept_id
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| value_as_source_concept_id | integer | No | No | Yes |
OBSERVATION
- +
value_as_date - +
unit_source_concept_id - +
value_as_source_concept_id
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| value_as_date | date | No | No | No |
| unit_source_concept_id | integer | No | No | Yes |
| value_as_source_concept_id | integer | No | No | Yes |
SPECIMEN
- +
visit_occurrence_id - +
visit_detail_id
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| visit_occurrence_id | integer | No | No | Yes |
| visit_detail_id | integer | No | No | Yes |
CDM_SOURCE
- → Table description updated to describe that tooling expects one record with database metadata
- +
cdm_release_identifier
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| cdm_release_identifier | varchar(255) | No | No | No |
VOCABULARY
vocabulary_id→ Unique constraint added
+ PACK_CONTENT
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| pack_concept_id | integer | Yes | No | Yes |
| drug_concept_id | integer | Yes | No | Yes |
| amount | integer | No | No | No |
| box_size | integer | No | No | No |
+ CONCEPT_METADATA
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| concept_id | integer | No | No | Yes |
| concept_category | varchar(20) | No | No | No |
| reuse_status | varchar(20) | No | No | No |
+ CONCEPT_RELATIONSHIP_METADATA
| Field | Datatype | Required | Primary Key | Foreign Key |
|---|---|---|---|---|
| concept_id_1 | integer | Yes | No | Yes |
| concept_id_2 | integer | Yes | No | Yes |
| relationship_id | varchar(20) | Yes | No | Yes |
| relationship_predicate_id | varchar(20) | No | No | No |
| relationship_group | integer | No | No | No |
| mapping_source | varchar(50) | No | No | No |
| confidence | float | No | No | No |
| mapping_tool | varchar(50) | No | No | No |
| mapper | varchar(50) | No | No | No |
| reviewer | varchar(50) | No | No | No |