RM11 - Missing Data

RM11 report details

Purpose

Contains missing MDM metering data

Content
  • A list of dates for NMI Datastreams where the NMI suffixes exist in CATS but no meter readings exist in MDM
  • Reports missing net reads where the Metering Data is received as Ex and Bx with a corresponding MDM Datastream identifier to the active net Datastream

Request

Scheduled prior to each Settlement run according to the MDP Data Delivery Calendar

Anytime from:

  • MSATS web portal
  • FTP

Delivery

Participant Outbox

Retention

13 months until metering data is archived

Context type

MissingData

Priority

Medium

Role

FRMP, LR, MDP

Format

Zipped aseXML compliant XML message with csv payload

Row limit

20,000

Schema version

r10

User rights access

Batch and Interactive: RM11 - MDM Missing Data (null) Report

Input parameters

Field

Description

Web

Schema

Report name

MissingData

N

M

Maximum rows

Max rows to report

N

O

Start Date

The start of the Settlement period

Max request = Today - 6 days

M

M

End Date

The end of the Settlement period

Max = today

M

M

Select NMIs starting with

Use to enable a faster search by reducing the number of NMIs displayed

O

O

NMI

Filter by a NMI

O

O

MDP

The MDP who submitted the Meter data

FRMPs and LRs can report all MDPs where they are the participant on the NMI

O

O

As At Date

Determines the date of the data retrieval

Max = today

Default = today

M

M

As At Time

Determines the time of the data retrieval

Default = 00:00

M

M

Data Type

Interval or consumption

Default = Interval

M

M

NMI Selection

Include second tier (where during the nominated start and end dates the FRMP was not the same as the LR) or all NMIs

Default = Second Tier

M

O

default = all NMIs

Deliver to

MDP

O

O

Run Date

Date to run the report

O

O

Run Time

Time to run the report

O

O

Report Last Sequence Number

Start report results from record

Initially zero

O

O

Schema version

Default = r10

N

O

Output

Field

Description

MDP

Metering Data Provider

NMI

NMI for missing data

NMI Suffix

Datastream suffix

Settlement Date

Date of missing reading

Sequence Number

Row count

Filtered by

  1. MDP

  2. FRMPs and LRs can report all MDPs where they are the participant on the NMI

  3. NMI Selection

  4. All NMIs

  5. Tier 2 Only NMI’s

Grouped by

None

Ordered by

  1. MDP

  2. NMI

  3. Suffix

  4. Settlement Date

RM11 Accumulation 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">MDP456</To>
<MessageID>NEMMCO-MSG-654462962</MessageID>
<MessageDate>2017-04-12T13:38:59+10:00</MessageDate>
<TransactionGroup>MDMT</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="MDMT-654462962" transactionDate="2017-04-12T13:38:59+10:00" initiatingTransactionID="30790291">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:MDMTMissingDataReportParameters">
<ReportName>MissingData</ReportName>
<FromDate>2017-04-06</FromDate>
<ToDate>2017-04-12</ToDate>
<AsAtDate>2017-04-12T00:00:00+10:00</AsAtDate>
<LastSequenceNumber>0</LastSequenceNumber>
<MDP>MDP456</MDP>
<DataType>Consumption</DataType>
<NMISelection>AllNMIs</NMISelection>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>MDP,SettlementDate,NMI,Suffix,SeqNo MDP456,2017/04/06,XXXX003743,11,1 MDP456,2017/04/07,XXXX003743,11,2 MDP456,2017/04/08,XXXX003743,11,3 MDP456,2017/04/09,XXXX003743,11,4 MDP456,2017/04/10,XXXX003743,11,5 MDP456,2017/04/11,XXXX003743,11,6 MDP456,2017/04/12,XXXX003743,11,7 MDP456,2017/04/06,XXXX003743,31,8 MDP456,2017/04/07,XXXX003743,31,9 MDP456,2017/04/08,XXXX003743,31,10 MDP456,2017/04/09,XXXX003743,31,11 
etc
etc
etc
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>

RM11 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-654464337</MessageID>
<MessageDate>2017-04-18T10:33:13+10:00</MessageDate>
<TransactionGroup>MDMT</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="MDMT-654464337" transactionDate="2017-04-18T10:33:13+10:00" initiatingTransactionID="30791083">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:MDMTMissingDataReportParameters">
<ReportName>MissingData</ReportName>
<FromDate>2017-04-12</FromDate>
<ToDate>2017-04-18</ToDate>
<AsAtDate>2017-04-18T00:00:00+10:00</AsAtDate>
<LastSequenceNumber>0</LastSequenceNumber>
<MDP>MDP123</MDP>
<DataType>Interval</DataType>
<NMISelection>AllNMIs</NMISelection>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>MDP,SettlementDate,NMI,Suffix,SeqNo MDP123,2017/04/12,XXXX006316,N1,1 MDP123,2017/04/13,XXXX006316,N1,2 MDP123,2017/04/14,XXXX006316,N1,3 MDP123,2017/04/15,XXXX006316,N1,4 MDP123,2017/04/16,XXXX006316,N1,5 MDP123,2017/04/17,XXXX006316,N1,6 MDP123,2017/04/18,XXXX006316,N1,7 MDP123,2017/04/12,XXXX006424,N1,8 MDP123,2017/04/13,XXXX006424,N1,9 MDP123,2017/04/14,XXXX006424,N1,10 MDP123,2017/04/15,XXXX006424,N1,11 MDP123,2017/04/16,XXXX006424,N1,12 MDP123,2017/04/17,XXXX006424,N1,13 MDP123,2017/04/18,XXXX006424,N1,14 MDP123,2017/04/12,XXXX007812,N1,15 
etc
etc
etc
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>