| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Interconnector identifier |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The unique identifier for the interval within this study |
| INTERVENTION |
numeric(2, 0) |
tinyint |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0) |
| METEREDMWFLOW |
numeric(15, 5) |
numeric(15, 5) |
SCADA MW Flow measured at Run start. For periods subsequent to the first period of a P5MIN run, this value represents the cleared target for the previous period of that P5MIN run. |
| MWFLOW |
numeric(15, 5) |
numeric(15, 5) |
Cleared Interconnector loading level (MW) |
| MWLOSSES |
numeric(15, 5) |
numeric(15, 5) |
Interconnector Losses at cleared flow |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Marginal cost of Interconnector standing data limits (if binding) |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) |
Violation of Interconnector standing data limits |
| MNSP |
numeric(1, 0) |
tinyint |
Flag indicating MNSP registration |
| EXPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit |
| IMPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow. |
| MARGINALLOSS |
numeric(15, 5) |
numeric(15, 5) |
Marginal loss factor at the cleared flow |
| 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 + Frequency Controlled Ancillary Services. |
| FCASIMPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) |
Calculated import limit applying to energy + Frequency Controlled Ancillary Services. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last changed date of this record |
| 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 |