DISPATCH_LOCAL_PRICE
Sets out local pricing offsets associated with each DUID connection point for each dispatch period. Note that from 2014 Mid year release only records with non-zero Local_Price_Adjustment values are issued.
Note
Although the "Visibility" of this table is officially "Private, Public Next-Day", most of the data is in fact available publicly in real-time.
Package
DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column | Official MMS Datatype | GR-MMS Datatype | Comment |
|---|---|---|---|
| SETTLEMENTDATE | datetime(3)  |
datetime2(0) |
Market date time starting at 04:05 |
| DUID | varchar(20) |
varchar(10) |
Dispatchable unit identifier |
| LOCAL_PRICE_ADJUSTMENT | numeric(10, 2) | numeric(10, 2) | Aggregate Constraint contribution cost of this unit: Sum(MarginalValue x Factor) for all relevant Constraints |
| LOCALLY_CONSTRAINED | numeric(1, 0) | tinyint | Key for Local_Price_Adjustment: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints |
Official MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| DISPATCH_LOCAL_PRICE_PK | clustered, unique, primary key | SETTLEMENTDATE, DUID |
GR-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PK_DISPATCH_LOCAL_PRICE | clustered, unique, primary key | SETTLEMENTDATE, DUID |
Historical-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| DISPATCH_LOCAL_PRICE_CCI | clustered, columnstore | n/a |
| PK_DISPATCH_LOCAL_PRICE | nonclustered, unique, primary key | SETTLEMENTDATE, DUID |