DELTAMW (Historical table)
DELTAMW sets out the Frequency Control Ancillary Services (FCAS) requirement to be provided locally within each region and each half-hour period in a market day. Two fields specify Frequency Controlled Ancillary Services requirements to be provided locally for the new regulation ancillary services.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:30 |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version No of record for this date |
| REGIONID |
varchar(10) |
varchar(10) |
Differentiates this region from all other regions |
| PERIODID |
numeric(2, 0) |
tinyint |
Market trading interval from 1 to 48 starting at 04:30 |
| DELTAMW |
numeric(6, 0) |
smallint |
Not Used |
| LOWER5MIN |
numeric(6, 0) |
smallint |
Lower 5 min local share requirement |
| LOWER60SEC |
numeric(6, 0) |
smallint |
Lower 60 sec local share requirement |
| LOWER6SEC |
numeric(6, 0) |
smallint |
Lower 6 sec local share requirement |
| RAISE5MIN |
numeric(6, 0) |
smallint |
Raise 5 minute local share requirement |
| RAISE60SEC |
numeric(6, 0) |
smallint |
Raise 60 sec local share requirement |
| RAISE6SEC |
numeric(6, 0) |
smallint |
Raise 6 sec local share requirement |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| RAISEREG |
numeric(6, 0) |
smallint |
Raise Regulation local share requirement |
| LOWERREG |
numeric(6, 0) |
smallint |
Lower Regulation local share requirement |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DELTAMW_LCX |
nonclustered |
LASTCHANGED |
| DELTAMW_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, REGIONID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DELTAMW_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DELTAMW |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, REGIONID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DELTAMW_LCX |
nonclustered |
LASTCHANGED |
| DELTAMW_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, REGIONID, PERIODID |