P5MIN_SCENARIODEMAND
The P5Min scenario MW offsets.
Package
P5MIN
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
datetime2(0) |
The effective date of this set of scenarios |
| VERSION_DATETIME |
datetime(3) |
datetime2(0) |
The version of this set of scenarios |
| SCENARIO |
numeric(2, 0) |
smallint |
The scenario identifier |
| REGIONID |
varchar(20) |
varchar(20) |
The region to which to apply the deltaMW for this SCENARIO |
| DELTAMW |
numeric(4, 0) |
smallint (not nullable) |
The MW offset to apply to region total demand for this SCENARIO |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_SCENARIODEMAND_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, REGIONID, SCENARIO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_SCENARIODEMAND |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, REGIONID, SCENARIO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_SCENARIODEMAND |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME, REGIONID, SCENARIO |