CONTRACTUNITLOADING (Historical table)
CONTRACTUNITLOADING became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. CONTRACTUNITLOADING shows Unit Loading contract details used in the settlement and dispatch of this service.
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 |
| RPRICE |
numeric(10, 2) |
numeric(10, 2) |
Enabling Price |
| SUPRICE |
numeric(10, 2) |
numeric(10, 2) |
Usage Price |
| CCPRICE |
numeric(10, 2) |
numeric(10, 2) |
Compensation Cap |
| ACR |
numeric(10, 2) |
numeric(10, 2) |
Available Control Range |
| BS |
numeric(10, 2) |
numeric(10, 2) |
Block Size of Unit |
| PP |
numeric(10, 2) |
numeric(10, 2) |
Estimated Price for supply |
| EU |
numeric(10, 2) |
numeric(10, 2) |
Estimated Power consumption of unit when enabled for RGUL |
| 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) |
| CONTRACTUNITLOADING_LCX |
nonclustered |
LASTCHANGED |
| CONTRACTUNITLOADING_NDX2 |
nonclustered |
PARTICIPANTID |
| CONTRACTUNITLOADING_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_CONTRACTUNITLOADING_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_CONTRACTUNITLOADING_PARTICIPANTID |
nonclustered |
PARTICIPANTID |
| PK_CONTRACTUNITLOADING |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CONTRACTUNITLOADING_LCX |
nonclustered |
LASTCHANGED |
| CONTRACTUNITLOADING_NDX2 |
nonclustered |
PARTICIPANTID |
| CONTRACTUNITLOADING_PK |
clustered, unique, primary key |
CONTRACTID, VERSIONNO |