Table: METERDATA_INDIVIDUAL_READS

METERDATA_INDIVIDUAL_READS

Name

METERDATA_INDIVIDUAL_READS

Comment

Publishes metering data associated with individual metering points for a given CASE_ID


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CASE_ID

METER_ID

METER_ID_SUFFIX

PERIODID

SETTLEMENTDATE


Index Columns

Name

CASE_ID

SETTLEMENTDATE

METER_ID

METER_ID_SUFFIX

PERIODID


Content

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