NETWORK_RATING
NETWORK_RATING defines a list of the equipment ratings that may be used as inputs to market constraints. If the rating is flagged as dynamic then in real-time the rating will be dynamically determined and the static value will be used as a fallback value should the dynamic value fail. Note: In some rare cases equipment has ratings provided from more than one TNSP. This is identified by a different SPD Id. The value used in the NEM is normally the more restrictive of the two values.
Package
NETWORK
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SPD_ID |
varchar(21)  |
varchar(21) |
ID defining this data source for use in constraints |
| VALIDFROM |
datetime(3) |
datetime2(0) |
The date that this record is applies from (inclusive) |
| VALIDTO |
datetime(3) |
datetime2(0) |
The date that this record applies until (exclusive) |
| REGIONID |
varchar(10) |
varchar(10) |
The region that this rating is for |
| SUBSTATIONID |
varchar(30) |
varchar(30) |
The substation the equipment is located at |
| EQUIPMENTTYPE |
varchar(10) |
varchar(10) |
The type of equipment. Valid values are: LINE = Line TRANS = Transformer CB = Circuit breaker ISOL = Isolator CAP = Capacitor REAC = Reactor UNIT = Unit |
| EQUIPMENTID |
varchar(30) |
varchar(30) |
A unique identifier for this equipment at this substation, and based on its type |
| RATINGLEVEL |
varchar(10) |
varchar(10) |
The rating level of the value used, one of: NORM = Continuous rating value. Applied under pre-contingent conditions. EMER = Continuous rating value. Applied under pre-contingent conditions LDSH = Load Shedding |
| ISDYNAMIC |
numeric(1, 0) |
tinyint |
One of: 1 = Normally uses dynamic ratings 0 = No dynamic ratings, static ratings are used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The time that this record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_RATING_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_RATING |
clustered, unique, primary key |
SPD_ID, VALIDFROM |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_RATING_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_RATING |
clustered, unique, primary key |
SPD_ID, VALIDFROM |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_RATING_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_RATING |
clustered, unique, primary key |
SPD_ID, VALIDFROM |