PREDISPATCHINTERCONNECTORRES
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.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20) |
int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector identifier |
| INTERVENTION |
numeric(2, 0) |
bit |
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 |
| DATETIME |
datetime(3) |
datetime2(0) |
Period date and time |
| METEREDMWFLOW |
numeric(15, 5) |
numeric(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 |
numeric(15, 5) |
numeric(15, 5) |
Calculated MW Flow |
| MWLOSSES |
numeric(15, 5) |
numeric(15, 5) |
Calculated MW Losses |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
$ Marginal value of interconnector constraint from SPD |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) |
Degree of violation of interconnector constraint in MW |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed. |
| EXPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated export limit. |
| IMPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated import limit. |
| MARGINALLOSS |
numeric(15, 5) |
numeric(15, 5) |
Marginal loss factor. Use this to adjust bids between reports. |
| EXPORTGENCONID |
varchar(20) |
varchar(20) |
Generic Constraint setting the export limit |
| IMPORTGENCONID |
varchar(20) |
varchar(20) |
Generic Constraint setting the import limit |
| FCASEXPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated export limit applying to energy + FCAS. |
| FCASIMPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated import limit applying to energy + FCAS. |
| LOCAL_PRICE_ADJUSTMENT_EXPORT |
numeric(10, 2) |
numeric(10, 2) |
Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0) |
| LOCALLY_CONSTRAINED_EXPORT |
numeric(1, 0) |
tinyint |
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 |
numeric(10, 2) |
numeric(10, 2) |
Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0) |
| LOCALLY_CONSTRAINED_IMPORT |
numeric(1, 0) |
tinyint |
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 |
| RUNNO |
numeric(3, 0) |
- |
- |
| PERIODID |
varchar(20) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHINTCONRES |
clustered, unique, primary key |
DATETIME, INTERCONNECTORID |
| PREDISPATCHINTCONRES_NDX3 |
nonclustered |
PREDISPATCHSEQNO |
| PREDISPATCHINTERCONNECTOR_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHINTERCONNECTORRES |
clustered, unique, primary key |
PREDISPATCHSEQNO, INTERVENTION, INTERCONNECTORID, DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHINTERCONNECTORRES |
nonclustered, unique, primary key |
INTERCONNECTORID, PREDISPATCHSEQNO, INTERVENTION, DATETIME |
| PREDISPATCHINTERCONNECTORRES_CCI |
clustered, columnstore |
n/a |