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

Table 6 Quality assessment results

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_IDs^a, 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_IDs^a, 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

^aUnique custom concept_IDs that were only used on one database; OPUS and OrPHeUS used the same custom condition concept_IDs
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
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’
For example: source code MedDRA 10057688 - Catheter site discharge is mapped to 4249456 - Complication of catheter and 4183956 - Skin discharge
OMOP CDM Observational Medical Outcomes Partnership Common Data Model; OPUS OPsumit® USers OrPHeUS, OPsumit® Historical Users

ISSN: 1471-2288