P5MIN_LOCAL_PRICE
Sets out local pricing offsets associated with each DUID connection point for each dispatch period.
Package
P5MIN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this study |
| INTERVAL_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 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_LOCAL_PRICE_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_LOCAL_PRICE |
clustered, unique, primary key |
RUN_DATETIME, DUID, INTERVAL_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_LOCAL_PRICE_CCI |
clustered, columnstore |
n/a |
| PK_P5MIN_LOCAL_PRICE |
nonclustered, unique, primary key |
DUID, RUN_DATETIME, INTERVAL_DATETIME |