Table: METERDATA_INTERCONNECTOR

METERDATA_INTERCONNECTOR

Name

METERDATA_INTERCONNECTOR

Comment

Publishes metering data associated with wholesale interconnectors for a given CASE_ID


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CASE_ID

INTERCONNECTORID

PERIODID

SETTLEMENTDATE


Index Columns

Name

CASE_ID

SETTLEMENTDATE

INTERCONNECTORID

PERIODID


Content

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

The settlement interval identifier

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