CONTRACTRESTARTSERVICES

CONTRACTRESTARTSERVICES shows Restart Services contract details used in the settlement and dispatch of this service.

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	Contract Version No.
STARTDATE	datetime(3)	datetime2(0)	Starting Date of Contract
ENDDATE	datetime(3)	datetime2(0)	Termination Date of Contract
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
RESTARTTYPE	numeric(1, 0)	tinyint	Restart Type - 0 = BlackStart, 1 = Combination, 2 = Trip To House
RCPRICE	numeric(6, 2)	numeric(6, 2)	Availability Price
TRIPTOHOUSELEVEL	numeric(5, 0)	int	Trip To House Level
AUTHORISEDBY	varchar(15)	varchar(15)	User Name
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date Contract was Authorised
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
DEFAULT_TESTINGPAYMENT_AMOUNT	numeric(18, 8)	numeric(18, 8)	The NMAS default payment amount
SERVICE_START_DATE	datetime(3)	datetime2(0)	The NMAS Testing Service Start Date

Official MMS data model indexes

Index name	Index type	Index columns (in order)
CONTRACTRESTARTSERVI_NDX2	nonclustered	PARTICIPANTID
CONTRACTRESTARTSERVICES_LCX	nonclustered	LASTCHANGED
CONTRACTRESTARTSERVICES_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_CONTRACTRESTARTSERVICES_LASTCHANGED	nonclustered	LASTCHANGED
IX_CONTRACTRESTARTSERVICES_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_CONTRACTRESTARTSERVICES	clustered, unique, primary key	CONTRACTID, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
CONTRACTRESTARTSERVI_NDX2	nonclustered	PARTICIPANTID
CONTRACTRESTARTSERVICES_LCX	nonclustered	LASTCHANGED
CONTRACTRESTARTSERVICES_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO