RM17 - Level 3 Settlement Reconciliation for Non-Aggregated Data

RM17 report details

Purpose

Provides aggregated Interval Metering Data used during a Settlement run.

Used if the Level 2 Settlement Reconciliation Report (RM21) identifies anomalies for a specific TNI because it provides more detail

Content
  • Interval and Accumulation Datastream data supplied by MDPs
  • An optional data column called Profile Name allows FRMPs, LRs and MDPs to perform high-level Settlement reconciliations based on energy usage data such as Load Profile. To request the inclusion (or removal) of the this column, contact the Support Hub.
  • Participants only receive data for their own related NMIs

Request

A few days after a Settlement run or anytime from:

  • MSATS web portal
  • FTP

Delivery

Participant Outbox

Context type

Level3SettlementReconciliation

Priority

Medium

Role

FRMP, LR, MDP

Format

aseXML compliant XML message, with csv payload, in a ZIP file

Row limit

500

Schema version

r10

User rights access

Batch and Interactive: RM17 - L3 Settlement Reconciliation Report

Input parameters

Field

Description

Web

Schema

Report Name

Name of report

N

M

Maximum Rows

Max rows to report

N

O

Settlement Case ID

The specific run for the required data

M

M

Start Date

The start of the Settlement period

O

O

End Date

The end of the Settlement period

Must be less than 7 days for Interval Meters

O

O

Select NMIs starting with

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

O

O

NMI

Filter the report by a particular NMI

M

M

Report Last Sequence Number

Start report from sequence number

Initially zero

O

O

Output

Field

Description

Settlement Date

Period Settlement date

NMI

NMI

Suffix

Datastream suffix

Creation Date and Time

Date and time of report run

Settlement Run Date

Date and time of Settlement run

Period01,Period02,Period03……Period288

Interval data for periods 01–288

Status Flags

Quality Ffag associated with the meter read

Sequence Number

Row count

Grouping

Grouped by:

  1. TNI
  2. FRMP
  3. LR
  4. MDP
  5. Datastream type

RM17 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-654464360</MessageID>
<MessageDate>2017-04-18T16:15:57+10:00</MessageDate>
<TransactionGroup>MDMT</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="MDMT-654464360" 
transactionDate="2017-04-18T16:15:57+10:00" initiatingTransactionID="30791105">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:MDMTLevel3SettlementReconciliationReportParameters">
<ReportName>Level3SettlementReconciliation</ReportName>
<SettlementCase>6070</SettlementCase>
<FromDate>2016-08-28</FromDate>
<ToDate>2016-09-03</ToDate>
<LastSequenceNumber>0</LastSequenceNumber>
<NMI>2001005277</NMI>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>SettlementDate,NMI,Suffix,CreationDT,Period01,Period02,Period03,Period04,Period05,
Period06,Period07,Period08,Period09,Period10,Period11,Period12,Period13,Period14,Period15,
Period16,Period17,Period18,Period19,Period20,Period21,Period22,Period23,Period24,Period25,
Period26,Period27,Period28,Period29,Period30,Period31,Period32,Period33,Period34,Period35,
Period36,Period37,Period38,Period39,Period40,Period41,Period42,Period43,Period44,Period45,
Period46,Period47,Period48,StatusFlags,SeqNo 2016/08/28,XXXX005277,11,2017/04/13 14:00:38,
1.183,1.061,0.817,0.785,0.871,0.878,0.920,0.915,0.879,0.940,0.958,0.904,1.064,1.068,1.263,
1.353,1.357,1.296,1.139,0.992,0.797,0.656,0.378,0.352,0.339,0.389,0.322,0.356,0.379,0.404,
0.486,0.614,0.747,0.951,1.214,1.516,1.878,2.155,2.272,2.234,2.167,2.050,1.862,1.698,1.541,
1.307,0.481,0.907,PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP,1 2016/08/28,XXXX005277,
21,2017/04/13 
etc.
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>