Snapshot report

Purpose	A snapshot report provides all NMI Standing Data records a participant ID can access, according to the CATS Standing Data Access Rules. It includes current, historic, active, and inactive records. AEMO recommends requesting a snapshot report only during bulk data correction or bulk data loading tasks.
CATS Standing Data Access Rules	Participants are entitled to all rows where, during the period the row was active, the participant had a relationship with the NMI overlapping at least part of the period between the Start Date and End Date on the row.
Row limits	There are no row limits, but high volumes of data may impact performance during busy times. AEMO mitigate this risk by running snapshot reports at its discretion.
Allocation	Two free reports each year. To reduce the load on AEMO’s systems, you should request snapshot reports infrequently.
Request methods	Request a snapshot report from the Support Hub, providing the following details: Participant ID Requestor Name MSATS UserID Position Email Email address for provision of password (if different from above) Position email Contact number Reason for report request * Snapshot type - Incremental or Full Authorisation attached Number of snapshots received this financial year AEMO will email a password to extract the files. MSATS tables required: CATS_NMI_PARTICIPANT_RELATIONS CATS_NMI_DATA CATS_NMI_DATA_STREAM CATS_METER_REGISTER CATS_REGISTER_IDENTIFIER
Delivery	Preferred delivery method (dependent on file size): CD Mailing address (if file is over 1 MB) Email Participant File Server To keep file sizes manageable, AEMO may split a report across multiple files and zipped. • Files less than 1 MB zipped are emailed or delivered to the root directory of the participants MSATS Participant File Server. • Files over 1 MB zipped are delivered via web transfer.
File name	Zipped aseXML format using the same: <ReportResults xsi:type="ase:ReplicationReportFormat" /> used by C4 reports to present NMI Standing Data. Example zipped file name: Snapshot_PARTID_CMR_20020423111741.zip Example report file name: Snapshot_PARTID_CMR_20020423111741_P000001.xml Where CMR is short for CATS_METER_REGISTER and P000001 is the split file count for large reports. Example report file name: Snapshot_SOLARIS_CND_20230814122635_P000001.xml Where CND is short for CATS NMI Data and P000001 is the split file count for large reports.
Report detail	The NMI Standing Data for an individual NMI is spread across multiple files, with each report file containing records from only one table. You can request records from the following tables: • CATS_NMI_DATA • CATS_PARTICIPANT_RELATIONS • CATS_NMI_DATA_STREAM • CATS_METER_REGISTER • CATS_REGISTER_IDENTIFIER
Report parameters	<ReportParameters xsi:type="ase:CATSSnapshotReportParameters"> <ReportName>Snapshot</ReportName> <Participant>TEST</Participant> <AsAtDateTime>2002-04-23T11:17:53+10:00</AsAtDateTime> <Tables> <Table>CATS_NMI_DATA_STREAM</Table> </Tables> <LastSequenceNumber>0</LastSequenceNumber> </ReportParameters>
Schema version	If participants use schema validation on input to their systems, their schema version must be compatible with AEMO’s schema version. All Snapshots are produced in the latest schema format. For details about the latest B2M schema version, see MSATS Web Portal > Participants > Participant aseXML Schema > aseXML schema version. For more details about the CATS Standing Data Access Rules, see Technical Guide to MSATS.

Snapshot example

Copy

