PREDISPATCH_LOCAL_PRICE
Sets out local pricing offsets associated with each DUID connection point for each dispatch period.
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, for any units affected by constraints with more than one unit on the LHS.
DUIDs with a Local Price Adjustment solely due to a constraint with only that DUID on the LHS (a "private" constraint) will not appear in this table until the next trading day.
Package
PRE_DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column | Official MMS Datatype | GR-MMS Datatype | Comment |
|---|---|---|---|
| PREDISPATCHSEQNO | varchar(20) (not nullable) | int  |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| DATETIME | datetime(3) |
datetime2(0) |
The unique identifier for the interval within this study |
| DUID | varchar(20) |
varchar(20) |
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 |
| LASTCHANGED | datetime(3) | datetime2(0) | Last date and time record changed |
Removed columns
| Column | Official MMS Datatype | Comment |
|---|---|---|
| PERIODID | varchar(20) | A period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period |
Official MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PREDISPATCH_LOCAL_PRICE_PK | clustered, unique, primary key | DATETIME, DUID |
GR-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PK_PREDISPATCH_LOCAL_PRICE | clustered, unique, primary key | PREDISPATCHSEQNO, DUID, DATETIME |
Historical-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PREDISPATCH_LOCAL_PRICE_CCI | clustered, columnstore | n/a |
| PREDISPATCH_LOCAL_PRICE_PK | nonclustered, unique, primary key | PREDISPATCHSEQNO, DATETIME, DUID |