TRADINGLOAD (Historical table)
TRADINGLOAD shows half-hourly average dispatch levels, including fields to handle the Ancillary Services functionality.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date that this data applies to |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable Unit Identifier |
| PERIODID |
numeric(3, 0) |
smallint (not nullable) |
Period Identifier |
| INITIALMW |
numeric(15, 5) |
numeric(15, 5) |
Average Initial MW at start of each period |
| TOTALCLEARED |
numeric(15, 5) |
numeric(15, 5) |
Average total MW dispatched over period |
| RAMPDOWNRATE |
numeric(15, 5) |
numeric(15, 5) |
Average ramp down rate |
| RAMPUPRATE |
numeric(15, 5) |
numeric(15, 5) |
Average ramp up rate |
| LOWER5MIN |
numeric(15, 5) |
numeric(15, 5) |
Average 5 min lower dispatch |
| LOWER60SEC |
numeric(15, 5) |
numeric(15, 5) |
Average 60 sec lower dispatch |
| LOWER6SEC |
numeric(15, 5) |
numeric(15, 5) |
Average60 sec lower dispatch |
| RAISE5MIN |
numeric(15, 5) |
numeric(15, 5) |
Average 5 min raise dispatch |
| RAISE60SEC |
numeric(15, 5) |
numeric(15, 5) |
Average 60 sec raise dispatch |
| RAISE6SEC |
numeric(15, 5) |
numeric(15, 5) |
Average 6 sec raise dispatch |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| LOWERREG |
numeric(15, 5) |
numeric(15, 5) |
Lower Regulation reserve target |
| RAISEREG |
numeric(15, 5) |
numeric(15, 5) |
Raise Regulation reserve target |
| AVAILABILITY |
numeric(15, 5) |
numeric(15, 5) |
Bid energy availability |
| SEMIDISPATCHCAP |
numeric(3, 0) |
bit |
Boolean representation flagging if the Target is Capped |
| RUNNO |
numeric(3, 0) |
- |
- |
| TRADETYPE |
numeric(2, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGLOAD |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, DUID, TRADETYPE, PERIODID |
| TRADINGLOAD_LCX |
nonclustered |
LASTCHANGED |
| TRADINGLOAD_NDX2 |
nonclustered |
DUID, LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGLOAD |
clustered, unique, primary key |
SETTLEMENTDATE, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADINGLOAD |
nonclustered, unique, primary key |
DUID, SETTLEMENTDATE |
| TRADINGLOAD_CCI |
clustered, columnstore |
n/a |