Table: INTERCONNMWFLOW

INTERCONNMWFLOW

Name

INTERCONNMWFLOW

Comment

INTERCONNMWFLOW shows Metered Interconnector flow data. INTERCONNMWFLOW shows the meter data provided by Meter Data Providers to MSATS.
Despite the name, this view shows metered energy (MWh) and not power flow (MW).


Description

INTERCONNMWFLOW data is public, available to all participants.

Source

INTERCONNMWFLOW updates weekly.

Volume

The volume depends on number of interconnectors and number of loads (versions) from MSATS per settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

INTERCONNECTORID

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date (based on Trading day, not dispatch day - i.e. period 1 ends 00:30)

VERSIONNO

NUMBER(6,0)

X

Meter Data Version number

INTERCONNECTORID

VARCHAR2(10)

X

Interconnector Identifier

PERIODID

NUMBER(3,0)

X

Settlement Period identifier (half hour period)

IMPORTENERGYVALUE

NUMBER(15,6)

 

Imported Energy value (MWh)

EXPORTENERGYVALUE

NUMBER(15,6)

 

Exported Energy value (MWh)

LASTCHANGED

DATE

 

Record creation timestamp