C1 - Data Replication Resynchronisation Report

C1 report details

Purpose

A synchronisation report designed for participants to replicate data from a single MSATS table if they did not receive all notifications or lost access to MSATS for a short time. It assists participant to keep local copies of CATS Standing Data in sync with MSATS.

To work with records in a C1 Report you must understand the CATS History Model and the Standing Data Access Rules. For details, see Technical Guide to MSATS

Content

Returns records from one chosen table and according to the Standing Data Access Rules

Request methods

Anytime from:

  • MSATS web portal
  • FTP

Delivery

Participant Outbox

Context type

Data Replication Resynchronisation Report

Priority

Medium

Role

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

Format

Zipped aseXML compliant XML message with csv payload

Row limit

Min = 100

Max = 30,000

Schema version

n/a

User rights access

Batch and Interactive: C1 - Data Replication Resynchronisation Report

Input parameters

Field Name

Description

Web

Schema

Report Name

Name of report

N

M

Maximum Rows

Maximum number of rows returned

Default = 200

O

O

Start Date

The start date for all records you are entitled to view. MSATS must have created or updated each record on or after this date.

For a record to return, the MaintCreatedt or the MaintUpdtdT must be between the Report Start Date and Time From and Report End Date and Time To

Default = previous 7 days

M

M

End Date

The end date for all records you are entitled to view. MSATS must have created or updated each record on or after this date

Default = today

Each record's create or update date must be on or after the Start and End Dates

M

M

Time From (hh:mm:ss)

The time for all records you are entitled to view. MSATS must have created or updated each record on or after this time

Default = 00:00:00

O

M

Time To (hh:mm:ss)

The end time for all records you are entitled to view. MSATS must have created or updated each record on or after this time

Default = 23:59:59

O

M

Tables

Table for replication, see C1 report tables

M

M

Report Last Sequence Number

Start report results from record

Initially zero

M

M

Output

The data returned depends on the chosen table and the Standing Data Access Rules The National Gas or Electricity rules.. The Standing Data Access Rules apply to the following tables (data in other tables is available to all participants).

Table 74 C1 report tables

Table

Security

CATS_INBOUND_CHANGE_REQUEST

You can see records from this table if you meet 1 or more of the following conditions:

  1. You initiated the change request.
  2. You are a nominated Role on the change request.
  3. You had a relationship with the NMI for the trading dates nominated on the change request when the record was created. For example, if your relationship started midway through the life cycle, you can see this record

CATS_INBOUND_METER_REGISTER

You can see records from this table if you meet 1 or more of the following conditions:

  1. You initiated the change request this record is related to

  2. You are a nominated role on the change request this record is related to

  3. You had a relationship with the NMI for the trading dates nominated on the change request which was active between the create date (MaintCreateDt ) of the first record and the create date (MaintCreateDt) of the most recent record on the CATS_INBOUND_CHANGE_REQUEST table and the Standing Data Access Rules permit.

On this table, the MAINTCREATEDT is the date the first record was created for this change request

CATS_INBOUND_NMI_DATA

Same as CATS_INBOUND_METER_REGISTER

CATS_INBOUND_OBJECTIONS

You can see records from this table if you are the initiator of the objection.

Other parties associated with a change request seeking information about objections from a C1 report can obtain it from CATS_OUTBOUND_NOTIFICATIONS

CATS_INBOUND_ROLES

Mostly the same as CATS_INBOUND_ METER_REGISTER except when the Standing Data Access Rules are applied, if you don’t have access to data about a role, the whole record is excluded

CATS_INBOUND_STREAMS

Same as CATS_INBOUND_METER_REGISTER

CATS_METER_REGISTER

You can see records from this table if:

  1. You have a relationship with the NMI overlapping the Start and End Dates
  2. You were acting in a nominated role

CATS_NMI_DATA

Same as CATS_METER_REGISTER

CATS_NMI_DATA_STREAM

Same as CATS_METER_REGISTER

CATS_NMI_PARTICIPANT_RELATIONS

Mostly the same as CATS_INBOUND_ METER_REGISTER except when the Standing Data Access Rules are applied, if you don’t have access to data about a role, the whole record is excluded

