METERDATA_GEN_DUID (Historical table)
Recorded actual generation of non-scheduled units where SCADA data is available.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INTERVAL_DATETIME |
datetime(3)  |
datetime2(0) |
Timestamp of the recorded interval |
| DUID |
varchar(10) |
varchar(10) |
Unit ID |
| MWH_READING |
numeric(18, 8) |
numeric(18, 8) |
MW reading |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Timestamp of last record change |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_GEN_DUID_LCX |
nonclustered |
LASTCHANGED |
| METERDATA_GEN_DUID_PK |
clustered, unique, primary key |
INTERVAL_DATETIME, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_METERDATA_GEN_DUID |
clustered, unique, primary key |
INTERVAL_DATETIME, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| METERDATA_GEN_DUID_CCI |
clustered, columnstore |
n/a |
| PK_METERDATA_GEN_DUID |
nonclustered, unique, primary key |
DUID, INTERVAL_DATETIME |