|
Name |
|
|
Comment |
Publishes aggregated metering data associated with a wholesale connection point for a given CASE_ID |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASE_ID |
|
CONNECTIONPOINTID |
|
FRMP |
|
LR |
|
METER_TYPE |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
|
CASE_ID |
|
SETTLEMENTDATE |
|
CONNECTIONPOINTID |
|
METER_TYPE |
|
FRMP |
|
LR |
|
PERIODID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASE_ID |
NUMBER(15,0) |
X |
Case Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date within the case |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
Connection Point ID |
|
METER_TYPE |
VARCHAR2(20) |
X |
The meter type for the read, one of: CUSTOMER; GENERATOR; EMBEDDED_GENERATOR |
|
FRMP |
VARCHAR2(20) |
X |
The financially responsible market participantid |
|
LR |
VARCHAR2(20) |
X |
The local retailer at the connection point id |
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval. |
|
IMPORTVALUE |
NUMBER(18,8) |
X |
The import(pool-centric) value for the meter read (MWh) |
|
EXPORTVALUE |
NUMBER(18,8) |
X |
The export(pool-centric) value for the meter read (MWh) |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
Publishes metering data associated with individual metering points for a given CASE_ID |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASE_ID |
|
METER_ID |
|
METER_ID_SUFFIX |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
|
CASE_ID |
|
SETTLEMENTDATE |
|
METER_ID |
|
METER_ID_SUFFIX |
|
PERIODID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASE_ID |
NUMBER(15,0) |
X |
Case Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date within the case |
|
METER_ID |
VARCHAR2(20) |
X |
The National Metering Identifier (NMI) |
|
METER_ID_SUFFIX |
VARCHAR2(20) |
X |
The National Metering Identifier (NMI) data stream |
|
FRMP |
VARCHAR2(20) |
X |
The financially responsible market participantid |
|
LR |
VARCHAR2(20) |
X |
The local retailer at the connection point id |
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval. |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
Connection Point ID |
|
METER_TYPE |
VARCHAR2(20) |
X |
The meter type for the read, one of: CUSTOMER; GENERATOR; EMBEDDED_GENERATOR |
|
IMPORTVALUE |
NUMBER(18,8) |
X |
The import(pool-centric) value for the meter read (MWh) |
|
EXPORTVALUE |
NUMBER(18,8) |
X |
The export(pool-centric) value for the meter read (MWh) |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
Publishes metering data associated with wholesale interconnectors for a given CASE_ID |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CASE_ID |
|
INTERCONNECTORID |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
|
CASE_ID |
|
SETTLEMENTDATE |
|
INTERCONNECTORID |
|
PERIODID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASE_ID |
NUMBER(15,0) |
X |
Case Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date within the case |
|
INTERCONNECTORID |
VARCHAR2(20) |
X |
Interconnector Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval. |
|
IMPORTVALUE |
NUMBER(18,8) |
|
The import direction value for the meter read (MWh) |
|
EXPORTVALUE |
NUMBER(18,8) |
|
The export direction value for the meter read (MWh) |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
The SAPS Meter data for MSRP and Retailer used in the Settlement Calculation |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASE_ID |
|
CONNECTIONPOINT_ID |
|
FRMP |
|
LR |
|
METER_TYPE |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASE_ID |
NUMBER(15,0) |
X |
The Metering Case ID used for Settlements |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date for that Week |
|
CONNECTIONPOINT_ID |
VARCHAR2(20) |
X |
The SAPS Connection Point Id |
|
METER_TYPE |
VARCHAR2(20) |
X |
The Meter Type Identifier , CUSTOMER or MSRP |
|
FRMP |
VARCHAR2(20) |
X |
The Financial Responsible Market Participant |
|
LR |
VARCHAR2(20) |
X |
The Local Retailer |
|
PERIODID |
NUMBER(4,0) |
X |
The Period ID Identifier |
|
IMPORTVALUE |
NUMBER(18,8) |
|
The Sent Out Energy in MWh |
|
EXPORTVALUE |
NUMBER(18,8) |
|
The Consumed Energy in MWh |
|
LASTCHANGED |
DATE |
|
The Date time of the record last updated or inserted. |
|
Name |
|
|
Comment |
Metering Data WDR Readings |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASE_ID |
|
MARKET_ID |
|
METER_ID |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKET_ID |
VARCHAR2(20) |
X |
Unique identifier for the market to which this metering record applies. Always equal to NEM in the current system. |
|
CASE_ID |
NUMBER(15,0) |
X |
Unique identifier for the metering case. |
|
SETTLEMENTDATE |
DATE |
X |
The settlement date for the metering record |
|
METER_ID |
VARCHAR2(20) |
X |
Unique identifier for the meter to which the metering record applies |
|
TNI |
VARCHAR2(20) |
|
Unique identifier for the transmission node to which this meter belongs on the settlement date |
|
FRMP |
VARCHAR2(20) |
|
Unique identifier for the participant acting as the FRMP for this NMI on the settlement date |
|
DRSP |
VARCHAR2(20) |
|
Unique identifier for the participant acting as the DRSP for this NMI on the settlement date |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval identifier, with Period 1 being the first TI for the calendar day, i.e interval ending 00:05. |
|
METEREDQUANTITYIMPORT |
NUMBER(18,8) |
|
Metered quantity Import in MWh for the NMI in the trading interval. A negative value indicates net consumption, while a positive value indicates net generation |
|
METEREDQUANTITYEXPORT |
NUMBER(18,8) |
|
Metered quantity Export in MWh for the NMI in the trading interval. A negative value indicates net consumption, while a positive value indicates net generation |
|
BASELINEQUANTITY |
NUMBER(18,8) |
|
Baseline quantity in MWh for the NMI in the trading interval. A negative value indicates net consumption, while a positive value indicates the net generation |
|
QUALITYFLAG |
VARCHAR2(20) |
|
Quality flag for the meter read. Where multiple datastreams exist against the NMI with different quality flags for each read, the lowest quality flag will be published against the NMI for the interval. |
|
ISNONCOMPLIANT |
NUMBER(1,0) |
|
A value of TRUE (indicated by 1) for this column indicates that financial settlement of WDR transactions for this NMI should not proceed for the settlement date and trading interval. Possible values are 1 and 0. |
|
BASELINECALCULATIONID |
VARCHAR2(100) |
|
A reference to the baseline run that produced the baseline quantity for this NMI and interval |
|
|
|