CONTRACTAGC

CONTRACTAGC shows Automatic Generation Control (AGC) contract details for each dispatchable unit. There is a separate contract for each unit.

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)	End date of contract
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
DUID	varchar(10)	varchar(10)	Dispatchable Unit ID
CRR	numeric(4, 0)	smallint	Control Range Raise 5 Min MW
CRL	numeric(4, 0)	smallint	Control Range Lower 5 Min MW
RLPRICE	numeric(10, 2)	numeric(10, 2)	Enabling Price in $
CCPRICE	numeric(10, 2)	numeric(10, 2)	Compensation Cap in $
BS	numeric(10, 2)	numeric(10, 2)	Block Size
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

Official MMS data model indexes

Index name	Index type	Index columns (in order)
CONTRACTAGC_LCX	nonclustered	LASTCHANGED
CONTRACTAGC_NDX2	nonclustered	PARTICIPANTID, CONTRACTID
CONTRACTAGC_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_CONTRACTAGC_LASTCHANGED	nonclustered	LASTCHANGED
IX_CONTRACTAGC_PARTICIPANTID_CONTRACTID	nonclustered	PARTICIPANTID, CONTRACTID
PK_CONTRACTAGC	clustered, unique, primary key	CONTRACTID, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
CONTRACTAGC_LCX	nonclustered	LASTCHANGED
CONTRACTAGC_NDX2	nonclustered	PARTICIPANTID, CONTRACTID
CONTRACTAGC_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO