XRN 5118
Change to how ‘Actual MR date’ field is populated in UK Link

Summary

This Change is required to how the ‘Actual MR date’ field in UK Link is populated from the UMR file for Class 4 sites.

The Actual MR date is used as the trigger date for the Rolling AQ calculation process. Currently the Actual MR date field is populated based on the date provided by the Shipper in the header record of the Meter Read submission file (UMR) which is not always the date the file is loaded in UKLink. For example, files are received where the date in the header is in the past and by using this the reads may not meet the criteria to be included in the AQ calculation.

The monthly Rolling AQ calculation job is run on the 12th of each month and considers Valid Meter Read submissions as the trigger for a calculation when received from the 11th of the previous month, to the 10th of the current month.

In cases where the read file is submitted after the 10th of the current month, with a date before the 10th in the header, these readings are not being considered for triggering the AQ calculation.

The change required is for the ’Actual MR date’ to be populated with the date the read was loaded in UKLink to maximise the reads available for AQ calculations.