| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| INTERVENTION |
numeric(2, 0) |
tinyint |
Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
The unique identifier for the interval within this study |
| INTERCONNECTORID |
varchar(20) |
varchar(10) |
Interconnector identifier |
| METEREDMWFLOW |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
SCADA MW Flow measured at Run start. For periods subsequent to the first period of a PD7DAY run, this value represents the cleared target for the previous period of that PD7DAY run. |
| MWFLOW |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Cleared Interconnector loading level (MW) |
| MWLOSSES |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Interconnector Losses at cleared flow |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Marginal cost of Interconnector standing data limits (if binding) |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Violation of Interconnector standing data limits |
| EXPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit |
| IMPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
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) (not nullable) |
Marginal loss factor at the cleared flow |
| EXPORTCONSTRAINTID |
varchar(20) |
varchar(20) (not nullable) |
Generic Constraint setting the export limit |
| IMPORTCONSTRAINTID |
varchar(20) |
varchar(20) (not nullable) |
Generic Constraint setting the import limit |
| FCASEXPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Calculated export limit applying to energy + Frequency Controlled Ancillary Services. |
| FCASIMPORTLIMIT |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Calculated import limit applying to energy + Frequency Controlled Ancillary Services. |
| LOCAL_PRICE_ADJUSTMENT_EXPORT |
numeric(10, 2) |
numeric(10, 2) (not nullable) |
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 (not nullable) |
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) (not nullable) |
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 (not nullable) |
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 |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |