PREDISPATCHBIDTRK (Historical table)

PREDISPATCHBIDTRK contains an audit trail of bids used in each predispatch run. Where predispatch is over 2 days, two bids are listed.

Package

HISTORICAL_TABLES

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
DUID	varchar(10)	varchar(10)	Dispatchable Unit identifier
PERIODID	varchar(20)	varchar(20)	PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period.
BIDTYPE	varchar(10)	varchar(10)	Bid type (daily, default or rebid)
OFFERDATE	datetime(3)	datetime2(0)	Offer date for bid
VERSIONNO	numeric(3, 0)	smallint	Version no of offer for the offer date
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
SETTLEMENTDATE	datetime(3)	datetime2(0)	Market Settlement Date
DATETIME	datetime(3)	datetime2(0)	Period date and time

Official MMS data model indexes

Index name	Index type	Index columns (in order)
PREDISPATCHBIDTRK_LCX	nonclustered	LASTCHANGED
PREDISPATCHBIDTRK_NDX2	nonclustered	DUID, LASTCHANGED
PREDISPATCHBIDTRK_NDX3	nonclustered	DUID, SETTLEMENTDATE
PREDISPATCHBIDTRK_PK	clustered, unique, primary key	PREDISPATCHSEQNO, DUID, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PREDISPATCHBIDTRK_DUID_LASTCHANGED	nonclustered	DUID, LASTCHANGED
IX_PREDISPATCHBIDTRK_DUID_SETTLEMENTDATE	nonclustered	DUID, SETTLEMENTDATE
IX_PREDISPATCHBIDTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_PREDISPATCHBIDTRK	clustered, unique, primary key	PREDISPATCHSEQNO, DUID, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PREDISPATCHBIDTRK_LCX	nonclustered	LASTCHANGED
PREDISPATCHBIDTRK_NDX2	nonclustered	DUID, LASTCHANGED
PREDISPATCHBIDTRK_NDX3	nonclustered	DUID, SETTLEMENTDATE
PREDISPATCHBIDTRK_PK	clustered, unique, primary key	PREDISPATCHSEQNO, DUID, PERIODID