EHDEN / CdmInspection

R Package to support quality control inspection of an OMOP-CDM instance
Apache License 2.0
11 stars 16 forks source link

List non-conformant concept domains #67

Open MaximMoinat opened 3 years ago

MaximMoinat commented 3 years ago

An important check in DataQualityDashboard is the fkDomain, which checks for the number of concepts in the wrong domain (i.e. Observation concepts in the Procedure table). The Cdm Inspection report does not contain any output on this.

We can make a section about domain checks. Two ideas for tables included in this section:

Records per table, per concept domain Table \ Concept Domain Condition Procedure Drug Device Measurement Observation Unit
Condition occurrence 12346 1687
Procedure occurrence 58 4561
Drug exposure 78123 1234
Device exposure 875
Measurement 56123 5874
Observation 957 456 89561
Obsevation-Unit 87
Measurement-Unit 61234
Condition era 9988 852
Drug era 55789 321
TOP x concepts with a domain mismatch ROW_NUM CONCEPT_ID CONCEPT_NAME TABLE CONCEPT DOMAIN #RECORDS #SUBJECTS
1
2
...