|
Name |
|
|
Comment |
Publishes metering data associated with individual metering points for a given CASE_ID |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
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 |
The settlement interval identifier |
|
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 |
|
|
|