MMS Data Model Report

Table: NETWORK_STATICRATING

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.

Notes

Visibility

Data in this table is:

Public

Primary Key Columns

APPLICATIONID

EQUIPMENTID

EQUIPMENTTYPE

RATINGLEVEL

SUBSTATIONID

VALIDFROM

Index Columns

LASTCHANGED

Content

SUBSTATIONID

VARCHAR(30)

The substation the equipment is located at

EQUIPMENTTYPE

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)

A unique identifier for this type of equipment at this substation

RATINGLEVEL

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)

The applicationid which defines the application timeframes of this rating.

VALIDFROM

DATE

The date that this record is applies from (inclusive)

VALIDTO

DATE

The date that this record applies until (exclusive)

RATINGVALUE

NUMBER(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

DATE

The time that this record was last changed.

Home