MDM/R Technical Interfaces and Samples:

This page contains links to various MDM/R Technical Interface documents that are under change control by the SMSIP team.  In addition this page also contains samples of various MDM/R reports and technical interfaces (see bottom of this page).    At present, the main documents that are available from this page are:

Documents under Change Control:

- the “MDM/R Technical Interface Specifications” document;

- the “MDM/R Reports Technical Specifications”;

- the draft “Validation Estimation and Editing (VEE) Standard”.

Technical interface and reports samples:  see bottom of this page.

MDM/R Manuals, Procedures and Forms page:  please click here.

For further information regarding the Temporary Change Control Process, please click here.

MDM/R Technical Interface Documents

Status

Document

Date Published

Links

CURRENT

(Under change control)

MDM/R V1.0 Technical Interface Specifications Document (IESO_SPEC_9027):

Overview:

This document defines the technical interface specifications for the Meter Data Management and Repository (MDM/R). The specifications in this document provide the detailed format of the interfaces associated with the integration of the MDM/R with various external systems.

Outstanding SME_IMDC documents:

SME_IMDC_0035 Pertaining to Issue 2.9

Current Release Status:

Issue 2.9 – July 9, 2009 

(replaces Issue 2.8 – Feb. 27, 2009)

Previous Releases:

Draft 1.23 - April 5, 2007

Draft 1.24 - May 3, 2007

Draft 1.25 - May 18, 2007

Draft 1.26 - June 13, 2007

Issue 2.0 – July 31, 2007

Issue 2.1 – Oct. 18, 2007

Issue 2.2 – Oct. 31, 2007

Issue 2.3 – Nov. 30, 2007

Issue 2.4 – May 9, 2008

Issue 2.5 – June 2, 2008

Issue 2.6 – June 6, 2008

Issue 2.7 – Dec. 19, 2008

Issue 2.8 – Feb. 27, 2009

CLICK HERE to download - MDM/R V1.0 Technical Interface Specifications, issue 2.9 - CLEAN Version

CLICK HERE to download - MDM/R V1.0 Technical Interface Specifications, issue 2.9 - REDLINE Version

CURRENT

(Under change control)

MDM/R V1.0 Reports Technical Specifications (SME_SPEC_0001):

Overview:

This document sets out the specification of various MDM/R reports.  The contents of this document were formerly part of “MDM/R Technical Interface Specifications” until Release 1.23.  Further enhancements to this content have been made since it formerly appeared in the “MDM/R Technical Interface Specifications” document.

Outstanding SME_IMDC documents:

SME_IMDC_0045 Pertaining to Issue 2.9

Current Release Status:

Issue 2.9 – Issued: August 31, 2009

(replaces Issue 2.8, March, 27, 2009)

Previous Releases:

Draft 0.5 - Issued May 11, 2007 (Formerly part of “MDM/R Technical Interface Specifications”)

Draft 0.6 - May 18, 2007

Issue 2.0 –July 31, 2007

Issue 2.1 - Sept. 18, 2007

Issue 2.2 – Sept. 28, 2007

Issue 2.3 – Oct. 5, 2007

Issue 2.4 – Nov. 1, 2007

Issue 2.5 – Dec. 11, 2007

Issue 2.6 – Feb. 14, 2008

Issue 2.7 – Nov. 27, 2008

Issue 2.8 – Mar. 27, 2009

CLICK HERE to download MDM/R V1.0 Reports Technical Specifications, Issue 2.9 – CLEAN Version

CLICK HERE to download MDM/R V1.0 Reports Technical Specifications, Issue 2.9 – REDLINE Version

September 25, 2009:  SPECIAL ADDENDUM TO ISSUE 2.9 pertaining to MDM/R Report BR02 - Unauthorized Usage Report – Version 01:

CLICK HERE to download SME_IMDC_0045 Pertaining to Issue 2.9 and report BR02.

CURRENT

(Under change control)

Validation, Estimation and Editing (VEE) Standard (IESO_STD_0078):

Overview:

The purpose of this document is to establish a province wide validation, estimation standard and editing guideline for Meter Read data collected for electricity smart meters in the province of Ontario.

Outstanding SME_IMDC documents:

SME_IMDC_0052 – Activation of VEE Services VE07 (Seasonal) and VE17 – (Seasonal ODEST) and associated class load profile.  The class load profile itself, is separately provided in an excel file in the in panel to the right.

Current Release Status:

Issue 2.0 - Issued December 19, 2008

(Replaces Issue 1.0 – March 20, 2008)

Previous Releases:

Draft 0.8 - Issued April 5, 2007

Draft 0.9 - Issued March 7, 2008

Issue 1.0 – March 20, 2008

