INTERMITTENT_FORECAST_TRK
Uniquely tracks which Intermittent Generation forecast was used for the DUID in which Dispatch run.
Package
DISPATCH
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
DateTime of the Dispatch run (dispatch interval ending) |
| DUID |
varchar(20) |
varchar(20) |
Tracks to INTERMITTENT_DS_RUN.DUID |
| ORIGIN |
varchar(20) |
varchar(20) |
Tracks to INTERMITTENT_DS_RUN.ORIGIN, except when the forecast used is either SCADA or FCST or Last Target |
| FORECAST_PRIORITY |
numeric(10, 0) |
int |
Tracks to INTERMITTENT_DS_RUN.FORECAST_PRIORITY, except for -1 which denotes SCADA or FCST, and 0 which denotes Last Target |
| OFFERDATETIME |
datetime(3) |
datetime2(0) |
Tracks to INTERMITTENT_DS_RUN.OFFERDATETIME |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTERMITTENT_FORECAST_TRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_INTERMITTENT_FORECAST_TRK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTERMITTENT_FORECAST_TRK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID |