Table: TRADINGINTERCONNECT

TRADINGINTERCONNECT

Name

TRADINGINTERCONNECT

Comment

TRADINGINTERCONNECT shows the half-hourly summary of Interconnector flows based on 5-minute averages.


Description

TRADINGINTERCONNECT is public data, and is available to all participants.

Source

TRADINGINTERCONNECT is updated half hourly.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

INTERCONNECTORID

PERIODID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date that this data applies to

RUNNO

NUMBER(3,0)

X

Dispatch run no.

INTERCONNECTORID

VARCHAR2(10)

X

Interconnector identifier

PERIODID

NUMBER(3,0)

X

Period Identifier

METEREDMWFLOW

NUMBER(15,5)

 

Average of the metered MW flow from the start of each dispatch interval.

MWFLOW

NUMBER(15,5)

 

Calculated MW Flow from SPD

MWLOSSES

NUMBER(15,5)

 

MW losses at calculated MW flow

LASTCHANGED

DATE

 

Last date and time record changed