Interpreting retrieved results for interval meters
Metering Data is retrieved based on the Datastream suffixes defined in the CNDS table, for example, net (Nx) or register level suffixes (Ex, Bx, Kx, Qx, and so on).
The following scenarios define which Interval Period over which interval energy data is recorded by the metering installation that corresponds to a TI or submultiples of a TI. Metering Data is retrieved based on:
- If the MDM stored Metering Data was received as an MDMT or MTRD Transaction.
- If the Datastream defined in the CNDS table is a net or register level.
MDM stored Metering data received as an MDMT transaction
The Datastream defined in the CNDS table is a net.
|
Standing data |
Stored read |
||||
|---|---|---|---|---|---|
|
CNDS suffix |
CSV format |
NMISuffix |
MDMDataStreamIdentifier |
NMIConfiguration |
MDP version date |
|
N1 |
MDMF |
N1 |
n/a |
n/a |
15-Aug-2020 13:20:57 |
Retrieved results
As a read exists in the MDM Meter Data Management system includes the Profile Preparation Service, Basic Meter Profiling, and Data Aggregation. database with a NMI See Relevant Rules or Procedures Suffix equal to the CNDS Suffix, this read is retrieved.
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
N1 |
14-Aug-2020 |
00:30:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
MDM stored Metering data received as an MTRD transaction
The Transaction See Relevant Rules or Procedures contained a single E1 Metering read. The Datastream defined the CNDS table is a register level with both the E1 defined.
|
Standing data |
Stored read |
||||
|---|---|---|---|---|---|
|
CNDS suffix |
CSV format |
NMISuffix |
MDMDataStreamIdentifier |
NMIConfiguration |
MDP Version Date |
|
E1 |
MDFF |
E1 |
N1 |
E1 |
15-Aug-2020 13:20:57 |
Retrieved results
As an E1 read exists in the MDM database with a NMI Suffix equal to the CNDS Suffix, this read is retrieved.
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
E1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
MDM stored Metering data received as an MTRD transaction
The Transaction contains reads for E1, B1, E2 and a B2. With the exception of the B2 these registers are defined in the NEM12 file’s NMIConfiguration string ‘B1E1E2’. The Datastreams defined in the CNDS table are a net level N1 and N2.
|
Standing data |
Stored read |
||||
|
CNDS suffix |
CSV format |
NMISuffix |
MDMDataStreamIdentifier |
NMIConfiguration |
MDP version date |
|
N1 |
MDFF |
E1 |
N1 |
B1E1E2 |
15-Aug-2020 13:20:57 |
|
N1 |
MDFF |
B1 |
N1 |
B1E1E2 |
15-Aug-2020 13:20:57 |
|
N2 |
MDFF |
E2 |
N2 |
B1E1E2 |
15-Aug-2020 13:20:57 |
|
N2 |
MDFF |
B2 |
N2 |
B1E1E2 |
15-Aug-2020 13:20:57 |
Retrieved results
As a read exists in the MDM database with a MDMDataStreamIdentifier equal to the CNDS Suffix, the reads listed in NMIConfiguration are retrieved. As the NMIConfiguration of N2 contains only E2, the B2 read is not retrieved.
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
B1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
E1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
E2 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
MDM stored Metering data received as an MTRD transaction
The Datastream defined in the CNDS table is a net with Reactive Energy The unit must be a generator for the service type: ‘energy’. Loads cannot bid for mandatory restrictions capacity. (Kx and Qx) also defined.
|
Standing data |
Stored read |
||||
|
CNDS suffix |
CSV format |
NMISuffix |
MDMDataStreamIdentifier |
NMIConfiguration |
MDP version date |
|
E1 |
MDFF |
E1 |
N1 |
E1K1Q1 |
15-Aug-2020 13:20:57 |
|
K1 |
MDFF |
K1 |
N1 |
E1K1Q1 |
15-Aug-2020 13:20:57 |
|
Q1 |
MDFF |
Q1 |
N1 |
E1K1Q1 |
15-Aug-2020 13:20:57 |
Retrieved results
As an Active Energy read exists in the MDM database with a NMI Suffix equal to the CNDS Suffix and a Reactive Energy read exists in the MDM database with a NMI Suffix equal to the CNDS Suffix, these reads are retrieved.
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
E1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
K1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
Q2 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
MDM stored Metering data received as an MTRD transaction
The Datastream defined the CNDS table is a net with Reactive Energy (Kx and Qx) also defined.
|
Standing data |
Stored read |
||||
|
CNDS suffix |
CSV format |
NMISuffix |
MDMDataStreamIdentifier |
NMIConfiguration |
MDP version date |
|
N1 |
MDFF |
E1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N1 |
MDFF |
B1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N1 |
MDFF |
K1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N1 |
MDFF |
Q1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N2 |
MDFF |
E2 |
N2 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N2 |
MDFF |
B2 |
N2 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
Retrieved results
As a read exists in the MDM database with an MDMDataStreamIdentifier equal to the CNDS Suffix, the reads listed in the NMIConfiguration are retrieved. As Reactive Energy reads exists in the MDM database with a NMI Suffix equal to the CNDS Suffix, these reads are retrieved.
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
B1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
B2 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
E1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
E2 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
K1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
Q2 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
MDM stored Metering data received as an MTRD transaction
The Datastream defined the CNDS table was a net but is now defined at a register level for the E1, B1, K1 and Q1 Datastreams only. The N2 Datastream is set to inactive with no defined replacement register level (E2, B2) CNDS.
|
Standing data |
Stored read |
||||
|
CNDS suffix |
CSV format |
NMISuffix |
MDMDataStreamIdentifier |
NMIConfiguration |
MDP version date |
|
N1 (inactive) E1 (active) |
MDFF |
E1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N1 (inactive) B1 (active) |
MDFF |
B1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N2 (inactive) |
MDFF |
E2 |
N2 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N2 (inactive) |
MDFF |
B2 |
N2 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N1 (inactive) K1 (active) |
MDFF |
K1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
|
N1 (inactive) Q1 (active) |
MDFF |
Q1 |
N1 |
E1B1K1Q1E2B2 |
15-Aug-2020 13:20:57 |
Retrieve all reads Active within the date range
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
B1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
E1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
K1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
N2 |
14-Aug-2020 |
00:05:00 |
111.11 |
I |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
Q1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
Retrieve all reads Active at some stage
|
Suffix |
Settlement date |
Interval time |
Interval value (kWh for active energy) |
Status |
MDP version date |
Load date |
A/H |
|---|---|---|---|---|---|---|---|
|
B1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
E1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
K1 |
14-Aug-2020 |
00:05:00 |
-222.22 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |
|
Q1 |
14-Aug-2020 |
00:05:00 |
111.11 |
A |
15-Aug-2020 13:20:57 |
16-Aug-2020 03:08:34 |
Active |