RM16 - Level 1 Settlement Reconciliation Report

RM16 report details

Purpose

Provides aggregated Interval Metering Data used during a Settlement run

Content

Includes:

  • Data supplied by MDPs
  • Output of a Settlement run
  • Data from Interval and Accumulation Datastreams
  • An optional data column called Profile Name allowing FRMPs and LRs to perform high-level Settlement reconciliations based on energy usage data such as Load Profile. Participants request the inclusion (or removal) of the Profile Name column by contacting the Support Hub

If more detail is required for a specific TNI, see the Level 2 Settlement Reconciliation Report (RM21).

Request

Scheduled - contact the Support Hub to request the automated report

Requested a few days after a Settlement run or anytime from:

  • MSATS web portal
  • FTP

Delivery

Participant Outbox

Context type

Level1SettlementReconciliation

Priority

Low

Role

FRMP, LR, MDP

Format

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

Row limit

50,000

Schema version

r10

User rights access

Batch and Interactive: RM16 - L1 Settlement Reconciliation Report

Input parameters

Field

Description

Web

Schema

Report Name

Name of report

N

M

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

Output

Field

Description

TNI

TNI Code

DataType

Datastream type - Interval or consumption

FRMP

Associated FRMP

LR

Associated LR

MDP

Associated MDP

ProfileName (only displayed for subscribed participants)

Profile Name

CreationDT

Date and time the settlement is created

SettlementDate

settlement run date

Period01,Period02,Period03,….. Period48/Period288

Interval data for period 1 – 48/ 288

SeqNo

Row count

Grouping and Ordering

Grouped by:

  1. TNI
  2. Datastream Type
  3. Settlement Date
  4. FRMP
  5. LR
  6. MDP

Ordered by:

  1. Data Type
  2. FRMP
  3. TNI
  4. LR
  5. MDP
  6. Settlement Date
  7. Profile Name

 

RM16 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-654464354</MessageID>
<MessageDate>2017-04-18T14:27:01+10:00</MessageDate>
<TransactionGroup>MDMT</TransactionGroup>
<Priority>Low</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="MDMT-654464354" transactionDate="2017-04-18T14:27:01+10:00" 
initiatingTransactionID="30791100">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:MDMTSettlementCaseDateRangeReportParameters">
<ReportName>Level1SettlementReconciliation</ReportName>
<SettlementCase>6068</SettlementCase>
<FromDate>2016-08-28</FromDate>
<ToDate>2016-09-03</ToDate>
<LastSequenceNumber>0</LastSequenceNumber>
<SettlementRun>RREV2</SettlementRun>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>TNI,DataType,FRMP,LR,MDP,CreationDT,SettlementDate,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,SeqNo SJP1,C,FRMP6,LR1,MDP123,
2017/04/11 14:44:17,2016/08/28,159.144,148.829,125.986,102.084,94.242,84.473,86.946,87.806,79.114,83.293,
79.885,79.085,84.877,84.928,99.488,103.388,103.097,98.403,87.506,78.596,60.558,51.764,40.310,31.415,27.735,
32.231,26.932,28.088,28.778,30.711,36.924,48.216,57.343,75.089,94.207,117.830,146.382,167.890,174.455,
169.682,165.448,160.377,153.787,147.749,138.108,131.074,113.949,156.514,1 SJP1,C,FRMP6,LR1,MDP123,
2017/04/11 
etc.
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>