|
Name |
|
|
Comment |
PREDISPATCHINTERCONNECTORRES records Interconnector flows and losses for the periods calculated in each predispatch run. Only binding and interconnector constraints are reported. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DATETIME |
|
INTERCONNECTORID |
|
Name |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|