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.

Package

PRE_DISPATCH

Private, Public Next-Day

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
PERIODID	varchar(20)	-	-

Index name	Index type	Index columns (in order)
PREDISPATCH_LOCAL_PRICE_PK	clustered, unique, primary key	DATETIME, DUID

Index name	Index type	Index columns (in order)
PK_PREDISPATCH_LOCAL_PRICE	clustered, unique, primary key	PREDISPATCHSEQNO, DUID, DATETIME

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