Finding the last sequence number

Because MSATS Market Settlement and Transfer Solutions. The procedures published by AEMO under clause 7.2.8 of the National Electricity Rules, which include those governing the recording of financial responsibility for energy flows at a connection point, the transfer of that responsibility between market participants, and the recording of energy flows at a connection point. reports have row limits, this topic provide a C4 report example to help you work out the last sequence number for a multi-NMI See Relevant Rules or Procedures report and how to know when you have selected all records.

  1. Run the C4 NMI Master report using your preferred request method.
  2. For the Last Sequence Number, enter 0. This is the default value.
  3. Enter any other required input parameters.
  4. The data returned is sorted into the following separate data blocks:
  5. <ReplicationBlock tableName=‘ElectricityNMIMaster’>: Contains the data from the CATS_NMI_Data table. MSATS applies the row limit in this block. Once the row limit is reached, for all NMIs selected, MSATS populates the other blocks.
  6. <ReplicationBlock tableName=‘ElectricityNMIRoles’>: Contains the data from the CATS_NMI_Participant_Relations table.
  7. <ReplicationBlock tableName=‘ElectricityNMIDataStreams’>: Contains the data from the CATS_NMI_Data_Stream table.
  8. </ReplicationBlock><ReplicationBlock tableName=‘ElectricityNMIMeters’>: Contains the data from the CATS_Meter_Register table.
  9. </ReplicationBlock><ReplicationBlock tableName=‘ElectricityRegisterIdentifier’>: Contains the data from the CATS_Register_Identifier table
  10. To identify the last sequence number, find the last record returned in the ElectricityNMIMaster ReplicationBlock.
  11. This example shows the last record in the ElectricityNMIMaster ReplicationBlock and the first record in the ElectricityNMIRoles ReplicationBlock. The last sequence number is 57379.
  12. Run the report again with exactly the same parameters using the Last Sequence Number 57379.
  13. When you receive the second report, repeat the above process to find the Last Sequence number and run the report again using that last sequence number.
  14. Continue running the report until the <Code> tag in the electricityReportResults ReplicationBlock(the last replication block) has the code 1004 and no NMI data returns.