DISPATCH_UNIT_SCADA
Dispatchable unit MW from SCADA at the start of the dispatch interval. The table includes all scheduled and semi-scheduled (and non-scheduled units where SCADA is available).
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date Time of the Dispatch Interval |
| DUID |
varchar(20) |
varchar(20) |
Dispatchable Unit Identifier |
| SCADAVALUE |
numeric(16, 6) |
numeric(9, 5) (not nullable) |
Instantaneous MW reading from SCADA at the start of the Dispatch interval |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_UNIT_SCADA_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCH_UNIT_SCADA |
clustered, unique, primary key |
SETTLEMENTDATE, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_UNIT_SCADA_CCI |
clustered, columnstore |
n/a |
| PK_DISPATCH_UNIT_SCADA |
nonclustered, unique, primary key |
DUID, SETTLEMENTDATE |