Table: METERDATA_AGGREGATE_READS

METERDATA_AGGREGATE_READS

Name

METERDATA_AGGREGATE_READS

Comment

Publishes aggregated metering data associated with a wholesale connection point for a given CASE_ID


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CASE_ID

CONNECTIONPOINTID

FRMP

LR

METER_TYPE

PERIODID

SETTLEMENTDATE


Index Columns

Name

CASE_ID

SETTLEMENTDATE

CONNECTIONPOINTID

METER_TYPE

FRMP

LR

PERIODID


Content

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

The settlement interval identifier

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