This help page describes the M&R data input screen for public bodies called ‘MPRNs (electricity)’. Use this screen to add, review, validate, upload and download MPRN(s) for your electricity connection(s).
For methodology guidance on reporting and validating MPRNs, see MPRNs & GPRNs.
- This screen is only visible if you have chosen ‘MPRN electricity’ as an energy type.
- This screen comprises three green tabs.
- ‘Validate & manage MPRNs’ tab lists all the MPRNs that you have entered into the system.
- 'Add MPRNs' is for adding new MPRNs to the system
- ‘Fix MPRN data issues’ shows a table of MPRNs for which there are data issues for specific years.
- Use the 'All years' toggle above the tables to view or edit data for all years back to the start of your energy efficiency baseline or 2009, whichever is later.
- Click on the table headers to sort the data.
- If you have already reported complete data for previous years and your MPRNs have not changed, all you need to do is validate the MPRNs for the years since you last reported and click ‘Save & continue’.
- Use the ‘Validate & manage MPRNs’ table to review, validate, edit, upload and download MPRNs.
- Find one or more MPRNs using the ‘Find anything’ box above the table. This search box searches the ‘MPRN’, ‘Location’, ‘County’, ‘Tags' and ‘Type’ fields.
- Select a single MPRN by clicking the box adjacent to it.
- Select multiple MPRNs by clicking the boxes adjacent to them.
- Select all MPRNs shown in the table by clicking the box at the top-left of the table.
- Download and upload using the green buttons.
- Uptake multiple MPRNs at once by selecting the MPRNs and clicking the ‘Bulk update’ button.
- Select the ‘Validate & manage MPRNs’ tab.
- Find the MPRN and enter a non-zero value for '20XX attributable %' and ‘20XX validation’ directly in the table.
¶ I want to change the validation status and/or % attributable for an MPRN
- Select the ‘Validate & manage MPRNs’ tab.
- Find the MPRN and edit the value(s) for '20XX attributable %' and ‘20XX validation’, as required, directly in the table.
- Select the ‘Validate & manage MPRNs’ tab.
- Select the MPRNs and click ‘Bulk update’.
- Choose ‘Apply last year's validation status and/or % attributable…’ and select the relevant options if you want to copy the previous year's statuses.
- Select ‘Choose a validation status and/or % attributable…’ if you want to specify the same validation status and percentage attributable for all the MPRNs.
- Select ‘Retire…’ and specify a retirement year to retire the MPRNs.
- Select the ‘Validate & manage MPRNs’ tab.
- Download your MPRNs.
- Edit the MPRNs in the spreadsheet. It is important to follow the template structure to ensure that all MPRNs are added correctly.
- Upload the completed template.
- The result of the upload operation will be sent to you via email. The MPRNs that have been uploaded successfully also appear on the screen.
- If your upload file contains any new MPRNs these are appended to your MPRN list.
- If your upload file omits MPRNs that already exist in the system, no change is made to these MPRNs in the system.
- If your upload file contains different data for MPRNs that already exist in the system, the existing data is overwritten by data in the upload file.
- If your upload file omits valid data for one or more mandatory data fields, the MPRN is not updated in the system and an error is reported for the relevant data field(s).
- If your upload file omits valid data for one or more non-mandatory data fields, the MPRN is updated and the field value is set to null.
- If your upload file does not contain validation data for an MPRN, the MPRN is uploaded but it appears in the ‘Fix MPRN data issues’ tab.
- If your upload file contains a 'valid' validation status for an MPRN that has previously been retired, the validation status for that MPRN is not be updated and an error is returned.
- If your upload file contains tags that do not match the available tags in the system, then all tags for the MPRN are replaced. Any tags that did not already exist within the system are added to the system and linked to the MPRN.
- Select the ‘Validate & manage MPRNs’ tab.
- Find the MPRN and click the edit icon on the right of the table.
- Edit the dialogue, noting that the fields with asterisks are mandatory.
- Select the ‘Validate & manage MPRNs’ tab.
- Find the MPRN and click the edit icon on the right of the table.
- Click ‘Retire’ and select the year from which the MPRN should be retired. This is the first year for which the MPRN consumption will not be counted.
- Select the ‘Validate & manage MPRNs’ tab.
- Select the MPRNs and click ‘Bulk update’.
- Select ‘Retire…’ and specify a retirement year to retire the MPRNs.
- Functionality to ‘un-retire’ an MPRN is currently under development.
- In the meantime, if you wish to un-retire an MPRN, you should contact the M&R helpdesk, who will do it for you.
- Select the ‘Validate & manage MPRNs’ tab.
- Find the MPRN and click the edit icon on the right of the table.
- Select ‘Delete’. This will remove the MPRN, including any historical consumption, from your account.
- Select the ‘Add MPRNs’ tab
- Select ‘Manual entry…’ and click ‘+Add’.
- Complete the dialogue, noting that the fields with asterisks are mandatory.
- Use the 'Valid from', ‘Valid to’, ‘Validation status’ and 'Attributable %' fields to validate the new MPRN for several years.
- Select the ‘Add MPRNs’ tab
- Select ‘Bulk upload…’ and click ‘+Add’.
- Download the spreadsheet template using the ‘download’ button.
- Complete the template with the new MPRNs. It is important to follow the template structure to ensure that all MPRNs are added correctly.
- Upload the completed template.
- The result of the upload operation will be sent to you via email. The MPRNs that have been uploaded successfully also appear on the screen.
- If your upload file contains any new MPRNs these are appended to your MPRN list.
- If your upload file omits MPRNs that already exist in the system, no change is made to these MPRNs in the system.
- If your upload file contains different data for MPRNs that already exist in the system, the existing data is overwritten by data in the upload file.
- If your upload file omits valid data for one or more mandatory data fields, the MPRN is not be added and an error will be reported for the relevant data field(s).
- If your upload file omits valid data for one or more non-mandatory data fields, the MPRN is added and the field value is set to null.
- If your upload file does not contain validation data for an MPRN, the MPRN is uploaded but it appears in the ‘Fix MPRN data issues’ tab.
- Select the ‘fix MPRN data issues’ tab.
- The data issue for each MPRN-year combination is described in the message column.
- If the message states ‘please select a validation status', the MPRN needs to be validated for the year indicated. You can do this by clicking the edit action in the right-most column and updating the table. Once the MPRN has been validated, this issue is cleared from the ‘fix MPRN data issues’ table.
- If the message states ‘% attributable cannot be zero for a valid meter', the MPRN needs a non-zero % attributable assigned to it. You can do this by clicking the edit action in the right-most column and updating the table. Once the MPRN has a non-zero percentage attributable assigned, this issue is cleared from the ‘fix MPRN data issues’ table.
- If the message states ‘Check the rejection status', consumption data was not provided by ESB Networks for the MPRN for the year indicated. You can click on the '?' in the right-most column to see the reason given for this. Further explanation of the different reasons and the remedial action you can take is provided under ‘rejected MPRNs and GPRNs’ in MPRNs & GPRNs.
See also ‘validation problems’ and ‘rejected MPRNs & GPRNs’ in MPRNs & GPRNs.
- All MPRNs must be assigned a validation status and a percentage attributable for every year.
- An MPRN cannot have one of the three 'valid' validation statuses and a percentage attributable of zero. If you do not want the system to count consumption through an MPRN for a specific year, you must classify the MPRN as 'not validated'.
- When a new MPRN is added to the system, SEAI can typically only access consumption data for the previous seven years. For this reason you cannot validate new MPRNs for years prior to seven years previously. If you upload an MPRN with a 'valid' validation status for an earlier year earlier and the the consumption data is not already in the system for that year, the validation status for that MPRN will not be updated and an error returned.
- If you require data for earlier years, you will need to work out the relevant annual consumption for these years, by reviewing your old bills, and then manually self-report it as energy type ‘non-MPRN electricity’.
- When you retire an MPRN you are declaring that the MPRN is no longer in use by your organisation e.g. if your organisation has moved premises. When you retire a meter, your historical validation status and meter consumption are saved but you will no longer be asked to validate this MPRN in future years.
- Deleting an MPRN will permanently remove it from the system. An MPRN should only be deleted if your organisation never consumed energy through the meter.
- When uploading MPRNs your upload file must be in the correct format (which is available via download).
- To choose energy type ‘MPRN electricity’, use input screen choose energy types.
- If you also need to self-report electricity consumption, use input screen energy use.