P5MIN_SCENARIODEMANDTRK
Tracks the 5Min scenario offset updates across time.
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 |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
The datetime that the scenario update was authorised |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The datetime that the record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_SCENARIODEMANDTRK_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_P5MIN_SCENARIODEMANDTRK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| P5MIN_SCENARIODEMANDTRK_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSION_DATETIME |