PERDEMAND
PERDEMAND sets out the regional demands and MR schedule data for each half-hour period. PERDEMAND is a child table to RESDEMANDTRK.
Package
DEMAND_FORECASTS
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date of forecast up to 7 days ahead. |
| REGIONID |
varchar(10) |
varchar(10) |
Differentiates this region from all other regions |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Date record issued |
| PERIODID |
numeric(3, 0) |
smallint |
Half hourly trading intervals from 04:30. |
| VERSIONNO |
numeric(3, 0) |
smallint |
The version of the RESDEMAND file for this date |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Market date the forecast is made for. First date of the 7 days. |
| RESDEMAND |
numeric(10, 0) |
int |
Base Demand forecast for period |
| DEMAND90PROBABILITY |
numeric(10, 0) |
int |
Demand at 90% probability of exceedance |
| DEMAND10PROBABILITY |
numeric(10, 0) |
int |
Demand level for a 10% probability of exceedance |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| MR_SCHEDULE |
numeric(6, 0) |
int |
MR_Schedule = Unrestricted Demand - POE |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PERDEMAND_LCX |
nonclustered |
LASTCHANGED |
| PERDEMAND_PK |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID, OFFERDATE, VERSIONNO, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PERDEMAND_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PERDEMAND |
clustered, unique, primary key |
SETTLEMENTDATE, REGIONID, OFFERDATE, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PERDEMAND_CCI |
clustered, columnstore |
n/a |
| PK_PERDEMAND |
nonclustered, unique, primary key |
SETTLEMENTDATE, REGIONID, OFFERDATE, VERSIONNO, PERIODID |