MTPASA_REGIONITERATION
Region results for Unserved Energy (USE).
Package
MTPASA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins. |
| RUN_NO |
numeric(4, 0) |
smallint |
Unique run id. |
| RUNTYPE |
varchar(20) |
varchar(20) |
Type of run. Always RELIABILITY |
| DEMAND_POE_TYPE |
varchar(20) |
varchar(20) |
Demand POE type used. Value is POE10 or POE50 |
| AGGREGATION_PERIOD |
varchar(20) |
varchar(20) |
Period data is aggregated over. Values are YEAR |
| PERIOD_ENDING |
datetime(3) |
datetime2(0) |
Datetime of day at end of period (i.e. last day of year reported) |
| REGIONID |
varchar(20) |
varchar(20) |
The unique region identifier |
| USE_ITERATION_ID |
numeric(5, 0) |
int |
Iteration ID, only produced for iterations showing unserved energy>0 |
| USE_ITERATION_EVENT_NUMBER |
numeric(12, 2) |
numeric(12, 2) |
Number of half hours showing unserved energy over year, for iteration |
| USE_ITERATION_EVENT_AVERAGE |
numeric(12, 2) |
numeric(12, 2) |
Average unserved energy event size for iteration over year (MW) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_REGIONITERATION_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, AGGREGATION_PERIOD, PERIOD_ENDING, REGIONID, USE_ITERATION_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_REGIONITERATION |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, AGGREGATION_PERIOD, PERIOD_ENDING, REGIONID, USE_ITERATION_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_REGIONITERATION_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO, RUNTYPE, DEMAND_POE_TYPE, AGGREGATION_PERIOD, PERIOD_ENDING, REGIONID, USE_ITERATION_ID |