BIDDUIDDETAILS

BIDDUIDDETAILS and the associated tracking object BIDDUIDDETAILSTRK define the registration data for each ancillary service a dispatchable unit is registered to provide. The registration data is required to validate a dispatchable unit bid submitted for that ancillary service.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
DUID	varchar(10)	varchar(10)	Dispatchable unit identifier
EFFECTIVEDATE	datetime(3)	date	Market date starting at 04:30 inclusive
VERSIONNO	numeric(3, 0)	smallint	Record version number
BIDTYPE	varchar(10)	varchar(10)	Bid Type Identifier
MAXCAPACITY	numeric(22, 0)	smallint	Maximum Capacity of this DUID for this BIDTYPE
MINENABLEMENTLEVEL	numeric(22, 0)	smallint	Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only)
MAXENABLEMENTLEVEL	numeric(22, 0)	smallint	Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only)
MAXLOWERANGLE	numeric(3, 0)	smallint	Maximum Angle at the lower end of the ancillary service profile (Degrees)
MAXUPPERANGLE	numeric(3, 0)	smallint	Maximum Angle at the upper end of the ancillary service profile (Degrees)
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BIDDUIDDETAILS_LCHD_IDX	nonclustered	LASTCHANGED
BIDDUIDDETAILS_PK	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO, BIDTYPE

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BIDDUIDDETAILS_LASTCHANGED	nonclustered	LASTCHANGED
PK_BIDDUIDDETAILS	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO, BIDTYPE

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BIDDUIDDETAILS_LCHD_IDX	nonclustered	LASTCHANGED
PK_BIDDUIDDETAILS	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO, BIDTYPE