Table: MTPASA_INTERCONNECTORRESULT

MTPASA_INTERCONNECTORRESULT

Name

MTPASA_INTERCONNECTORRESULT

Comment

Interconnector results for interval of max demand per day


Description

MTPASA_INTERCONNECTORRESULT is public data.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DAY

DEMAND_POE_TYPE

INTERCONNECTORID

RUN_DATETIME

RUN_NO

RUNTYPE


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Date processing of the run begins.

RUN_NO

NUMBER(4)

X

Unique run id.

RUNTYPE

VARCHAR2(20)

X

Type of run. Always RELIABILITY

DEMAND_POE_TYPE

VARCHAR2(20)

X

Demand POE type used. Value is POE10

DAY

DATE

X

Day this result is for

INTERCONNECTORID

VARCHAR2(20)

X

The unique identifier for the interconnector

PERIODID

NUMBER(3,0)

 

Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years)

FLOW90

NUMBER(12,2)

 

The 90th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW)

FLOW50

NUMBER(12,2)

 

The 50th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW)

FLOW10

NUMBER(12,2)

 

The 10th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW)

PROBABILITYOFBINDINGEXPORT

NUMBER(8,5)

 

Proportion of iterations and reference years with interconnector constrained when exporting

PROBABILITYOFBINDINGIMPORT

NUMBER(8,5)

 

Proportion of iterations and reference years with interconnector constrained when importing

CALCULATEDEXPORTLIMIT

NUMBER(12,2)

 

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit, averaged across iterations and reference years

CALCULATEDIMPORTLIMIT

NUMBER(12,2)

 

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit, averaged across iterations and reference years

LASTCHANGED

DATE

 

Last date and time record changed