<?xml version="1.0" encoding="UTF-8"?>
-<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="NEMMCO">NEMMCO</From>
<To description="AGL Sales Pty Limited">SOLARIS</To>
<MessageID>a76940ab-1e31-48be-9b5c-a94e947f94ee</MessageID>
<MessageDate>2023-08-14T12:26:35+10:00</MessageDate>
<TransactionGroup>CATS</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>None</SecurityContext>
<Market>NEM</Market>
</Header>
-<Transactions>
-<Transaction transactionDate="2023-08-14T12:26:35+10:00" transactionID="a76940ab-1e31-48be-9b5c-a94e947f94ee">
-<ReportResponse version="r39">
-<ReportParameters xsi:type="ase:CATSSnapshotReportParameters">
<ReportName>Snapshot</ReportName>
<Participant>SOLARIS</Participant>
<AsAtDateTime>2023-08-14T12:26:35+10:00</AsAtDateTime>
-<Tables>
<Table>CATS_NMI_DATA</Table>
</Tables>
<LastSequenceNumber>1</LastSequenceNumber>
</ReportParameters>
-<ReportResults xsi:type="ase:ReplicationReportFormat">
-<ReplicationBlock tableName="ElectricityNMIMaster">
-<Row 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>
-<Address>
-<StructuredAddress>
-<FlatOrUnit>
<FlatOrUnitType>APT</FlatOrUnitType>
<FlatOrUnitNumber>306</FlatOrUnitNumber>
</FlatOrUnit>
-<FloorOrLevel>
<FloorOrLevelType>L</FloorOrLevelType>
<FloorOrLevelNumber>3</FloorOrLevelNumber>
</FloorOrLevel>
<BuildingOrPropertyName>2</BuildingOrPropertyName>
-<House>
<HouseNumber>306</HouseNumber>
<HouseNumberSuffix>3</HouseNumberSuffix>
</House>
-<Lot>
<DPNumber>A DP NUMBER</DPNumber>
</Lot>
-<Street>
<StreetName>CSEMAPHORE</StreetName>
<StreetType>RD</StreetType>
<StreetSuffix>W</StreetSuffix>
</Street>
</StructuredAddress>
<SuburbOrPlaceOrLocality>DPARRAMATTA</SuburbOrPlaceOrLocality>
<StateOrTerritory>NSW</StateOrTerritory>
<PostCode>2150</PostCode>
<DeliveryPointIdentifier>92520416</DeliveryPointIdentifier>
</Address>
<Aggregate>Yes</Aggregate>
<Status>A</Status>
<CustomerClassificationCode>BUSINESS</CustomerClassificationCode>
<CustomerThresholdCode>MEDIUM</CustomerThresholdCode>
<TransmissionNodeIdentifier2>NBFS</TransmissionNodeIdentifier2>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-11</MeterMalfunctionExemptionExpiryDate>
</Row>
-<Row xsi:type="ase:ElectricityNMIMasterRow">
<SequenceNumber>89440803</SequenceNumber>
<CreationDate>2023-08-11T00:10:30+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>2023-07-30T00:00:00+10:00</ToDate>
<NMI>2001005277</NMI>
<JurisdictionCode>ACT</JurisdictionCode>
<NMIClassificationCode>LARGE</NMIClassificationCode>
<TransmissionNodeIdentifier>AQB2</TransmissionNodeIdentifier>
<DistributionLossFactorCode>AL00</DistributionLossFactorCode>
-<Address>
-<StructuredAddress>
-<FlatOrUnit>
<FlatOrUnitType>APT</FlatOrUnitType>
<FlatOrUnitNumber>306</FlatOrUnitNumber>
</FlatOrUnit>
-<FloorOrLevel>
<FloorOrLevelType>L</FloorOrLevelType>
<FloorOrLevelNumber>3</FloorOrLevelNumber>
</FloorOrLevel>
<BuildingOrPropertyName>2</BuildingOrPropertyName>
-<House>
<HouseNumber>306</HouseNumber>
<HouseNumberSuffix>3</HouseNumberSuffix>
</House>
-<Lot>
<DPNumber>A DP NUMBER</DPNumber>
</Lot>
-<Street>
<StreetName>CSEMAPHORE</StreetName>
<StreetType>RD</StreetType>
<StreetSuffix>W</StreetSuffix>
</Street>
</StructuredAddress>
<SuburbOrPlaceOrLocality>DPARRAMATTA</SuburbOrPlaceOrLocality>
<StateOrTerritory>NSW</StateOrTerritory>
<PostCode>2150</PostCode>
<DeliveryPointIdentifier>92520416</DeliveryPointIdentifier>
</Address>
<Aggregate>Yes</Aggregate>
<Status>A</Status>
<CustomerClassificationCode>BUSINESS</CustomerClassificationCode>
<CustomerThresholdCode>MEDIUM</CustomerThresholdCode>
<TransmissionNodeIdentifier2>NBFS</TransmissionNodeIdentifier2>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-11</MeterMalfunctionExemptionExpiryDate>
</Row>
-<Row xsi:type="ase:ElectricityNMIMasterRow">
<SequenceNumber>89440804</SequenceNumber>
<CreationDate>2023-08-11T00:10:30+10:00</CreationDate>
<MaintenanceDate>2023-08-12T00:10:20+10:00</MaintenanceDate>
<RowStatus>I</RowStatus>
<FromDate>2023-07-31T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2001005277</NMI>
<JurisdictionCode>NSW</JurisdictionCode>
<NMIClassificationCode>SAMPLE</NMIClassificationCode>
<TransmissionNodeIdentifier>AQB2</TransmissionNodeIdentifier>
<DistributionLossFactorCode>AL00</DistributionLossFactorCode>
-<Address>
-<StructuredAddress>
-<FlatOrUnit>
<FlatOrUnitType>APT</FlatOrUnitType>
<FlatOrUnitNumber>306</FlatOrUnitNumber>
</FlatOrUnit>
-<FloorOrLevel>
<FloorOrLevelType>FL</FloorOrLevelType>
<FloorOrLevelNumber>3</FloorOrLevelNumber>
</FloorOrLevel>
<BuildingOrPropertyName>2</BuildingOrPropertyName>
<LocationDescriptor>BALMORAL ST</LocationDescriptor>
-<House>
<HouseNumber>51</HouseNumber>
<HouseNumberSuffix>3</HouseNumberSuffix>
<HouseNumberTo>53</HouseNumberTo>
</House>
-<Lot>
<LotNumber>51</LotNumber>
<DPNumber>A DP NUMBER</DPNumber>
</Lot>
-<Street>
<StreetName>BALMORAL</StreetName>
<StreetType>ST</StreetType>
<StreetSuffix>W</StreetSuffix>
</Street>
</StructuredAddress>
<SuburbOrPlaceOrLocality>WAITARA</SuburbOrPlaceOrLocality>
<StateOrTerritory>NSW</StateOrTerritory>
<PostCode>2077</PostCode>
<DeliveryPointIdentifier>92520416</DeliveryPointIdentifier>
</Address>
<Aggregate>No</Aggregate>
<Status>A</Status>
<CustomerClassificationCode>BUSINESS</CustomerClassificationCode>
<CustomerThresholdCode>MEDIUM</CustomerThresholdCode>
<TransmissionNodeIdentifier2>NBFS</TransmissionNodeIdentifier2>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-11</MeterMalfunctionExemptionExpiryDate>
</Row>
-<Row xsi:type="ase:ElectricityNMIMasterRow">
<SequenceNumber>89440805</SequenceNumber>
<CreationDate>2023-08-12T00:10:20+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2023-07-31T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2001005277</NMI>
<JurisdictionCode>NSW</JurisdictionCode>
<NMIClassificationCode>SAMPLE</NMIClassificationCode>
<TransmissionNodeIdentifier>AQB2</TransmissionNodeIdentifier>
<DistributionLossFactorCode>AL00</DistributionLossFactorCode>
-<Address>
-<StructuredAddress>
-<FlatOrUnit>
<FlatOrUnitType>APT</FlatOrUnitType>
<FlatOrUnitNumber>306</FlatOrUnitNumber>
</FlatOrUnit>
-<FloorOrLevel>
<FloorOrLevelType>FL</FloorOrLevelType>
<FloorOrLevelNumber>3</FloorOrLevelNumber>
</FloorOrLevel>
<BuildingOrPropertyName>2</BuildingOrPropertyName>
<LocationDescriptor>BALMORAL ST</LocationDescriptor>
-<House>
<HouseNumber>51</HouseNumber>
<HouseNumberSuffix>3</HouseNumberSuffix>
<HouseNumberTo>53</HouseNumberTo>
</House>
-<Lot>
<LotNumber>51</LotNumber>
<DPNumber>A DP NUMBER</DPNumber>
</Lot>
-<Street>
<StreetName>BALMORAL</StreetName>
<StreetType>ST</StreetType>
<StreetSuffix>W</StreetSuffix>
</Street>
</StructuredAddress>
<SuburbOrPlaceOrLocality>WAITARA</SuburbOrPlaceOrLocality>
<StateOrTerritory>NSW</StateOrTerritory>
<PostCode>2077</PostCode>
<DeliveryPointIdentifier>92520416</DeliveryPointIdentifier>
</Address>
<Aggregate>No</Aggregate>
<Status>A</Status>
<CustomerClassificationCode>BUSINESS</CustomerClassificationCode>
<CustomerThresholdCode>MEDIUM</CustomerThresholdCode>
<TransmissionNodeIdentifier2>NBFS</TransmissionNodeIdentifier2>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-11</MeterMalfunctionExemptionExpiryDate>
</Row>
-<Row xsi:type="ase:ElectricityNMIMasterRow">
<SequenceNumber>22244530</SequenceNumber>
<CreationDate>2023-07-11T13:06:07+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2023-06-22T00:00:00+10:00</FromDate>
<ToDate>9999-01-31T00:00:00+10:00</ToDate>
<NMI>4001003734</NMI>
<JurisdictionCode>NSW</JurisdictionCode>
<NMIClassificationCode>SMALL</NMIClassificationCode>
<TransmissionNodeIdentifier>NRGE</TransmissionNodeIdentifier>
<DistributionLossFactorCode>BL24</DistributionLossFactorCode>
-<Address>
<StructuredAddress/>
<SuburbOrPlaceOrLocality>ORANGE</SuburbOrPlaceOrLocality>
<StateOrTerritory>NSW</StateOrTerritory>
<PostCode>2800</PostCode>
</Address>
<Aggregate>Yes</Aggregate>
<Status>A</Status>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-14</MeterMalfunctionExemptionExpiryDate>
</Row>
-<Row xsi:type="ase:ElectricityNMIMasterRow">
<SequenceNumber>48438119</SequenceNumber>
<CreationDate>2010-10-31T00:34:35+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2010-10-30T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>4001003734</NMI>
<JurisdictionCode>NSW</JurisdictionCode>
<NMIClassificationCode>SMALL</NMIClassificationCode>
<TransmissionNodeIdentifier>NRGE</TransmissionNodeIdentifier>
<DistributionLossFactorCode>BL0A</DistributionLossFactorCode>
-<Address>
-<StructuredAddress>
-<Lot>
<DPNumber>A DP NUMBER</DPNumber>
</Lot>
</StructuredAddress>
<SuburbOrPlaceOrLocality>ORANGE</SuburbOrPlaceOrLocality>
<StateOrTerritory>NSW</StateOrTerritory>
<PostCode>2800</PostCode>
<DeliveryPointIdentifier>51247688</DeliveryPointIdentifier>
</Address>
<Aggregate>Yes</Aggregate>
<Status>A</Status>
<CustomerClassificationCode>RESIDENTIAL</CustomerClassificationCode>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-14</MeterMalfunctionExemptionExpiryDate>
</Row>
</ReplicationBlock>
</ReportResults>
-<Event severity="Information">
<Code>0</Code>
<Explanation>Success</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>