RM29 Standing Data Quality Report
Report details
|
Purpose |
Provides Standing Data Quality (SDQ) reports for a specific participant role |
|---|---|
|
Content |
A report containing all Standing Data Quality (SDQ) queries including ADWNAN_INTERVAL, ADWNAN_BASIC, and SUBSTITUTIONTYPES |
|
Request |
Scheduled |
|
Delivery |
Participant Outbox every week. Reports for specific participant roles are run at 6:00 am on the following days:
|
|
Context Type |
StandingDataQualityReport |
|
Priority |
Medium |
|
Role |
LNSP, ENM, MPB, MDP, FRMP and RP |
|
Format |
aseXML compliant XML message with a CSVData query payload |
|
Row limit |
20,000 |
|
Schema version |
n/a |
|
User rights access |
n/a |
SUBSTITUTIONTYPES query
|
Query ID |
SUBSTITUTIONTYPES |
|
Purpose |
SUBSTITUTIONTYPES query results sent to MDPs identifying when obsolete Substitution Type 16 data is sent. This Substitution Type is obsolete from 4 November 2024 |
|
Content |
A list of NMIs where readings have been submitted for an interval meter with Substitution Type 16 |
|
Recipient |
MDP |
|
Delivery |
Participant outbox every Wednesday at 6 am |
|
Data source |
MDM |
|
Format |
CSVReportFormat |
Output
|
H row |
D row example |
MSATS Standing Data element name |
Description |
|---|---|---|---|
|
QueryId |
SUBSTITUTIONTYPES |
n/a |
Query identifier |
|
Stat_Date |
2024-07-08 |
n/a |
Query run date in the format YYYY/MM/DD |
|
ParticipantId |
MDPID |
Party |
The party in CATS_NMI_PARTICIPANT_RELATIONS ID whose relationship (Role) with the NMI is MDP |
|
RoleId |
MDP |
Role |
The Participant relationship (Role) with the NMI in CATS_NMI_PARTICIPANT_RELATIONS |
|
Source |
EMDM |
n/a |
[Fixed value] |
|
Table |
n/a |
n/a |
[Not Applicable] |
|
NMI_ID |
9999999999 |
NMI |
NMI. This number is unique for each connection point within the NEM. |
|
SFX |
E1 |
Suffix |
The Suffix field in the CATS_DATA_STREAM table is used to identify a physical data source that is obtained from the meter. |
|
SDR_Key3 |
n/a |
n/a |
n/a |
|
SDR_Key4 |
n/a |
n/a |
n/a |
|
SDR_Key5 |
n/a |
n/a |
n/a |
|
Field |
n/a |
n/a |
n/a |
|
SettDate |
2024-07-08 |
n/a |
Settlement Date YYYY/MM/DD |
|
DistinctQualityMethod |
F16 |
|
Distinct Quality Methods submitted during the settlement period using a Substitution Type that is not supported under the Procedures. This applies for any read value including zero |
|
Value3 |
n/a |
n/a |
n/a |
|
Value4 |
n/a |
n/a |
n/a |
|
Value5 |
n/a |
n/a |
n/a |
Example
<?xml version="1.0" encoding="UTF-8"?><ase:aseXML xmlns:ase="urn:aseXML:r43" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:aseXML:r43 http://www.nemmco.com.au/aseXML/schemas/r43/aseXML_r43.xsd"><!--This file is the result of transformation from r44 to r43-->
<Header>
<From description="Australian Energy Market Operator Limited">NEMMCO</From>
<To description="Australian Energy Market Operator Limited ">NEMMCO</To>
<MessageID>NEMMCO-MSG-1281618243</MessageID>
<MessageDate>2024-07-09T12:57:26+10:00</MessageDate>
<TransactionGroup>CATS</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>NEMMCOBATCH</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="CATS-3021175243" transactionDate="2024-07-09T12:57:26+10:00" initiatingTransactionID="238542876">
<ReportResponse version="r39">
<ReportParameters xsi:type="ase:CATSStandingDataQualityReportParameters">
<ReportName>StandingDataQualitySummary</ReportName>
<RunDate>2024-07-09T12:57:26+10:00</RunDate>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>
QueryId,Count,QueryCount
15ERRS,0,0
DSERR,0,0
NONSRD,0,13
NSRD,623126,7344759
NWADS,3,820
SUBSTITUTIONTYPES,10,23
TWADS,2,627</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
<Transaction transactionID="CATS-3021175244" transactionDate="2024-07-09T12:57:26+10:00" initiatingTransactionID="238542876">
<ReportResponse version="r39">
<ReportParameters xsi:type="ase:CATSStandingDataQualityReportParameters">
<ReportName>StandingDataQualityReport</ReportName>
<RunDate>2024-07-09T12:57:26+10:00</RunDate>
</ReportParameters>
<ReportResults xsi:type="ase:CSVReportFormat">
<CSVData>
H,QueryId, Stat_Date, ParticipantId, RoleId, Source, Table, NMI_ID, SFX, SDR_Key3, SDR_Key4, SDR_Key5, Field, SettDate, DistinctQualityMethod,Value3,Value4,Value5
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305002468,E1,,,,n/a,13/05/2024,S16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,09/02/2024,S16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,06/06/2024,E16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,04/06/2024,A16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,02/06/2024,F16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,30/05/2024,S16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,15/06/2024,S16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,24/06/2024,S16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,19/05/2024,E16,,,
D,SUBSTITUTIONTYPES,2024-07-08,NEMMCO,MDP,EMDM,n/a,6305134803,E1,,,,n/a,03/06/2024,E16,,,
H,QueryId,Stat_Date,ParticipantId,RoleId,Source,Table,NMI_ID,FRMP,Requestid,n/a,n/a,Field,ProposedDate,Readtypecode,Value3,Value4,Value5
D,TWADS,2024-07-08,NEMMCO,MDP,CATS,n/a,6305239757,COVAU,1407737391,,,n/a,23-APR-24,SP,,,
D,TWADS,2024-07-08,NEMMCO,MDP,CATS,n/a,6305483865,VICLUMO,1406514479,,,n/a,18-APR-24,SP,,,
</CSVData>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success.</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>