RM26 - MDP Substitution and Estimation

RM26 report details

Purpose

Provides details of substitutions and estimations still current for a specified Settlement week

Content

A list of NMI Data Stream suffixes having an active Meter reading with a quality flag of substitute (S) or estimate (E) for each Settlement day within the request period

Request

Scheduled weekly (Sunday) after the approval of each Settlement run. Contact the Support Hub to request the automated report

Anytime from:

  • MSATS web portal
  • FTP

Delivery

Participant Outbox

Context type

SubstitutionEstimation

Priority

Medium

Role

MDP

Format

aseXML compliant XML message in a ZIP file

Row limit

10,000

Schema version

n/a

User rights access

Batch and Interactive: RM26 - MDP Substitution and Estimation

Input parameters

Field

Description

Web

Schema

Report Name

Name of report

N

M

Maximum Rows

Max rows to report

N

O

Start Date

Start date of data (max = 400 days)

M

M

End Date

End date of data (max = today)

M

M

Data Type

Interval, Consumption or All

Default = All

M

M

Output

Interval output

Field

Description

NMI

NMIs for the Settlement run

Suffix

Datastream suffix

Settlement Date

Period Settlement date

As At Date

The date and time the report runs

Filtered by

None

Grouped by

None

Ordered by

  1. NMI
  2. Suffix
  3. Settlement Date

Accumulation output

Field

Description

NMI

NMIs for the Settlement run

Suffix

Datastream suffix

Start Date

The start of the Settlement period

End Date

The end of the Settlement period

As At Date

The date and time the report runs

Filtered by

None

Grouped by

None

Ordered by

  1. NMI
  2. Suffix
  3. Start Date
  4. End Date

RM26 interval example

Copy
<ase:aseXML xmlns:ase="urn:aseXML:r31" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:aseXML:r31 http://www.nemmco.com.au/aseXML/schemas/r31/aseXML_r31.xsd">
<Header>
<From description="Australian Energy Market Operator Limited">NEMMCO</From>
<To description="Power Network - MDP">MDP123</To>
<MessageID>NEMMCO-MSG-654465659</MessageID>
<MessageDate>2017-05-01T16:00:24+10:00</MessageDate>
<TransactionGroup>MDMT</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="MDMT-654465659" transactionDate="2017-05-01T16:00:24+10:00" initiatingTransactionID="30791372">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:GenericReportParameters">
<ReportName>SubstitutionEstimation</ReportName>
<Parameters>
<Parameter xsi:type="ase:DateParameter">
<Name>FromDate</Name>
<Value>2016-03-28</Value>
</Parameter>
<Parameter xsi:type="ase:DateParameter">
<Name>ToDate</Name>
<Value>2016-03-31</Value>
</Parameter>
<Parameter xsi:type="ase:StringParameter">
<Name>DataType</Name>
<Value>Interval</Value>
</Parameter>
<Parameter xsi:type="ase:StringParameter">
<Name>MDP</Name>
<Value>MDP123</Value>
</Parameter>
<Parameter xsi:type="ase:IntegerParameter">
<Name>LastSequenceNumber</Name>
<Value>0</Value>
</Parameter>
</Parameters>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>NMI,SFX,SettDate,FRMP,LR,MDP,FLAG 2001007812,N1,2016/03/28,FRMP1,LR1,MDP123,SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 2001007812,N1,2016/03/29,FRMP1,LR1,MDP123,SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 2001007812,N1,2016/03/30,FRMP1,LR1,MDP123,SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 
etc.
etc.
etc.
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>

RM26 Accumulation example

Copy
<ase:aseXML xmlns:ase="urn:aseXML:r31" xmlns:xsi="http://www.w3.org/XXXX/XMLSchema-instance" xsi:schemaLocation="urn:aseXML:r31 http://www.nemmco.com.au/aseXML/schemas/r31/aseXML_r31.xsd">
<Header>
<From description="Australian Energy Market Operator Limited">NEMMCO</From>
<To description="SA Power Networks - MDP">MDP123</To>
<MessageID>NEMMCO-MSG-654465657</MessageID>
<MessageDate>2017-05-01T15:48:21+10:00</MessageDate>
<TransactionGroup>MDMT</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="MDMT-654465657" transactionDate="2017-05-01T15:48:21+10:00" initiatingTransactionID="30791371">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:GenericReportParameters">
<ReportName>SubstitutionEstimation</ReportName>
<Parameters>
<Parameter xsi:type="ase:DateParameter">
<Name>FromDate</Name>
<Value>2016-05-10</Value>
</Parameter>
<Parameter xsi:type="ase:DateParameter">
<Name>ToDate</Name>
<Value>2016-05-16</Value>
</Parameter>
<Parameter xsi:type="ase:StringParameter">
<Name>DataType</Name>
<Value>Consumption</Value>
</Parameter>
<Parameter xsi:type="ase:StringParameter">
<Name>MDP</Name>
<Value>MDP123</Value>
</Parameter>
<Parameter xsi:type="ase:IntegerParameter">
<Name>LastSequenceNumber</Name>
<Value>0</Value>
</Parameter>
</Parameters>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>NMI,SFX,START_DTE,END_DTE,FRMP,LR,MDP,FLAG,KWH XXXX004094,11,2016/04/11,2016/07/23,FRMP1,LR1,MDP123,E,7040.000 XXXX004094,21,2016/04/11,2016/07/23,FRMP1,LR1,MDP123,E,8434.000 XXXX004094,42,2016/04/11,2016/07/23,FRMP1,LR1,MDP123,E,0.000 XXXX004663,11,2016/04/07,2016/07/18,FRMP1,LR1,MDP123,E,1282.000 XXXX005277,11,2016/04/14,2016/05/26,FRMP5,LR1,MDP123,E,2304.000 
etc.
etc.
etc.
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>