Electricity Data Model Report

Table: NETWORK_EQUIPMENTDETAIL

NETWORK_EQUIPMENTDETAIL

Name	NETWORK_EQUIPMENTDETAIL
Comment	NETWORK_EQUIPMENTDETAIL Provides details on equipment that may have outages or ratings. A single piece of equipment may have multiple records if its details change. A line will typically have at least two valid records at a time, once for each end of the line.

Primary Key Columns

ELEMENTID

EQUIPMENTID

EQUIPMENTTYPE

SUBSTATIONID

VALIDFROM

Content

SUBSTATIONID

VARCHAR(30)

ID uniquely identifying the substation this 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

VALIDFROM

TIMESTAMP(3)

The date that this record is applies from (inclusive)

VALIDTO

TIMESTAMP(3)

The date that this record applies until (exclusive)

VOLTAGE

VARCHAR(20)

The voltage in KV for this equipment.
Transformers may have multiple voltages defined.
E.g. 132_110_33

DESCRIPTION

VARCHAR(100)

A short description for this equipment.

LASTCHANGED

TIMESTAMP(3)

The time that this record was last changed.

ELEMENTID

NUMBER(15,0)

Equipment element id

Table: NETWORK_OUTAGECONSTRAINTSET

NETWORK_OUTAGECONSTRAINTSET

Name	NETWORK_OUTAGECONSTRAINTSET
Comment	NETWORK_OUTAGECONSTRAINTSET lists the Constraint Set or Sets that are expected to be invoked for the outage once it is confirmed to proceed.

Content

OUTAGEID

NUMBER(15,0)

ID uniquely identifying the outage

GENCONSETID

VARCHAR(50)

ID for the constraint set

STARTINTERVAL

DATE

The dispatch interval that this constraint applies from

ENDINTERVAL

DATE

The dispatch interval that this constraint applies until.

Table: NETWORK_OUTAGEDETAIL

NETWORK_OUTAGEDETAIL

Name	NETWORK_OUTAGEDETAIL
Comment	Lists asset owners planned outages for transmission equipment. This also includes details for transmission equipment that will not have an outage, but associated secondary equipment has an outage and a related constraint set may be invoked. This scenario is indicated by the ISSECONDARY field in the table

Primary Key Columns

ELEMENTID

EQUIPMENTID

EQUIPMENTTYPE

OUTAGEID

STARTTIME

SUBSTATIONID

Content

OUTAGEID

NUMBER(15,0)

ID uniquely identifying the outage

SUBSTATIONID

VARCHAR(30)

The substation this 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

STARTTIME

DATE

The planned starting date and time of the outage

ENDTIME

DATE

The planned ending date and time of the outage

SUBMITTEDDATE

DATE

The date and time this outage was first submitted

OUTAGESTATUSCODE

VARCHAR(10)

A code representing the status of the outage.
The OUTAGESTATUSCODE table will store a detailed description of each code.

RESUBMITREASON

VARCHAR(50)

Changes to an outage key details may require the outage to be resubmitted.
A new outage id will then be allocated and the outage will be reassessed.
This field will detail the reason for the change.

RESUBMITOUTAGEID

NUMBER(15,0)

The new outage id created from a resubmit.

RECALLTIMEDAY

NUMBER(10,0)

The recall time in minutes during the day

RECALLTIMENIGHT

NUMBER(10,0)

The recall time in minutes during the night

LASTCHANGED

TIMESTAMP(3)

The time that this record was last changed

REASON

VARCHAR2(100)

The reason provided by the asset owner for this outage

ISSECONDARY

NUMBER(1,0)

1 = The outage is for a secondary piece of equipment that has an associated constraint set. The transmission equipment is still in service. 0 = The outage is for the transmission equipment

ACTUAL_STARTTIME

DATE

The actual starting date/time of the outage

ACTUAL_ENDTIME

DATE

The actual ending date/time of the outage

COMPANYREFCODE

VARCHAR2(20)

The asset owners reference code for this outage

ELEMENTID

NUMBER(15,0)

Equipment element id

Table: NETWORK_OUTAGESTATUSCODE

NETWORK_OUTAGESTATUSCODE

Name	NETWORK_OUTAGESTATUSCODE
Comment	NETWORK_OUTAGESTATUSCODE describes the different outage status codes

Content

OUTAGESTATUSCODE

VARCHAR(10)

A code representing the status of an outage

DESCRIPTION

VARCHAR(100)

A description of the status code

LASTCHANGED

DATE

The time that this record was last changed

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

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

Table: NETWORK_REALTIMERATING

NETWORK_REALTIMERATING

Name	NETWORK_REALTIMERATING
Comment	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.

Notes

Visibility

Public

Primary Key Columns

SETTLEMENTDATE

SPD_ID

Content

SETTLEMENTDATE

DATE

The dispatch interval the rating applies to

SPD_ID

VARCHAR(21)

ID defining this data source for use in constraints

RATINGVALUE

NUMBER(16,6)

The defined equipment rating value in MVA

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

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)

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.

Table: NETWORK_SUBSTATIONDETAIL

NETWORK_SUBSTATIONDETAIL

Name	NETWORK_SUBSTATIONDETAIL
Comment	NETWORK_SUBSTATIONDETAIL sets out the attributes of sub-stations across time

ID uniquely identifying this substation

VALIDFROM

TIMESTAMP(3)

The record is valid from this date (inclusive)

VALIDTO

TIMESTAMP(3)

The record is valid up until this date (exclusive)

DESCRIPTION

VARCHAR(100)

Description of the substation

REGIONID

VARCHAR(10)

The NEM region the substation is in

OWNERID

VARCHAR(30)

The TNSP who is responsible for this substation

LASTCHANGED

TIMESTAMP(3)

The time that this record was last changed.

Home