C4 – NMI Master Report

C4 report details

Purpose

For a nominated billing period and date, you can obtain data for a single NMI or group of NMIs from each of the master tables

Example uses:

  1. Retailer report on won customers: Participant = Retailer, Role is NOT selected, Role = Local Retailer.
  2. Retailer report on lost customers: Participant = Retailer, Role is NOT selected, Role = FRMP

Content

The data returned includes information from all of the master tables:

  • CATS NMI Data
  • CATS Participant Relationships
  • CATS Data Streams
  • CATS Meter Register
  • CATS Register Identifier

Automated

Yes.

If participants have a new role of: FRMP, LNSP, LR, MDP, MPB, NSP2, or RP they automatically receive this report on completion of the CR 1000 range, including CR102X, any role change CR, and reversal CRs (1060 & 1061)

Request methods

Anytime from:

  1. MSATS web portal
  2. FTP

Delivery

Participant Outbox

Context type

Master

Priority

Low

Role

MC, FRMP, LR, LNSP, ENM, NSP2, MPB, MPC, MDP, DRSP

Format

Zipped aseXML compliant XML message with csv payload

Row limit

500

Schema version

r35

User rights access

Batch and Interactive: C4 - NMI Master Report

Input parameters

Field Name

Description

Web

Schema

Select NMIs starting with

To run the report for a specific NMI, type the partial or full NMI and click Apply This field is case sensitive so use upper case letters where required

O

n/a

NMI

Select your NMI from the drop-down list (if they exist).

If the list is too long, add further characters in the Select NMIs starting with field and click Apply

O

M

Start Date

Start date for trading day

Refers to the start and end dates for records in the CATS NMI Data table

For example, if you want records for:

  1. The current day: enter today’s date in both fields
  2. A full settlement week: enter the start and end dates of the settlement week

Default = today - 6

M

M

End Date

End date for trading day

To return a record:

  • The time between the record’s Start and End Dates must overlap at least part of the period covered by the report
  • It must have existed during the report's As At Date.
  • You must have the right to see the record. These are the Standing Data Access Rules (see Technical Guide to MSATS). MSATS applies the Standing Data Access Rules based on the overlapping roles a participant has for the record, not only the roles overlapping the report period.

M

M

As At Date

Report as at date

What the master records looked like on that date (active records for the nominated start and end dates), excluding any prior or subsequent changes

Checked against the MAINTCREATEDT and the MAINTUPDTDT

Default = today

M

M

Participant is NOT

Select to exclude a participant

O

M

Participant

Find all NMIs where a participant does or does not have a relationship with a NMI

M

M

Role is NOT

Select to exclude a role

O

M

Role ID

Participant role

For details, see Participant and role ID filter options

M

M

NMI Classification Code

NMI Classification Code

M if no NMI selected

M if no NMI selected

Jurisdiction Code

Jurisdiction Code

M if no NMI selected

M if no NMI selected

Report Type

Summary or Detailed

For details, see output below

M

M

Report Last Sequence Number

Results sequence to start report

Initially zero

M

M

Participant and role ID filter options

Not participant

Participant

Not role

Role

Entitled to see NMIs returned

□

All

□

FRMP

All FRMP role relationships

□

All

þ

FRMP

All role relationships, except FRMP

□

Participant B

□

Blank

All where Participant B plays a role

□

Participant B

□

FRMP

All where Participant B is the FRMP

□

Participant B

þ

FRMP

All where Participant B is not the FRMP

þ

Participant B

□

Blank

All where Participant B does not play a role

þ

Participant B

□

FRMP

All where Participant B is not the FRMP

þ

Participant B

þ

FRMP

All where Participant B is the FRMP

Summary output

Common fields

Table 79 Common fields in output for all tables.

Field

Description

SequenceNumber

The unique identifier for this table allocated when the record is created.

If a report returns the maximum number of rows allowed, the last value in this field, for this table, is the one entered in the Sequence No field in the input parameters when you run the report again

CreationDate

The date the record was originally created

MaintenanceDate

The date the NMI data record was updated

The active date is 31/12/9999

If the record is inactive, it is the date the record was made inactive

RowStatus

Identifies if the record is active (A) or inactive (I).

If it is I, the record is replaced by one or more new records covering the period of time between the record’s start and end dates

FromDate

The start date the record applies from

ToDate

