CONTRACTRESTARTUNITS

CONTRACTRESTARTUNITS shows Restart units provided under a system restart contract. A service can have multiple units.

Package

ANCILLARY_SERVICES

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(10)	varchar(10)	Contract Identifier
VERSIONNO	numeric(3, 0)	smallint	Version No of contract
DUID	varchar(10)	varchar(10)	Dispatchable Unit identifier
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
AUTHORISEDBY	varchar(15)	varchar(15)	-
AUTHORISEDDATE	datetime(3)	datetime2(0)	-

Official MMS data model indexes

Index name	Index type	Index columns (in order)
CONTRACTRESTARTUNITS_LCX	nonclustered	LASTCHANGED
CONTRACTRESTARTUNITS_NDX2	nonclustered	CONTRACTID
CONTRACTRESTARTUNITS_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO, DUID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_CONTRACTRESTARTUNITS_CONTRACTID	nonclustered	CONTRACTID
IX_CONTRACTRESTARTUNITS_LASTCHANGED	nonclustered	LASTCHANGED
PK_CONTRACTRESTARTUNITS	clustered, unique, primary key	CONTRACTID, VERSIONNO, DUID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
CONTRACTRESTARTUNITS_LCX	nonclustered	LASTCHANGED
CONTRACTRESTARTUNITS_NDX2	nonclustered	CONTRACTID
CONTRACTRESTARTUNITS_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO, DUID