List non-conformant concept domains #67
Description
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 | ||||||
| ... |