Table: TRADINGREGIONSUM

TRADINGREGIONSUM

Name

TRADINGREGIONSUM

Comment

TRADINGREGIONSUM sets out the half-hourly average regional demand and frequency control services. TRADINGREGIONSUM includes fields for the Raise Regulation and Lower Regulation Ancillary Services plus improvements to demand calculations.


Description

TRADINGREGIONSUM is public data, and is available to all participants.

Source

TRADINGREGIONSUM is updated every 30 minutes.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

PERIODID

REGIONID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date that this data applies to

RUNNO

NUMBER(3,0)

X

Dispatch run no.

REGIONID

VARCHAR2(10)

X

Region Identifier

PERIODID

NUMBER(3,0)

X

Trading interval identifier within settlement day.

TOTALDEMAND

NUMBER(15,5)

 

Total demand for region

AVAILABLEGENERATION

NUMBER(15,5)

 

The available generation in the Region for the interval

AVAILABLELOAD

NUMBER(15,5)

 

Not used

DEMANDFORECAST

NUMBER(15,5)

 

Forecast demand for region

DISPATCHABLEGENERATION

NUMBER(15,5)

 

Averaged generation dispatched in region

DISPATCHABLELOAD

NUMBER(15,5)

 

Averaged load dispatched in region

NETINTERCHANGE

NUMBER(15,5)

 

Average energy transferred over interconnector

EXCESSGENERATION

NUMBER(15,5)

 

Average excess generation in region

LOWER5MINDISPATCH

NUMBER(15,5)

 

Not used since Dec 2003. Lower 5 min MW dispatch

LOWER5MINIMPORT

NUMBER(15,5)

 

Not used since Dec 2003. Lower 5 min MW imported

LOWER5MINLOCALDISPATCH

NUMBER(15,5)

 

Lower 5 min local dispatch

LOWER5MINLOCALPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Local price of lower 5 min

LOWER5MINLOCALREQ

NUMBER(15,5)

 

Not used since Dec 2003. Lower 5 min local requirement

LOWER5MINPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Regional price of lower 5 min

LOWER5MINREQ

NUMBER(15,5)

 

Not used since Dec 2003. Lower 5 min total requirement

LOWER5MINSUPPLYPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Supply price of lower 5 min

LOWER60SECDISPATCH

NUMBER(15,5)

 

Not used since Dec 2003. Lower 60 sec MW dispatch

LOWER60SECIMPORT

NUMBER(15,5)

 

Not used since Dec 2003. Lower 60 sec MW imported

LOWER60SECLOCALDISPATCH

NUMBER(15,5)

 

Lower 60 sec local dispatch

LOWER60SECLOCALPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Local price of lower 60 sec

LOWER60SECLOCALREQ

NUMBER(15,5)

 

Not used since Dec 2003. Lower 60 sec local requirement

LOWER60SECPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Regional price of lower 60 sec

LOWER60SECREQ

NUMBER(15,5)

 

Not used since Dec 2003. Lower 60 sec total requirement

LOWER60SECSUPPLYPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Supply price of lower 60 sec

LOWER6SECDISPATCH

NUMBER(15,5)

 

Not used since Dec 2003. Lower 6 sec MW dispatch

LOWER6SECIMPORT

NUMBER(15,5)

 

Not used since Dec 2003. Lower 6 sec MW imported

LOWER6SECLOCALDISPATCH

NUMBER(15,5)

 

Lower 6 sec local dispatch

LOWER6SECLOCALPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Local price of lower 6 sec

LOWER6SECLOCALREQ

NUMBER(15,5)

 

Not used since Dec 2003. Lower 6 sec local requirement

LOWER6SECPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Regional price of lower 6 sec

LOWER6SECREQ

NUMBER(15,5)

 

Not used since Dec 2003. Lower 6 sec total requirement

LOWER6SECSUPPLYPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Supply price of lower 6 sec

RAISE5MINDISPATCH

NUMBER(15,5)

 

Not used since Dec 2003. Raise 5 min MW dispatch

RAISE5MINIMPORT

NUMBER(15,5)

 

Not used since Dec 2003. Raise 5 min MW imported

RAISE5MINLOCALDISPATCH

NUMBER(15,5)

 

Raise 5 min local dispatch

RAISE5MINLOCALPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Local price of raise 5 min

RAISE5MINLOCALREQ

NUMBER(15,5)

 

Not used since Dec 2003. Raise 5 min local requirement

RAISE5MINPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Regional price of raise 5 min

RAISE5MINREQ

NUMBER(15,5)

 

Not used since Dec 2003. Raise 5 min total requirement

RAISE5MINSUPPLYPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Supply price of raise 5 min

RAISE60SECDISPATCH

NUMBER(15,5)

 

Not used since Dec 2003. Raise 60 sec MW dispatch

RAISE60SECIMPORT

NUMBER(15,5)

 

Not used since Dec 2003. Raise 60 sec MW imported

RAISE60SECLOCALDISPATCH

NUMBER(15,5)

 

Raise 60 sec local dispatch

RAISE60SECLOCALPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Local price of raise 60 sec

RAISE60SECLOCALREQ

NUMBER(15,5)

 

Not used since Dec 2003. Raise 60 sec local requirement

RAISE60SECPRICE

NUMBER(15,5)

 

Not used since Dec 2003. Regional price of raise 60 sec


2