Skip to content

CONTRACTGOVERNOR (Historical table)

CONTRACTGOVERNOR became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. CONTRACTGOVERNOR shows Governor contract details used in the settlement and dispatch of this service. Note services are dispatched as 6 and 60 raise and lower Frequency Control Ancillary Services (FCAS). Lower and raise 6 and 60 second fields are used in dispatch of services. Deadband and Droop details are used in settlements.

Package

HISTORICAL_TABLES

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
DUID varchar(10) varchar(10) Dispatchable Unit ID
CCPRICE numeric(10, 2) numeric(10, 2) Compensation Cap
LOWER60SECBREAKPOINT numeric(9, 6) numeric(9, 6) Limit Equation Lower 60 Second Breakpoint MW
LOWER60SECMAX numeric(9, 6) numeric(9, 6) Limit Equation Lower 60 Second Maximum MW
LOWER6SECBREAKPOINT numeric(9, 6) numeric(9, 6) Limit Equation Lower 6 Second Breakpoint MW
LOWER6SECMAX numeric(9, 6) numeric(9, 6) Limit Equation Lower 6 Second Maximum MW
RAISE60SECBREAKPOINT numeric(9, 6) numeric(9, 6) Limit Equation Raise 60 Second Breakpoint MW
RAISE60SECCAPACITY numeric(9, 6) numeric(9, 6) Limit Equation Raise 60 Second Capacity MW
RAISE60SECMAX numeric(9, 6) numeric(9, 6) Limit Equation Raise 60 Second Maximum MW
RAISE6SECBREAKPOINT numeric(9, 6) numeric(9, 6) Limit Equation Raise 6 Second Breakpoint MW
RAISE6SECCAPACITY numeric(9, 6) numeric(9, 6) Limit Equation Raise 6 Second Capacity MW
RAISE6SECMAX numeric(9, 6) numeric(9, 6) Limit Equation Raise 6 Second Maximum MW
PRICE6SECRAISEMANDATORY numeric(16, 6) numeric(16, 6) Not used
QUANT6SECRAISEMANDATORY numeric(16, 6) numeric(16, 6) Not used
PRICE6SECRAISECONTRACT numeric(16, 6) numeric(16, 6) Contract Price for 6 Second Raise
QUANT6SECRAISECONTRACT numeric(16, 6) numeric(16, 6) Contract Quantity for 6 Second Raise
PRICE60SECRAISEMANDATORY numeric(16, 6) numeric(16, 6) Not used
QUANT60SECRAISEMANDATORY numeric(16, 6) numeric(16, 6) Not used
PRICE60SECRAISECONTRACT numeric(16, 6) numeric(16, 6) Contract Price for 60 Second Raise
QUANT60SECRAISECONTRACT numeric(16, 6) numeric(16, 6) Contract Quantity for 60 Second Raise
PRICE6SECLOWERMANDATORY numeric(16, 6) numeric(16, 6) Not used
QUANT6SECLOWERMANDATORY numeric(16, 6) numeric(16, 6) Not used
PRICE6SECLOWERCONTRACT numeric(16, 6) numeric(16, 6) Contract Price for 6 Second Lower
QUANT6SECLOWERCONTRACT numeric(16, 6) numeric(16, 6) Contract Quantity for 6 Second Lower
PRICE60SECLOWERMANDATORY numeric(16, 6) numeric(16, 6) Not used
QUANT60SECLOWERMANDATORY numeric(16, 6) numeric(16, 6) Not used
PRICE60SECLOWERCONTRACT numeric(16, 6) numeric(16, 6) Contract Price for 60 Second Lower
QUANT60SECLOWERCONTRACT numeric(16, 6) numeric(16, 6) Contract Quantity for 60 Second Lower
DEADBANDUP numeric(4, 2) numeric(4, 2) Raise Deadband
DEADBANDDOWN numeric(4, 2) numeric(4, 2) Lower Deadband
DROOP6SECRAISEBREAKPOINT numeric(9, 6) numeric(9, 6) Droop Equation Raise 6 Second Breakpoint
DROOP6SECRAISECAPACITY numeric(9, 6) numeric(9, 6) Droop Equation Raise 6 Second Capacity
DROOP6SECRAISEMAX numeric(9, 6) numeric(9, 6) Droop Equation Raise 6 Second Maximum
DROOP60SECRAISEBREAKPOINT numeric(9, 6) numeric(9, 6) Droop Equation Raise 60 Second Breakpoint
DROOP60SECRAISECAPACITY numeric(9, 6) numeric(9, 6) Droop Equation Raise 60 Second Capacity
DROOP60SECRAISEMAX numeric(9, 6) numeric(9, 6) Droop Equation Raise 60 Second Maximum
DROOP6SECLOWERBREAKPOINT numeric(9, 6) numeric(9, 6) Droop Equation Lower 6 Second Breakpoint
DROOP6SECLOWERMAX numeric(9, 6) numeric(9, 6) Droop Equation Lower 6 Second Maximum
DROOP60SECLOWERBREAKPOINT numeric(9, 6) numeric(9, 6) Droop Equation Lower 60 Second Breakpoint
DROOP60SECLOWERMAX numeric(9, 6) numeric(9, 6) Droop Equation Lower 60 Second Maximum
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)
CONTRACTGOVERNOR_LCX nonclustered LASTCHANGED
CONTRACTGOVERNOR_NDX2 nonclustered PARTICIPANTID
CONTRACTGOVERNOR_PK clustered, unique, primary key CONTRACTID, VERSIONNO

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_CONTRACTGOVERNOR_LASTCHANGED nonclustered LASTCHANGED
IX_CONTRACTGOVERNOR_PARTICIPANTID nonclustered PARTICIPANTID
PK_CONTRACTGOVERNOR clustered, unique, primary key CONTRACTID, VERSIONNO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
CONTRACTGOVERNOR_LCX nonclustered LASTCHANGED
CONTRACTGOVERNOR_NDX2 nonclustered PARTICIPANTID
CONTRACTGOVERNOR_PK clustered, unique, primary key CONTRACTID, VERSIONNO