There seem to be some data inconsistencies between some tables, e.g. provision_summary shows active_endpoint_count = 1 for a provision where the only endpoint has an end-date in reporting_historic_endpoints.
We need to investigate this issue and resolve.
Tech Approach
This might be related to filtering out endpoints with an end-date in the construction of the provision_summary table, as this had to be changed recently. Needs to be investigated.
Acceptance Criteria
Once fixed, the count shown above is accurate and consistent.
We have done a small investigation into whether any other similar inconsistencies exist. These are either fixed, if simple, or tickets raised in the backlog.
Overview
Data Management have flagged the following:
active_endpoint_count= 1 for a provision where the only endpoint has an end-date in reporting_historic_endpoints.We need to investigate this issue and resolve.
Tech Approach This might be related to filtering out endpoints with an end-date in the construction of the provision_summary table, as this had to be changed recently. Needs to be investigated.
Acceptance Criteria