The end date until the record applies.

A ToDate of 31/12/9999 is a date in the future

NMI

Unique National Metering Identifier

Status

Code used to indicate the status of the NMI

CATS_NMI_Data

Field

Description

JurisdictionCode

Jurisdiction code the NMI belongs to

NMIClassificationCode

NMI Classification code the NMI belongs to

TransmissionNodeIdentifier

Transmission Node ID

DistributionLossFactorCode

DLF Code used to indicate the DLF value for the NMI

Aggregate

Used by MDM to determine which settlement reports the data goes to

EmbeddedNetworkParent

Code used to identify which embedded network the NMI is a parent of

EmbeddedNetworkChild

Code used to identify which embedded network the NMI is a child of

CATS_Participant_Relationships

Field

Description

Party

The identifier of the participant who is allocated the given role

CATS_NMI_Data_Streams

Field

Description

Suffix

Unique identifier for the Data Stream

ProfileName

Profile name assigned to the NMI

NOPROF indicates the Data Stream’s Metering Data is Interval Metering Data

AveragedDailyLoad

The electrical energy delivered through a Connection Point or Metering Point over an extended period normalised to a per-day basis

DataStreamType

Either Interval or Accumulated Metering Data

CATS_Meter_Register

Field

Description

Serial Number

The number uniquely identifying a NMI's Meter

NextScheduledReadDate

Indicates the next scheduled read for the Meter if it is manually read

CATS_Register_Identifier

Field

Description

Serial Number

The number uniquely identifying a NMI's Meter

RegisterID

The ID uniquely identifying a register record for a metering installation

Detailed output

The detailed report contains all fields from the following master tables:

  • CATS NMI Data
  • CATS Participant Relationships
  • CATS Data Streams
  • CATS Meter Register
  • CATS Register Identifier

C4 detailed report example

