Validation Report by Registration Across All Endpoints

Housing is needing the "most recent" result from each distinct registration number. This is a nuance that accounts for the platform behaviour of not sending through a validation number after it fails - perhaps until a change is made to registration data. We've seen these results validated by recent announcements from Airbnb.

Cobbling this together with excel has reached a limit, as the numbers are getting too big. We were hoping Hanlun could help with creating a query that can allow us to get this data and create a trend line on validation by platform.

Here is what is needed:

• Latest validation result
• From all distinct registration numbers
• Ideally across both real-time and batch validation results
• Since June 2

We would like to be able to group this data by

• Platform
• Status code
• Error type
• Date

Start by locating how real-time and batch validation results are stored and queried. Check which fields represent registration number, validation result, platform, status code, error type, and date, then determine how to select the latest result per distinct registration since June 2. Done means the requested grouped data is available for trend reporting across both validation paths.

Written by the indexing model from the issue text.