MMS Data Model Report

Table: NETWORK_RATING

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.

Notes

Visibility

Data in this table is:

Public

Primary Key Columns

SPD_ID

VALIDFROM

Index Columns

LASTCHANGED

Content

SPD_ID

VARCHAR(21)

ID defining this data source for use in constraints

VALIDFROM

DATE

The date that this record is applies from (inclusive)

VALIDTO

DATE

The date that this record applies until (exclusive)

REGIONID

VARCHAR(10)

The region that this rating is for

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 equipment at this substation, and based on its type

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

ISDYNAMIC

NUMBER(1,0)

One of:
1 = Normally uses dynamic ratings
0 = No dynamic ratings, static ratings are used

LASTCHANGED

DATE

The time that this record was last changed

Home