Table: DISPATCH_INTERCONNECTION

DISPATCH_INTERCONNECTION

Name

DISPATCH_INTERCONNECTION

Comment

Inter-regional flow information common to or aggregated for regulated (i.e. not MNSP) Interconnectors spanning the From-Region and To-Region - NB only the physical run is calculated'


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

FROM_REGIONID

INTERVENTION

RUNNO

SETTLEMENTDATE

TO_REGIONID


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market date starting at 04:05

RUNNO

NUMBER(3,0)

X

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

X

Intervention case or not

FROM_REGIONID

VARCHAR2(20)

X

Nominated RegionID from which the energy flows

TO_REGIONID

VARCHAR2(20)

X

Nominated RegionID to which the energy flows

DISPATCHINTERVAL

NUMBER(22,0)

 

Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP

IRLF

NUMBER(15,5)

 

Inter-Regional Loss Factor. Calculated based on the MWFLOW and the nominal From and To Region losses.

MWFLOW

NUMBER(16,6)

 

Summed MW flow of the parallel regulated Interconnectors

METEREDMWFLOW

NUMBER(16,6)

 

Summed Metered MW flow of the parallel regulated Interconnectors

FROM_REGION_MW_LOSSES

NUMBER(16,6)

 

Losses across the Interconnection attributable to the nominal From Region

TO_REGION_MW_LOSSES

NUMBER(16,6)

 

Losses across the Interconnection attributable to the nominal To Region

LASTCHANGED

DATE

 

The datetime that the record was last changed