CATS_OUTBOUND_CHANGE_REQUESTS

You can see records from this table if you are the initiator of the change request

For details, see Finding why MSATS rejected your transaction in the Technical Guide to MSATS

CATS_OUTBOUND_CHANGE_REQUESTS

You can see records in this table if you are the recipient of the data request

CATS_OUTBOUND_ERRORS

You can see records from this table if you are the initiator of the change request or objection

For details, see Finding why MSATS rejected your transaction in the Technical Guide to MSATS

CATS_OUTBOUND_NOTIFICATIONS

You can see records in this table if you are the recipient of the notification

CATS_OUTBOUND_OBJECTIONS

You can see records from this table if you are the initiator of the objection

CATS_REGISTER_IDENTIFIER

Same as CATS_METER_REGISTER

CATS_NMI_DATA (CND)

AEMO uses CND_[nn] framework to map field names in the CATS_NMI_DATA table to the C1 CATS Transaction Field Validations report. Where possible, participants should use the procedural field names defined in Standing Data for MSATS. AEMO does not support participants using the Oracle database table and field names.

C1 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-660175271</MessageID>
<MessageDate>2023-08-14T11:21:50+10:00</MessageDate>
<TransactionGroup>CATS</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
-<Transactions>
-<Transaction initiatingTransactionID="31581726" transactionDate="2023-08-14T11:21:50+10:00" transactionID="CATS-660175271">
-<ReplicationNotification version="r10">
-<ReplicationParameters>
<TableName>CATS_NMI_DATA</TableName>
<CreationFromDate>2023-06-01T00:00:00+10:00</CreationFromDate>
<CreationToDate>2023-06-30T23:59:59+10:00</CreationToDate>
<LastSequenceNumber>0</LastSequenceNumber>
<MaximumRows>200</MaximumRows>
</ReplicationParameters>
-<ReplicationBlock tableName="ElectricityNMIMaster">
-<Row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ase:ElectricityNMIMasterRow">
<SequenceNumber>72266920</SequenceNumber>
<CreationDate>2023-06-11T00:00:00+10:00</CreationDate>
<MaintenanceDate>2023-06-11T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2023-06-12T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2002155761</NMI>
<JurisdictionCode>SA</JurisdictionCode>
<NMIClassificationCode>SMALL</NMIClassificationCode>
<TransmissionNodeIdentifier>SJP1</TransmissionNodeIdentifier>
<DistributionLossFactorCode>NLV2</DistributionLossFactorCode>
-<Address>
-<StructuredAddress>
-<Lot>
<LotNumber>4</LotNumber>
<DPNumber>A DP NUMBER</DPNumber>
</Lot>
</StructuredAddress>
<GNAFPID>GASA_423860770</GNAFPID>
</Address>
<Aggregate>Yes</Aggregate>
<Status>A</Status>
<HouseNumber>8</HouseNumber>
<LotNumber>4</LotNumber>
<StreetName>CAIRNS</StreetName>
<StreetType>CRES</StreetType>
<AddressLine1>LOT 4</AddressLine1>
<AddressLine2>CAIRNS CRES</AddressLine2>
<SuburbOrPlaceOrLocality>RIVERTON</SuburbOrPlaceOrLocality>
<StateOrTerritory>SA</StateOrTerritory>
<PostCode>5412</PostCode>
<DeliveryPointIdentifier>97793365</DeliveryPointIdentifier>
<GNAFPID>GASA_423860770</GNAFPID>
<CustomerClassificationCode>RESIDENTIAL</CustomerClassificationCode>
<CustomerThresholdCode>LOW</CustomerThresholdCode>
<MeterMalfunctionExemptionNumber>223434</MeterMalfunctionExemptionNumber>
<MeterMalfunctionExemptionExpiryDate>0023-07-11</MeterMalfunctionExemptionExpiryDate>
</Row>
</ReplicationBlock>
-<Event severity="Information">
<Code>0</Code>
<Explanation>Success</Explanation>
</Event>
</ReplicationNotification>
</Transaction>
</Transactions>
</ase:aseXML>