CLICK HERE to download - Validation, Estimation and Editing for the Ontario Smart Metering System, Issue 2.0 – CLEAN Version

CLICK HERE to download - Validation, Estimation and Editing for the Ontario Smart Metering System, Issue 2.0 – REDLINE Version

NEW - Class Load Profiles:

·          VEE Services VE07 and VE17

NOTE:  The date/time format utilized within the class load profile is:  ‘yyyymmddhhmmss’

CURRENT

MDM/R Detailed Design document (SME_DES_9001):

Overview:

The MDM/R Detailed Design document is released as the proprietary information of eMeter Corporation and outlines the functions of the core EnergyIP application at the heart of the MDM/R system.

Outstanding SME_IMDC documents:

None at this time.

Current Release Status:

Issue 2.0 – Issued to LDCs April 30, 2008 and published on September 28, 2009.

CLICK HERE to download - MDM/R Detailed Design document, Issue 2.0 – CLEAN Version

SPECIAL NOTE:

This document was originally released on April 30, 2008, it corresponded with MDM/R V1.0 Reports Technical Specifications, Issue 2.6,  MDM/R V1.0 Technical Interface Specifications, Issue 2.3 and MDM/R VEE Standard for the Ontario Smart Metering System, Issue 1.0.  These related technical specification documents have continued to evolve in the intervening time and contain the latest information available.  In the event of any discrepancies between the MDM/R Detailed Design document and the above-mentioned technical specification documents, the latter shall prevail.

CURRENT

MDM/R Specification:

Overview:

The MDM/R Specification is a series of documents that provides a comprehensive description of the Meter Data Management/Repository (MDM/R).  This series of documents are now under release management.  By following the link to the MDM/R Specification page, you have access of all of the documents that comprise the most recent release of the MDM/R Specification itself.  In addition, the MDM/R Specification page also has links to sub-pages that contain a history of each of the individual MDM/R specification documents.

Outstanding SME_IMDC documents:

n/a – not under change control.

Current Release Status:

Release 3.0 – Issued January 10, 2007

Documents included:

·          MDM/R Functional Specification

·          MDM/R Business Process Description

·          MDM/R Logical Application and Data Architecture (LADA)

·          MDM/R Service and Performance Levels

CLICK HERE  to access the MDM/R Specification page 

MDM/R Technical Interface and Reports SAMPLES

Status

Document

Samples

SAMPLES

MDM/R V1.0 Technical Interface Specifications Document:

Outstanding SME_IMDC documents:

None at this time.

Interface Sample Files available for download:

NOTE:  Technical Interface sample files are in TEXT file format and have the file extension: ‘.DAT’  Windows users please note:  To view these samples, you may need to configure your Windows "Folder Options" (see "file types" sub-menu) in order to associate the ‘.DAT’ file type with an appropriate application such as “Wordpad” or “Notepad”.

o    1000 Universal SDP ID Assignment Request

o    2000 Universal SDP ID Assignment Response

o    3000 Periodic Audit Synchronization – version 01

Note:  Nine of the Service Delivery Points contained within the file set below correspond to scenarios described in the following document: IAT Scenario Run 10 Details.

·          3000 Periodic Synchronization, ver. 01, File No. 00, segment no. 1 of 1  –  Manifest File

·          3000 Periodic Synchronization, ver. 01, File No. 01, segment no. 1 of 1  – Asset Data File

·          3000 Periodic Synchronization, ver. 01, File No. 02, segment no. 1 of 1  – Premise Data File

·          3000 Periodic Synchronization, ver. 01, File No. 03, segment no. 1 of 1  – Service Agreement Data File

·          3000 Periodic Synchronization, ver. 01, File No. 04, segment no. 1 of 2  – Parameter Data File

·          3000 Periodic Synchronization, ver. 01, File No. 04, segment no. 2 of 2  – Parameter Data File

·          3000 Periodic Synchronization, ver. 01, File No. 05, segment no. 1 of 1  – Relationship Data File

o    4000 Incremental Synchronization – version 00

Note:  Nine of the Service Delivery Points contained within the file set below correspond to scenarios described in the following document: IAT Scenario Run 11 Details.

·          4000 Incremental Synchronization, ver. 00, File No. 00, segment no. 1 of 1  –  Manifest File

·          4000 Incremental Synchronization, ver. 00, File No. 01, segment no. 1 of 1  – Asset Data File

·          4000 Incremental Synchronization, ver. 00, File No. 02, segment no. 1 of 1  – Premise Data File

·          4000 Incremental Synchronization, ver. 00, File No. 03, segment no. 1 of 1  – Service Agreement Data File

·          4000 Incremental Synchronization, ver. 00, File No. 04, segment no. 1 of 2  – Parameter Data File

