PREDISPATCHSCENARIODEMAND
PREDISPATCHSCENARIODEMAND defines the demand offsets that are applied for each of the predispatch sensitivity scenarios.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EFFECTIVEDATE |
datetime(3)  |
date |
The effective date of this set of scenarios |
| VERSIONNO |
numeric(3, 0) |
smallint |
The version of this set of scenarios |
| SCENARIO |
numeric(2, 0) |
tinyint |
The scenario identifier. |
| REGIONID |
varchar(20) |
varchar(20) |
The region to which to apply the deltaMW for this SCENARIO. |
| DELTAMW |
numeric(4, 0) |
smallint |
The MW offset that is applied for this scenario |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCHSCENARIODEMAND_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, SCENARIO, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHSCENARIODEMAND |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, SCENARIO, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PREDISPATCHSCENARIODEMAND |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, SCENARIO, REGIONID |