DUALLOC

DUALLOC cross references dispatch unit identifier to genset ID for each participant.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
EFFECTIVEDATE	datetime(3)	datetime2(0)	Effective calendar date of record
VERSIONNO	numeric(3, 0)	smallint	Version no of record
DUID	varchar(10)	varchar(10)	Dispatchable Unit identifier
GENSETID	varchar(20)	varchar(20)	Physical unit identifier
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
DUALLOC_LCX	nonclustered	LASTCHANGED
DUALLOC_NDX2	nonclustered	DUID
DUALLOC_PK	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO, GENSETID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_DUALLOC_DUID	nonclustered	DUID
IX_DUALLOC_LASTCHANGED	nonclustered	LASTCHANGED
PK_DUALLOC	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO, GENSETID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
DUALLOC_LCX	nonclustered	LASTCHANGED
DUALLOC_NDX2	nonclustered	DUID
DUALLOC_PK	clustered, unique, primary key	DUID, EFFECTIVEDATE, VERSIONNO, GENSETID