NETWORK_REALTIMERATING
The NETWORK_REALTIMERATING table shows the equipment rating values in MVA used as inputs to constraints in the dispatch solution. This includes values for both static and dynamic ratings. The NETWORK_RATING table can be used to determine the physical equipment the rating is for based on the SPD_ID value.
Package
NETWORK
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
The dispatch interval the rating applies to |
| SPD_ID |
varchar(21) |
varchar(21) |
ID defining this data source for use in constraints |
| RATINGVALUE |
numeric(16, 6) (not nullable) |
numeric(9, 5) (not nullable) |
The defined equipment rating value in MVA |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_NETWORK_REALTIMERATING |
clustered, unique, primary key |
SETTLEMENTDATE, SPD_ID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_NETWORK_REALTIMERATING |
clustered, unique, primary key |
SETTLEMENTDATE, SPD_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_REALTIMERATING_CCI |
clustered, columnstore |
n/a |
| PK_NETWORK_REALTIMERATING |
nonclustered, unique, primary key |
SPD_ID, SETTLEMENTDATE |