Meter Register Content Codes - Impact on Billing

  • 374 Views
  • Last post 3 weeks ago
msouness posted this 29 October 2019

My interest in meter register content codes started with the configuration of register content for billing and reconciliation of network charges for an electricity retailer.  It soon became apparent that incorrect regsister content codes in the electricity Registry can stop a retailer from quoting, let alone switching and billing a customer.

At the back-end, retailers are charged for use of electricity network based on the volume reported against network tariff codes. Simplification of register content code mapping to network tariffs is another area of interest - as this can have a siginifcant impact on electricity retailer margin.

In order to place greater transparency on this issue, it is suggested that a MEP dataset be produced to indicate the party responsible for correcting incorrect register content codes and period of availability.

To this end, I have pulled apart a report from the "ICP and metering details" page on the EA's EMI website.  Data are originally split out into combinations of meter registers, with respect to individual price category codes.  For this analysis R statistical analysis software is employed to re-shape the data to facilitate counting of discrete register content code combinations.  

Some charts are presented for review.  I will attach the R code to enable other users to take a look throught the reshaped dataset.

NHH meter register content codes per network

Reshaped to indicate the portion of register content codes per network.

Portion of NHH meter register content codes

"I" flow register content codes with load codes instead of generation.  Should the customer be charged or credited for generation of energy injected into the network?

Where the correct "EG" register content code is applied to embedded generation, but the period of availaibilty is not 24 hours, this is also considered to be illegitimate.  In some cases this may be due to meter configuration of load periods to match generation periods.

generation register content code without 24 hours availability.

Where an embedded generation (EG) register is presented with load flow, should the customer be charged or credited for generation volume?

Load flow embedded generation EG registers

Uncontrolled registers with less than 24 hours availabiltiy.  Should the customer pay full price, or do they get a discount for lower availability of supply?

Uncontrolled meter registers without 24 hour availabilty

Inclusive registers with 24 hours of availability appears to be a contradiction - that being downstream controlled supply is available 24 hours per day - i.e. uncontrolled.

24 Hour All Inclusive meter registers

The presence of 24 hours of availability on registers with definitions other than 24 hours of availabilty is noted.

time constrained register codes with 24 hours of availability

  • Liked by
  • funcsol
Order by: Standard | Newest | Votes
msouness posted this 29 October 2019

R code for transformation and analysis of Meter Register Content Codes using Electricity Authority data is now available freely on -> Github

Jonathon posted this 30 October 2019

The accuracy of register content codes is monitored through MEP audits.  Copies of the audit reports can be found on the Authority website at:  https://www.ea.govt.nz/operations/retail/audits-approvals-and-certification/audit-reports-and-compliance-plans/metering-equipment-provider/

The registry has also recently been upgraded to include a suite of audit compliance reports for reconciliation participants, distributors and MEPs. (userguide is available from https://www.electricityregistry.co.nz/files/User_Documentation.zip)

The MEP reports includes checks for some register content code combinations that are unlikely to be accurate. This includes looking at ICPs with:

  • only controlled (CN) reigster content codes
  • controlled load profile, but no control device
  • day and night registers, but period of availabilty is not 24 hours
  • day register with no night register
  • night register with no day register
  • inclusive regiser content code with inaccurate period of availability (IN24 or IN0)
  • uncontrolled register content code with period of avaialbility less than 24
  • uncontrolled regsiters, but a load control device onsite

Also I am not familiar with the data source you are using, but when developing the registry reports false we found false positives could be created when we looked at the metering installation level, so reporting had to be at the ICP level..  

  • Liked by
  • msouness
msouness posted this 01 November 2019

Hi Jonathon,

Good to hear back - I have used the EMI's published meter register combination per ICP and distributor price category to pull this information together.  One of the issues I had to deal with as a trader was the inability to quote customers on sites where illegitimate register content codes are in place.  This requires the quoting trader to add illegitimate register content codes (flow, content, poa combinations) to the billing engine.  Only after manual interaction can the sales team quote and initiate a switch.  This propagates further "bad data" within the system (now that a bad content code is "allowed".

In addiiton to your above checks, could you add flow direction?  The presence of X-EG-24 can cause nothing but grief - particularly for reconciliation where a process uses the flow direction for submission to NZX.

msouness posted this 10 November 2019

On another note, I'd be interested in the number of meters still in Registry with a serial number including the text string "10E+".

I've seen this previously in Registry - which I can only assume being due to the use of MS-Excel for reviewing meter details before upload to registry.

msouness posted this 28 November 2019

The October 2019 meter dataset shows notable improvements within the HEDL, ORON and TPCO networks.

  • HEDL and ORON - Reduced Non 24H generation registers, and eliminated uncontrolled registers with less than 24h
  • ORON eliminated incorrect 24h register content codes
  • TPCO eliminated EG load flow registers.

This is good to see.

funcsol posted this 16 December 2019

This thread covers so many of my data consistency & quality concerns trying to generalize Retailer centric billing set up processes independant of the MEP. 

I have many edge cases & special rules to implement due to inconsistent metering event data configurations. 

for instance - X-UN-24 + X-CN-17 + X-7304-24

When I see this, should I expect a single Interval data channel to be transferred? Thats what is implied by this Metering Event Configuration. However paradoxically, I see Interval data flowing in for Register Channel Numbers 001 & 002 despite the MEP Event data only having a single channel with an Accumulator Type = 'A'

When reviewing Schedule 11.4 clause 7 (ref: Table 1.) I cant see that the legacy channel structure vs the AMI channel structure is defined anywhere? What consitutes a compliant Metering Event for an example such as the above? 

Ultimately as long as all MEPs maintain these events equivalently I would be in a position to build processes once, however the inconsistencies result in significantly more complex ICP management. 

  • Liked by
  • msouness
msouness posted this 3 weeks ago

The 2020 Meter Register Review is underway.  

This week I have contacted every network in New Zealand, advising of their specific meter register issues and wide range of PoA for controlled load.  One has confirmed that approximately 40% of the register combinations on its network are legacy (out of date), and is investigating options to resolve this.  

At this stage I think it is realistic to achieve an average 30% reduction in the number of register content configuarions for individual networks.  This will simplify network billing, reduce EIEP1 errors, and improve the accuracy of customer billing.

Regards, Malcolm

Close