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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

ELEMENTID

EQUIPMENTID

EQUIPMENTTYPE

SUBSTATIONID

VALIDFROM


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SUBSTATIONID

VARCHAR(30)

X

ID uniquely identifying the substation this equipment is located at

EQUIPMENTTYPE

VARCHAR(10)

X

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)

X

A unique identifier for this type of equipment at this substation

VALIDFROM

TIMESTAMP(3)

X

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)

X

Equipment element id