Data Validation/Integrity

This page will be used to document common issues seen with data sent as part of feeds which can be filtered at source rather than causing files to be rejected due to invlid values:

All sites sending data should ensure the included data passes some basic validation such as :

  • Dates should not be in the future. Any result or observation which is in the future should not be included in the current file.

  • Dates should not be sense checked - typically they should not be before the DOB of the patient. We have also seen a number of dates where the year has been mistyped resulting in a very historic date.

  • Postcodes should pass the regex parsing detailed in the schema or not be included in the file.