PASAREGIONSOLUTION (Historical table)
PASAREGIONSOLUTION shows the Regional solution for ST PASA showing reserves for each half-hour period. This table (PASAREGIONSOLUTION_D) shows the latest calculated result for each period.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| REGIONID |
varchar(10)  |
varchar(10) |
Region Identifier |
| PERIODID |
varchar(20) |
varchar(20) |
PASA Interval (48 half hours) |
| CASEID |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
PASA Case Identifier |
| DEMAND10 |
numeric(16, 6) |
numeric(16, 6) |
10% exceedence forecast |
| DEMAND50 |
numeric(16, 6) |
numeric(16, 6) |
50% exceedence forecast |
| DEMAND90 |
numeric(16, 6) |
numeric(16, 6) |
90% exceedence forecast |
| UNCONSTRAINEDCAPACITY |
numeric(16, 6) |
numeric(16, 6) |
Unconstrained capacity |
| CONSTRAINEDCAPACITY |
numeric(16, 6) |
numeric(16, 6) |
Constrained capacity |
| CAPACITYSURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Surplus capacity |
| RESERVEREQ |
numeric(16, 6) |
numeric(16, 6) |
Reserve requirement |
| RESERVECONDITION |
numeric(16, 6) |
numeric(16, 6) |
Reserve condition |
| RESERVESURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Reserve surplus |
| LOADREJECTIONRESERVEREQ |
numeric(16, 6) |
numeric(16, 6) |
Load rejection reserve requirement |
| LOADREJECTIONRESERVESURPLUS |
numeric(16, 6) |
numeric(16, 6) |
Load rejection reserve surplus |
| NETINTERCHANGEUNDEREXCESS |
numeric(16, 6) |
numeric(16, 6) |
Net interchange excess |
| NETINTERCHANGEUNDERSCARCITY |
numeric(16, 6) |
numeric(16, 6) |
Net interchange scarcity |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| EXCESSGENERATION |
numeric(22, 0) |
int |
Excess generation in period OR Deficit generation if VoLL |
| ENERGYREQUIRED |
numeric(15, 5) |
numeric(15, 5) |
Total amount of energy required for the reported day |
| CAPACITYREQUIRED |
numeric(15, 5) |
numeric(15, 5) |
Trading interval demand for the region that has a 10% probability of being exceeded, plus the medium term capacity reserve standard. |
| DATETIME |
datetime(3) |
datetime2(0) |
Date and time of the end of the period |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASAREGIONSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| PASAREGIONSOLUTION_PK |
clustered, unique, primary key |
PERIODID, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PASAREGIONSOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PASAREGIONSOLUTION |
clustered, unique, primary key |
PERIODID, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PASAREGIONSOLUTION_LCX |
nonclustered |
LASTCHANGED |
| PASAREGIONSOLUTION_PK |
clustered, unique, primary key |
PERIODID, REGIONID |