13.2. Data Quality Report

This functionality is available to FSS & LA SND Administrators. The Data Quality Report dashboard allows FSS and LAs to monitor the quality of data arriving in SND from the LA MIS systems via the API. Issues reported are ranked in severity. Severity levels can be changed as and when required.

The report defaults to show quality issues relating to trading food businesses. The filter menu can be used to change the default and show quality issues with all businesses, or just closed businesses.

The following data quality checks are currently reported:

SND Table	Field(s)	Action	Current Severity Applied
Food Establishment	Premises Type	Report error if blank	High
Food Establishment	Business Registration Date and Business Start Date	Report error if both dates are missing or invalid	High
Food Establishment	Business Operator Name	Report error if blank	Medium
Food Establishment	Trading Name	Report error if blank	High
Food Establishment	Address & Post Code fields	Report error if blank	Low
Food Establishment	Easting and Northing	Report error if blank	Low
Approved Food Establishment	Approval Number	Report error if blank	High
Approved Food Establishment	Approval Status	Report error if blank	High
Approved Food Establishment	Approval Status Date	Report error if blank or invalid date	High
Intervention	Responsibility Type	Report invalid values	High
Intervention	Intervention Type	Report error if blank	High
Intervention	Intervention Date	Report error if blank or invalid date	Medium
Food Hygiene Information Scheme	Status	Report error if blank	High
Food Hygiene Information Scheme	Date Visited	Report error if blank or invalid date	Medium
Food Hygiene Risk Rating	Officer Responsible Name	Report error if blank	Medium
Food Hygiene Risk Rating	Type of Food and Method of Handling Score	Report invalid values	Medium
Food Hygiene Risk Rating	Method of Processing Score	Report invalid values	Medium
Food Hygiene Risk Rating	Consumers at Risk Score	Report invalid values	Medium
Food Hygiene Risk Rating	Level of Hygiene Compliance Score	Report invalid values	Medium
Food Hygiene Risk Rating	Level of Structural Compliance Score	Report invalid values	Medium
Food Hygiene Risk Rating	Confidence in Management Control Systems Score	Report invalid values	Medium
Food Hygiene Risk Rating	Vulnerable Groups Score	Report invalid values	Medium
Food Hygiene Risk Rating	Risk of Contamination Score	Report invalid values	Medium
Food Hygiene Risk Rating	Food Hygiene Risk Rating Date	Report blank dates / future dates / incorrectly formatted dates	High
Food Hygiene Risk Rating	Next Food Hygiene Inspection Date	Report blank dates / date of >5 years in future	Medium
Food Standards Risk Rating	Officer Responsible Name	Report error if blank	Medium
Food Standards Risk Rating	Risk to Consumers and / or Business Score	Report invalid values	Medium
Food Standards Risk Rating	Extent to Which the Activities of the Business affect any Hazard Score	Report invalid values	Medium
Food Standards Risk Rating	Ease of Compliance Score	Report invalid values	Medium
Food Standards Risk Rating	Consumers at Risk Score	Report invalid values	Medium
Food Standards Risk Rating	Level of Current Compliance Score	Report invalid values	Medium
Food Standards Risk Rating	Confidence in Management Control System score	Report invalid values	Medium
Food Standards Risk Rating	Food Standards Risk Rating Date	Report blank dates / future dates / incorrectly formatted dates	High
Food Standards Risk Rating	Next Food Standards Inspection Date	Report blank dates / date of >5 years in future	Medium
Food Law Rating System	Officer Responsible Name	Report blank officer name	Medium
Food Law Rating System	Business Group	Report invalid values	High
Food Law Rating System	Average Risk Rating Score	Report invalid values	High
Food Law Rating System	Risk Rating Band	Report invalid values	High
Food Law Rating System	Food Law Risk Rating Date	Report blank dates / future dates / incorrectly formatted dates	High
Food Law Rating System	Next Food Law Inspection Date	Report blank dates / date of >5 years in future	Medium
Food Law Rating System	Food Safety and Practice Performance Score	Report invalid values	Medium
Food Law Rating System	Cross Contamination Performance Score	Report invalid values	Medium
Food Law Rating System	Food Information Performance Score	Report invalid values	Medium
Food Law Rating System	Composition Performance Score	Report invalid values	Medium
Food Law Rating System	Structural Performance Score	Report invalid values	Medium
Food Law Rating System	Food Safety Management System Score	Report invalid values	Medium
Food Law Rating System	Confidence in Management Score	Report invalid values	Medium
Complaint (Service Request)	Complaint Type	Report error if blank	High
Enforcement	Enforcement Date	Report blank dates / future dates / incorrectly formatted dates	Medium
Enforcement	Enforcement Type	Report blank dates	High
Conviction	Conviction Date	Report blank dates / future dates / incorrectly formatted dates	Medium

Note that Data Quality Report cannot report on data missing from the data submissions sent to SND from the LA MIS. The Data Quality Report dashboard provides a framework for monitoring the quality of data in SND. New quality checks can be added as required, and redundant checks can be removed at any time.