BIDDUIDDETAILSTRK

BIDDUIDDETAILSTRK shows the tracking for the associated object BIDDUIDDETAILS. Together, BIDDUIDDETAILSTRK and BIDDUIDDETAILS 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
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date of record authorisation. A NULL value indicates the record is not authorised.
AUTHORISEDBY	varchar(15)	varchar(15)	User that authorised record. A NULL value indicates the record is not authorised.
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
BIDDUIDDETAILSTRK_LCHD_IDX	nonclustered	LASTCHANGED
BIDDUIDDETAILSTRK_PK	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_BIDDUIDDETAILSTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_BIDDUIDDETAILSTRK	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
BIDDUIDDETAILSTRK_LCHD_IDX	nonclustered	LASTCHANGED
PK_BIDDUIDDETAILSTRK	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO