NETWORK_STATICRATING
NETWORK_STATICRATING lists the static rating values that will apply for a Rating Application ID. This data does not provide information for when the rating actually applies in the NEM. This is dependent on the Rating Application definition. For information on the Rating Applications please refer to the information published on the AEMO website under the topic \"Transmission Equipment Ratings\". The Rating Applications are referred to as Alternate Value Application Ratings. Ratings that normally use dynamic values will also have static rating values defined. These are used as a fallback if the dynamic rating fails.
Package
NETWORK
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| 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 type of equipment at this substation |
| 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 |
| APPLICATIONID |
varchar(20) |
varchar(20) |
The applicationid which defines the application timeframes of this rating. |
| 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) |
| RATINGVALUE |
numeric(16, 6) |
numeric(16, 6) |
The rating value in MVA that applies. This may be positive or negative depending on which side of the nominal MW flow direction the rating value applies. Flow into a transmission device is positive, flow out of the device is negative. |
| 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_STATICRATING_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_STATICRATING |
clustered, unique, primary key |
SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, RATINGLEVEL, APPLICATIONID, VALIDFROM |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_STATICRATING_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_STATICRATING |
clustered, unique, primary key |
SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, RATINGLEVEL, APPLICATIONID, VALIDFROM |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_STATICRATING_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_STATICRATING |
clustered, unique, primary key |
SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, RATINGLEVEL, APPLICATIONID, VALIDFROM |