PREDISPATCHPRICE
PREDISPATCHPRICE records predispatch prices for each region by period for each predispatch run, including fields to handle the Ancillary Services functionality.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20) |
int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| REGIONID |
varchar(10) |
varchar(10) |
Unique region identifier |
| INTERVENTION |
numeric(2, 0) |
bit |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0 |
| DATETIME |
datetime(3) |
datetime2(0) |
Period date and time |
| RRP |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Regional Reference Price |
| EEP |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Excess energy price |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| RAISE6SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISE60SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISE5MINRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| RAISEREGRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER6SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER60SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER5MINRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWERREGRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional reference price for this dispatch period |
| LOWER1SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional Lower 1Sec Price - RegionSolution element L1Price attribute |
| RAISE1SECRRP |
numeric(15, 5) |
numeric(15, 5) |
Regional Raise 1Sec Price - R1Price attribute after capping /flooring |
| RUNNO |
numeric(3, 0) |
- |
- |
| PERIODID |
varchar(20) |
- |
- |
| RRP1 |
numeric(15, 5) |
- |
- |
| EEP1 |
numeric(15, 5) |
- |
- |
| RRP2 |
numeric(15, 5) |
- |
- |
| EEP2 |
numeric(15, 5) |
- |
- |
| RRP3 |
numeric(15, 5) |
- |
- |
| EEP3 |
numeric(15, 5) |
- |
- |
| RRP4 |
numeric(15, 5) |
- |
- |
| EEP4 |
numeric(15, 5) |
- |
- |
| RRP5 |
numeric(15, 5) |
- |
- |
| EEP5 |
numeric(15, 5) |
- |
- |
| RRP6 |
numeric(15, 5) |
- |
- |
| EEP6 |
numeric(15, 5) |
- |
- |
| RRP7 |
numeric(15, 5) |
- |
- |
| EEP7 |
numeric(15, 5) |
- |
- |
| RRP8 |
numeric(15, 5) |
- |
- |
| EEP8 |
numeric(15, 5) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHPRICE |
clustered, unique, primary key |
DATETIME, REGIONID |
| PREDISPATCHPRICE_LCX |
nonclustered |
LASTCHANGED |
| PREDISPATCHPRICE_NDX3 |
nonclustered |
PREDISPATCHSEQNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHPRICE |
clustered, unique, primary key |
PREDISPATCHSEQNO, INTERVENTION, REGIONID, DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHPRICE |
nonclustered, unique, primary key |
REGIONID, PREDISPATCHSEQNO, INTERVENTION, DATETIME |
| PREDISPATCHPRICE_CCI |
clustered, columnstore |
n/a |