Table: PD7DAY_INTERCONNECTORSOLUTION

PD7DAY_INTERCONNECTORSOLUTION

Name

PD7DAY_INTERCONNECTORSOLUTION

Comment

PD7DAY intereconnector solution


Primary Key Columns

Name

INTERCONNECTORID

INTERVAL_DATETIME

INTERVENTION

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVENTION

NUMBER(2,0)

X

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

DATE

X

The unique identifier for the interval within this study

INTERCONNECTORID

VARCHAR2(20)

X

Interconnector identifier

METEREDMWFLOW

NUMBER(15,5)

 

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

NUMBER(15,5)

 

Cleared Interconnector loading level (MW)

MWLOSSES

NUMBER(15,5)

 

Interconnector Losses at cleared flow

MARGINALVALUE

NUMBER(15,5)

 

Marginal cost of Interconnector standing data limits (if binding)

VIOLATIONDEGREE

NUMBER(15,5)

 

Violation of Interconnector standing data limits

EXPORTLIMIT

NUMBER(15,5)

 

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit

IMPORTLIMIT

NUMBER(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

NUMBER(15,5)

 

Marginal loss factor at the cleared flow

EXPORTCONSTRAINTID

VARCHAR2(20)

 

Generic Constraint setting the export limit

IMPORTCONSTRAINTID

VARCHAR2(20)

 

Generic Constraint setting the import limit

FCASEXPORTLIMIT

NUMBER(15,5)

 

Calculated export limit applying to energy + Frequency Controlled Ancillary Services.

FCASIMPORTLIMIT

NUMBER(15,5)

 

Calculated import limit applying to energy + Frequency Controlled Ancillary Services.

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

LASTCHANGED

DATE

 

Last date and time record changed