STADUALLOC

STADUALLOC sets out details on the allocation of dispatchable units to particular sites or stations.

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)	datetime2(0)	Effective date of this record
STATIONID	varchar(10)	varchar(10)	Station Identifier
VERSIONNO	numeric(3, 0)	smallint	Version no of this record for the effective date
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
STADUALLOC_LCX	nonclustered	LASTCHANGED
STADUALLOC_NDX2	nonclustered	STATIONID, EFFECTIVEDATE, VERSIONNO
STADUALLOC_NDX3	nonclustered	DUID
STADULLOC_PK	clustered, unique, primary key	STATIONID, EFFECTIVEDATE, VERSIONNO, DUID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_STADUALLOC_DUID	nonclustered	DUID
IX_STADUALLOC_LASTCHANGED	nonclustered	LASTCHANGED
IX_STADUALLOC_STATIONID_EFFECTIVEDATE_VERSIONNO	nonclustered	STATIONID, EFFECTIVEDATE, VERSIONNO
PK_STADUALLOC	clustered, unique, primary key	STATIONID, EFFECTIVEDATE, VERSIONNO, DUID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
STADUALLOC_LCX	nonclustered	LASTCHANGED
STADUALLOC_NDX2	nonclustered	STATIONID, EFFECTIVEDATE, VERSIONNO
STADUALLOC_NDX3	nonclustered	DUID
STADULLOC_PK	clustered, unique, primary key	STATIONID, EFFECTIVEDATE, VERSIONNO, DUID