Skip to main content

Table 6 Quality assessment results

From: Standardizing registry data to the OMOP Common Data Model: experience from three pulmonary hypertension databases

Condition codes OPUS OrPHeUS EXPOSURE
Unique source values in SDTM database, N 10,659 4013 449
Unique concept_IDs in OMOP CDM, n 3698 2704 337
Unique custom concept_IDs in OMOP CDM, n 6 6 5
Database-specific unique custom concept_IDsa, n 0 0 3
Unique source records in SDTM database, N 128,858 41,960 28,347
Unique OMOP CDM records, n 62,048 41,993 4616
Unique source records, n 55,789 41,608 4394
Drug codes OPUS OrPHeUS EXPOSURE
Unique source values in SDTM database, N 2768 894 2496
Unique concept_IDs in OMOP CDM, n 1514 640 1050
Unique custom concept_IDs in OMOP CDM, n 4 4 0
Database-specific unique custom concept_IDsa, n 3 0 0
Unique source records in SDTM database, N 26,276 16,498 8838
Unique OMOP CDM records, n 23,368 15,169 7823
Unique source records, n 23,083 16,005 7537
  1. aUnique custom concept_IDs that were only used on one database; OPUS and OrPHeUS used the same custom condition concept_IDs
  2. The high percentage of records lost from the EXPOSURE database was due to the large amount of events in the clinical events table that were either marked as ‘unknown’ or ‘not occurred’ and were thus not incorporated, as per OMOP CDM convention
  3. For OrPHeUS condition codes, the number of unique OMOP CDM records is higher than the number of unique source records in the SDTM database because (i) there are very few events that are marked as ‘unknown’ or ‘not occurred’, hence the vast majority of events are mapped to OMOP CDM and (ii) some of the source records can be mapped to more than one target concept_IDs. For example, source code MedDRA 10057688 - ‘Catheter site discharge’ is mapped to 4249456 - ‘Complication of catheter’ and 4183956 - ‘Skin discharge’
  4. For example: source code MedDRA 10057688 - Catheter site discharge is mapped to 4249456 - Complication of catheter and 4183956 - Skin discharge
  5. OMOP CDM Observational Medical Outcomes Partnership Common Data Model; OPUS OPsumit® USers OrPHeUS, OPsumit® Historical Users