Copy 
<?xml version="1.0"?>
-<ase:aseXML xsi:schemaLocation="urn:aseXML:r43 http://www.nemmco.com.au/aseXML/schemas/r43/aseXML_r43.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ase="urn:aseXML:r43">
-<Header>
<From description="Australian Energy Market Operator Limited">NEMMCO</From>
<To description="Australian Energy Market Operator Limited">NEMMCO</To>
<MessageID>NEMMCO-MSG-660175269</MessageID>
<MessageDate>2023-08-14T11:19:20+10:00</MessageDate>
<TransactionGroup>CATS</TransactionGroup>
<Priority>High</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
-<Transactions>
    -<Transaction initiatingTransactionID="31581724" transactionDate="2023-08-14T11:19:20+10:00" transactionID="CATS-660175269">
        -<ReportResponse version="r39">
            -<ReportParameters xsi:type="ase:CATSMasterReportParameters">
                <ReportName>Master</ReportName>
                <FromDate>2023-06-01</FromDate>
                <ToDate>2023-08-14</ToDate>
                <AsAtDate>2023-06-30</AsAtDate>
                <LastSequenceNumber>0</LastSequenceNumber>
                <NMI>2001005277</NMI>
                <ExcludeParticipant>No</ExcludeParticipant>
                <Participant>SOLARIS</Participant>
                <ExcludeRole>No</ExcludeRole>
                <Role>ALL</Role>
                <ReportType>Summary</ReportType>
            </ReportParameters>
            -<ReportResults xsi:type="ase:ReplicationReportFormat">
                -<ReplicationBlock tableName="ElectricityNMIMaster">
                    -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIMasterRow">
                        <SequenceNumber>89440748</SequenceNumber>
                        <CreationDate>2022-07-21T16:47:45+10:00</CreationDate>
                        <MaintenanceDate>2023-08-11T00:10:30+10:00</MaintenanceDate>
                        <RowStatus>I</RowStatus>
                        <FromDate>2022-07-20T00:00:00+10:00</FromDate>
                        <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                        <NMI>2001005277</NMI>
                        <JurisdictionCode>ACT</JurisdictionCode>
                        <NMIClassificationCode>LARGE</NMIClassificationCode>
                        <TransmissionNodeIdentifier>AQB2</TransmissionNodeIdentifier>
                        <DistributionLossFactorCode>AL00</DistributionLossFactorCode>
                        <Aggregate>Yes</Aggregate>
                        <Status>A</Status>
                        <TransmissionNodeIdentifier2>NBFS</TransmissionNodeIdentifier2>
                        <MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
                        <MeterMalfunctionExemptionExpiryDate>0023-07-11</MeterMalfunctionExemptionExpiryDate>
                    </Row>
                </ReplicationBlock>
            -<ReplicationBlock tableName="ElectricityNMIRoles">
                -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>221431286</SequenceNumber>
                    <CreationDate>2022-07-21T16:47:45+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2022-07-20T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>SOLARIS</Party>
                    <Role>FRMP</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>44165446</SequenceNumber>
                    <CreationDate>2003-02-26T01:09:04+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2002-12-10T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>UMPLP</Party>
                    <Role>LNSP</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>44165447</SequenceNumber>
                    <CreationDate>2003-02-26T01:09:04+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2002-12-10T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>AGLE</Party>
                    <Role>LR</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>162433414</SequenceNumber>
                    <CreationDate>2013-02-16T00:27:14+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2012-10-12T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>ETSAMDP</Party>
                    <Role>MDP</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>75637822</SequenceNumber>
                    <CreationDate>2006-06-20T00:30:35+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2005-12-05T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>ETSAPMP</Party>
                    <Role>MPB</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>75637823</SequenceNumber>
                    <CreationDate>2006-06-20T00:30:35+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2005-12-05T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>ETSAMDP</Party>
                    <Role>MPC</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>44165450</SequenceNumber>
                    <CreationDate>2003-02-26T01:09:04+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2002-12-10T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>ETSAUTIL</Party>
                    <Role>ROLR</Role>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIRoleRow">
                    <SequenceNumber>207950378</SequenceNumber>
                    <CreationDate>2016-04-02T02:13:51+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2016-03-31T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Party>UMPLP</Party>
                    <Role>RP</Role>
                </Row>
            </ReplicationBlock>
            -<ReplicationBlock tableName="ElectricityNMIDataStreams">
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIDataStreamRow">
                    <SequenceNumber>201144215</SequenceNumber>
                    <CreationDate>2022-07-21T16:47:45+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2022-07-20T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Suffix>11</Suffix>
                    <ProfileName>NSLP</ProfileName>
                    <AveragedDailyLoad>100</AveragedDailyLoad>
                    <DataStreamType>Consumption</DataStreamType>
                    <Status>A</Status>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIDataStreamRow">
                    <SequenceNumber>159700253</SequenceNumber>
                    <CreationDate>2015-02-16T00:43:10+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2015-02-12T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <Suffix>21</Suffix>
                    <ProfileName>NSLP</ProfileName>
                    <AveragedDailyLoad>68</AveragedDailyLoad>
                    <DataStreamType>Consumption</DataStreamType>
                    <Status>A</Status>
                </Row>
            </ReplicationBlock>
            -<ReplicationBlock tableName="ElectricityNMIMeters">
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIMeterRow">
                    <SequenceNumber>79674878</SequenceNumber>
                    <CreationDate>2019-01-31T00:10:19+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2019-01-30T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <SerialNumber>125667</SerialNumber>
                    <NextScheduledReadDate>2016-05-16</NextScheduledReadDate>
                </Row>
            </ReplicationBlock>
            -<ReplicationBlock tableName="ElectricityNMIRegisterConfiguration">
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIMeterRegisterRow">
                    <SequenceNumber>104632938</SequenceNumber>
                    <CreationDate>2022-07-21T16:47:45+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2022-07-20T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <SerialNumber>125667</SerialNumber>
                    <RegisterID>1</RegisterID>
                </Row>
            -<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIMeterRegisterRow">
                    <SequenceNumber>9365923</SequenceNumber>
                    <CreationDate>2003-03-14T01:30:53+10:00</CreationDate>
                    <MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
                    <RowStatus>A</RowStatus>
                    <FromDate>2002-12-10T00:00:00+10:00</FromDate>
                    <ToDate>9999-12-31T00:00:00+10:00</ToDate>
                    <NMI>2001005277</NMI>
                    <SerialNumber>125667</SerialNumber>
                    <RegisterID>2</RegisterID>
                </Row>
            </ReplicationBlock>
            </ReportResults>
            -<Event severity="Information">
                <Code>0</Code>
                <Explanation>Success</Explanation>
            </Event>
        </ReportResponse>
    </Transaction>
</Transactions>
</ase:aseXML>