Table: PREDISPATCHINTERCONNECTORRES

PREDISPATCHINTERCONNECTORRES

Name

PREDISPATCHINTERCONNECTORRES

Comment

PREDISPATCHINTERCONNECTORRES records Interconnector flows and losses for the periods calculated in each predispatch run. Only binding and interconnector constraints are reported.
Some fields are for the Frequency Controlled Ancillary Services export and import limits and extra reporting of the generic constraint setting the energy import and export limits.


Description

Source

PREDISPATCHINTERCONNECTORRES updates with every thirty-minute predispatch run.

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 INTERCONNECTOR.


Primary Key Columns

Name

DATETIME

INTERCONNECTORID


Index Columns

Name

PREDISPATCHSEQNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

PREDISPATCHSEQNO

VARCHAR2(20)

 

Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30

RUNNO

NUMBER(3,0)

 

SPD Predispatch run no, typically 1. It increments if the case is re-run.

INTERCONNECTORID

VARCHAR2(10)

X

Interconnector identifier

PERIODID

VARCHAR2(20)

 

PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period.

INTERVENTION

NUMBER(2,0)

 

Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0

METEREDMWFLOW

NUMBER(15,5)

 

Metered MW Flow from EMS. For periods subsequent to the first period of a Pre-Dispatch run, this value represents the cleared target for the previous period of that Pre-Dispatch run.

MWFLOW

NUMBER(15,5)

 

Calculated MW Flow

MWLOSSES

NUMBER(15,5)

 

Calculated MW Losses

MARGINALVALUE

NUMBER(15,5)

 

$ Marginal value of interconnector constraint from SPD

VIOLATIONDEGREE

NUMBER(15,5)

 

Degree of violation of interconnector constraint in MW

LASTCHANGED

DATE

 

Last changed.

DATETIME

DATE

X

Period date and time

EXPORTLIMIT

NUMBER(15,5)

 

Calculated export limit.

IMPORTLIMIT

NUMBER(15,5)

 

Calculated import limit.

MARGINALLOSS

NUMBER(15,5)

 

Marginal loss factor. Use this to adjust bids between reports.

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