RESERVE
RESERVE sets out specific reserve requirements for dispatch, predispatch and STPASA, for each half-hour interval by region. Updates show as new versions for a date.
Package
RESERVE_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:00am |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version No of record for this date, the version of the file loaded to produce these reserve figures |
| REGIONID |
varchar(12) |
varchar(12) |
Differentiates this region from all other regions |
| PERIODID |
numeric(2, 0) |
smallint |
Market Trading Interval |
| LOWER5MIN |
numeric(6, 0) |
smallint |
Lower 5 minute reserve requirement |
| LOWER60SEC |
numeric(6, 0) |
smallint |
Lower 60 second reserve requirement |
| LOWER6SEC |
numeric(6, 0) |
smallint |
Lower 6 second reserve requirement |
| RAISE5MIN |
numeric(6, 0) |
smallint |
Raise 5 minute reserve requirement |
| RAISE60SEC |
numeric(6, 0) |
smallint |
Raise 60 second reserve requirement |
| RAISE6SEC |
numeric(6, 0) |
smallint |
Raise 6 second reserve requirement |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| PASARESERVE |
numeric(6, 0) |
smallint |
PASA reserve requirement |
| LOADREJECTIONRESERVEREQ |
numeric(10, 0) |
smallint |
PASA Load rejection reserve requirement |
| RAISEREG |
numeric(6, 0) |
smallint |
Raise Regulation reserve requirement |
| LOWERREG |
numeric(6, 0) |
smallint |
Lower Regulation reserve requirement |
| LOR1LEVEL |
numeric(6, 0) |
smallint |
PASA Lack of Reserve 1 Level |
| LOR2LEVEL |
numeric(6, 0) |
smallint |
PASA Lack of Reserve 1 Level |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESERVE_LCX |
nonclustered |
LASTCHANGED |
| RESERVE_PK |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID, VERSIONNO, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESERVE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESERVE |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESERVE_LCX |
nonclustered |
LASTCHANGED |
| RESERVE_PK |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID, VERSIONNO, PERIODID |