·          4000 Incremental Synchronization, ver. 00, File No. 04, segment no. 2 of 2  – Parameter Data File

·          4000 Incremental Synchronization, ver. 00, File No. 05, segment no. 1 of 1  – Relationship Data File

o    5000 Billing Quantity Request

o   6000 Billing Quantity Response – TOU/CPP & Periodic

o   6100 Billing Quantity Response – Hourly

o    7000 Meter Read Interface (Sensus)

o    7100 Meter Read Interface (Elster)

Special Note Regarding Elster Meter Read Interface file sample: If you are using Internet Explorer, please note that your browser may not be able to interpret this.  To circumvent this, please right click on the link and save the file to your computer with a ‘.txt’ extension.  You should then be able to view the file on your computer as a text file.

o    7200 Meter Read Interface (Trilliant)

o    7300 Meter Read Interface (Tantalus)

o    8000 Billing Cycle Schedule File

o    9000 Data Aggregation File – Deferred

o    9100 Data Aggregation Contributors File – Deferred

Web Services Interfaces:

NOTES: 

1)     Each sample file below contains an example of both a request message and a reply message for each transaction type.

2)     If you are using Internet Explorer, please note that your browser may incorrectly try to view the text files below in XML format.  To circumvent this, please right click on the link and save the file to your computer with a ‘.txt’ extension.  You should then be able to view the file on your computer as a text file.

o    REQUEST AND REPLY SAMPLES: MP01 – Daily cumulative consumption

o    REQUEST AND REPLY SAMPLES: MP02 – Daily TOU consumption

o    REQUEST AND REPLY SAMPLES: MP03 – Interval consumption

o    REQUEST AND REPLY SAMPLES: MP04 – Daily TOU and Interval consumption

SAMPLES

MDM/R V1.0 Reports Technical Specifications:

Outstanding SME_IMDC documents:

None at this time.

Report Sample Files available for download:

NOTE:  Report sample files are in TEXT file format and have the file extension: ‘.DAT’  Windows users please note:  To view  these report samples, you may need to configure your Windows "Folder Options" (see "file types" sub-menu) in order to associate the ‘.DAT’ file type with an appropriate application such as “Wordpad” or “Notepad”.

Data Collection Reports:

o   Report DC01: Daily Read Status Report

o   Report DC02: Excessive Missing Reads Report

o   Report DC03: Interim Read Validation Failure Report   

o   Report DC04: Missing Reads Detail Report

o   Report DC05: Daily Data Collection Report

o   Report DC06: Interim AMCC Data Collection Summary Exception Report

o   Report DC07: Interim AMCC Data Collection Detailed Exception Report

o   Report DC08: Zero Consumption Report

o   Report DC13: Final Read Validation Failure Report

o   Report DC16: Final AMCC Data Collection Summary Exception Report

o   Report DC17: Final AMCC Data Collection Detailed Exception Report

Billing Reports:

o    Report BR01: Billing Delivery Summary Report

o    Report BR02: Unauthorized Usage Report

o    Report BR03: Re-Billing Report

o    Report BR04: Billing Detail Report

o    Report BR05: Data Aggregation Contributors Report  –  NOTE: Replaced by Data Aggregation Contributors File.  (ref. MDM/R Technical Interface Specification, section 2.12)

o    Report BR06: Billing No Reads Report

Interface Reports:

o    Report IR01: Universal SDP ID Assignment Request Summary Exception Report

o    Report IR02: Universal SDP ID Assignment Request Detailed Exception Report  - Withdrawn

o    Report IR03: Billing Cycle Schedule Exceptions Report 

o    Report IR04: Incremental Synchronization Updates Report – Withdrawn

o    Report IR05: Incremental Synchronization Exception Report – Withdrawn

o    Report IR06: Synchronization Updates Report

o    Report IR07: Synchronization Exception Report

o    Report IR08: Billing Request Detailed Exception Report

o    Report IR09: Billing Quantities Detailed Exception Report – Withdrawn

o    Report IR10: Incomplete Synchronization File Set

o    Report IR11: Billing Cycle Schedule Summary Exception Report  - Withdrawn

o    Report IR12: Billing Cycle Schedule Detailed Exception Report - Withdrawn

o    Report IR13: Incremental Synchronization Staging Table Loader Exception Report – Withdrawn

o    Report IR14: Synchronization Staging Table Loader Exception Report

o    Report IR17: FTS Processing Failure Report

VEE Processing Reports:

o    Report VE01: Interim Validation Failure Detail Report

o    Report VE02: Interim Estimation Failure Detail Report

o    Report VE03: Missing Interval Aging Report

o    Report VE04: VEE Summary Report

o    Report VE11: Final Validation Failure Detail Report

o    Report VE12: Final Estimation Failure Detail Report

Return to Homepage