MTPASAREGIONSOLUTION_D (Historical table)
MTPASAREGIONSOLUTION_D shows region results for MT PASA, showing predicted demand and any capacity limits.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| DATETIME |
datetime(3)  |
datetime2(0) |
Date of results. One record for each day for next two years. |
| REGION_ID |
varchar(12) |
varchar(12) |
Region Identifier |
| RUN_DATETIME |
datetime(3) |
datetime2(0) (not nullable) |
The run date and time |
| RESERVE_CONDITION |
varchar(50) |
varchar(50) |
The regional reserve condition |
| RESERVE_SURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Regional reserve surplus value |
| CAPACITY_REQUIREMENT |
numeric(16, 6) |
numeric(16, 6) |
Capacity in MW required to meet demand |
| MINIMUM_RESERVE_REQUIREMENT |
numeric(16, 6) |
numeric(16, 6) |
Minimum required regional reserve value |
| REGION_DEMAND_10POE |
numeric(16, 6) |
numeric(16, 6) |
Regional 10% Probability of Exceedance demand forecast value |
| DEMAND_MINUS_SCHEDULED_LOAD |
numeric(16, 6) |
numeric(16, 6) |
Regional demand minus the scheduled load value |
| CONSTRAINED_CAPACITY |
numeric(16, 6) |
numeric(16, 6) |
The total regional capacity due to energy and network constraints |
| UNCONSTRAINED_CAPACITY |
numeric(16, 6) |
numeric(16, 6) |
The total regional capacity, subject to network constraints. |
| NET_INTERCHANGE |
numeric(16, 6) |
numeric(16, 6) |
Regional net MW import via interconnectors |
| ENERGY_REQUIREMENT_10POE |
numeric(16, 6) |
numeric(16, 6) |
Regional energy required to meet demand |
| REPORTED_BLOCK_ID |
numeric(16, 6) |
numeric(16, 6) |
The load duration curve block that is recorded in the report. |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last change date and time. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASAREGIONSOLUTION_D_LCX |
nonclustered |
LASTCHANGED |
| MTPASAREGIONSOLUTION_D_PK |
clustered, unique, primary key |
DATETIME, REGION_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MTPASAREGIONSOLUTION_D_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MTPASAREGIONSOLUTION_D |
clustered, unique, primary key |
DATETIME, REGION_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASAREGIONSOLUTION_D_LCX |
nonclustered |
LASTCHANGED |
| MTPASAREGIONSOLUTION_D_PK |
clustered, unique, primary key |
DATETIME, REGION_ID |