The data owner can run a validation report by navigating to the Dataset Administration tab and selecting Data:
This will open the validation report tab:
All dictionaries from the dataset are listed on the left, and the data owner can choose to either validate these individually, or all at the same time by selecting Validate at the top of the screen. When validation has been run, the results will appear on the right of the page. The image below shows a successful validation:
Where the data owner has chosen to validate all dictionaries, the results are displayed on a per dictionary basis. The data owner can toggle between them by selecting the dictionary they wish to view on the left hand side.
If the validation has produced errors, these will be itemised in the right hand panel:
Where an error exists, the report will provide the data owner with the name and label for the dictionary field where the error has occurred, and a description of the error. The validation report can produce three errors:
- Field exists in dictionary but not in data
- Field exists in data but not in dictionary
- Database and Dictionary Types do not match up
In each case the data owner will need to decide on the appropriate resolution.
Field exists in dictionary but not in data - there is a field in the dictionary that is not in the underlying data. This can be resolved by removing the field from the dictionary, or adding the appropriate missing data to the dataset.
Field exists in data but not in dictionary - there is a field in the data that is not in the dictionary. This can be resolved by adding the field to the dictionary or removing it from the data.
Database and Dictionary Types do not match up - where this error occurs, the validation report will also provide the data owner with the data type for the field in both the data and the dictionary. This can be resolved by making the field type the same in the data and the dictionary.