Table: TRADINGLOAD

TRADINGLOAD

Name

TRADINGLOAD

Comment

TRADINGLOAD shows half-hourly average dispatch levels, including fields to handle the Ancillary Services functionality.


Description

Source

Own (confidential) TRADINGLOAD data updates half hourly, with public availability of all data on next day.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


Primary Key Columns

Name

DUID

PERIODID

RUNNO

SETTLEMENTDATE

TRADETYPE


Index Columns

Name

LASTCHANGED


Index Columns

Name

DUID

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date that this data applies to

RUNNO

NUMBER(3,0)

X

Dispatch run no.

DUID

VARCHAR2(10)

X

Dispatchable Unit Identifier

TRADETYPE

NUMBER(2,0)

X

Not used

PERIODID

NUMBER(3,0)

X

Period Identifier

INITIALMW

NUMBER(15,5)

 

Average Initial MW at start of each period

TOTALCLEARED

NUMBER(15,5)

 

Average total MW dispatched over period

RAMPDOWNRATE

NUMBER(15,5)

 

Average ramp down rate

RAMPUPRATE

NUMBER(15,5)

 

Average ramp up rate

LOWER5MIN

NUMBER(15,5)

 

Average 5 min lower dispatch

LOWER60SEC

NUMBER(15,5)

 

Average 60 sec lower dispatch

LOWER6SEC

NUMBER(15,5)

 

Average60 sec lower dispatch

RAISE5MIN

NUMBER(15,5)

 

Average 5 min raise dispatch

RAISE60SEC

NUMBER(15,5)

 

Average 60 sec raise dispatch

RAISE6SEC

NUMBER(15,5)

 

Average 6 sec raise dispatch

LASTCHANGED

DATE

 

Last date and time record changed

LOWERREG

NUMBER(15,5)

 

Lower Regulation reserve target

RAISEREG

NUMBER(15,5)

 

Raise Regulation reserve target

AVAILABILITY

NUMBER(15,5)

 

Bid energy availability

SEMIDISPATCHCAP

NUMBER(3,0)

 

Boolean representation flagging if the Target is Capped