Table: STPASA_INTERCONNECTORSOLN

STPASA_INTERCONNECTORSOLN

Name

STPASA_INTERCONNECTORSOLN

Comment

STPASA_INTERCONNECTORSOLN shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the interval.


Description

STPASA_INTERCONNECTORSOLN is public so is available to all participants.

Source

STPASA_INTERCONNECTORSOLN is updated each STPASA run (i.e. every 2 hours).

Volume

Rows per day: 576

Mb per month: 4


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

INTERCONNECTORID

INTERVAL_DATETIME

RUN_DATETIME

RUNTYPE

STUDYREGIONID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

INTERCONNECTORID

VARCHAR2(10)

X

Interconnector Identifier

CAPACITYMWFLOW

NUMBER(12,2)

 

Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints

CAPACITYMARGINALVALUE

NUMBER(12,2)

 

Capacity adequacy assessment marginal value, 0 if not binding

CAPACITYVIOLATIONDEGREE

NUMBER(12,2)

 

Capacity adequacy assessment violation degree for interconnector capacity; 0 if not violating

CALCULATEDEXPORTLIMIT

NUMBER(12,2)

 

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

CALCULATEDIMPORTLIMIT

NUMBER(12,2)

 

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.

LASTCHANGED

DATE

 

Last changed date of this record

RUNTYPE

VARCHAR2(20)

X

Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR.

EXPORTLIMITCONSTRAINTID

VARCHAR2(20)

 

ID of the constraint that sets the Interconnector Export Limit

IMPORTLIMITCONSTRAINTID

VARCHAR2(20)

 

ID of the constraint that sets the Interconnector Import Limit

STUDYREGIONID

VARCHAR2(20)

X

Primary Region for LP Solve (or MARKET if none).