‘Duplicates’ indicates the number of rows that have exact matches elsewhere in the same table. This is reported as a number (rather than as a percentage of the total rows). Rows are considered duplicates if every value in selected fields are exactly the same. This means that there may be other fields that ‘differentiate’ rows that are not accounted for in our current query.
SQL template
SELECT
person_id, visit_concept_id, visit_start_date, visit_start_datetime,
visit_end_date, visit_end_datetime,visit_type_concept_id, provider_id,
care_site_id, visit_source_value, visit_source_concept_id,
admitting_source_concept_id, admitting_source_value, discharge_to_concept_id,
discharge_to_source_value, preceding_visit_occurrence_id, COUNT(*) as cnt
FROM `visit_occurrence`
WHERE
visit_concept_id!=0 AND visit_concept_id IS NOT NULL
AND person_id!=0 AND person_id IS NOT NULL
GROUP BY
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16
HAVING
cnt > 1
ORDER BY
1,2,3,4,5,6,7,8,9
Features available on the dashboard
- Tooltip - detailed information, calculation equation, and links to Zendesk articles by clicking marks
- Information button
- Color schema
