Table: DISPATCHINTERCONNECTORRES

DISPATCHINTERCONNECTORRES

Name

DISPATCHINTERCONNECTORRES

Comment

DISPATCHINTERCONNECTORRES sets out MW flow and losses on each interconnector for each dispatch period, including fields for the Frequency Controlled Ancillary Services export and import limits and extra reporting of the generic constraints set the energy import and export limits.


Description

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

Source

DISPATCHINTERCONNECTORRES updates every 5 minutes.

Note

MW losses can be negative depending on the flow.

The definition of direction of flow for an interconnector is that positive flow starts from the FROMREGION in the INTERCONNECTOR table.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DISPATCHINTERVAL

INTERCONNECTORID

INTERVENTION

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market date starting at 04:05

RUNNO

NUMBER(3,0)

X

Dispatch run no; always 1

INTERCONNECTORID

VARCHAR2(10)

X

Interconnector identifier

DISPATCHINTERVAL

NUMBER(22,0)

X

Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP.

INTERVENTION

NUMBER(2,0)

X

Intervention case or not

METEREDMWFLOW

NUMBER(15,5)

 

Metered MW Flow from SCADA.

MWFLOW

NUMBER(15,5)

 

Target MW Flow for next 5 mins.

MWLOSSES

NUMBER(15,5)

 

Calculated MW Losses

MARGINALVALUE

NUMBER(15,5)

 

Shadow price resulting from thermal or reserve sharing constraints on Interconnector import/export (0 unless binding) - NEMDE Solution InterconnectorSolution element "Price" attribute

VIOLATIONDEGREE

NUMBER(15,5)

 

Degree of violation on interconnector constraints

LASTCHANGED

DATE

 

Last changed.

EXPORTLIMIT

NUMBER(15,5)

 

Calculated export limit applying to energy only.

IMPORTLIMIT

NUMBER(15,5)

 

Calculated import limit applying to energy only.

MARGINALLOSS

NUMBER(15,5)

 

Marginal loss factor. Use this to adjust prices between regions.

EXPORTGENCONID

VARCHAR2(20)

 

Generic Constraint setting the export limit

IMPORTGENCONID

VARCHAR2(20)

 

Generic Constraint setting the import limit

FCASEXPORTLIMIT

NUMBER(15,5)

 

Calculated export limit applying to energy + FCAS.

FCASIMPORTLIMIT

NUMBER(15,5)

 

Calculated import limit applying to energy + FCAS.

LOCAL_PRICE_ADJUSTMENT_EXPORT

NUMBER(10,2)

 

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)

LOCALLY_CONSTRAINED_EXPORT

NUMBER(1,0)

 

Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

LOCAL_PRICE_ADJUSTMENT_IMPORT

NUMBER(10,2)

 

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)

LOCALLY_CONSTRAINED_IMPORT

NUMBER(1,0)

 

Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints