Name |
|
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. |
Name |
ELEMENTID |
EQUIPMENTID |
EQUIPMENTTYPE |
SUBSTATIONID |
VALIDFROM |
Name |
LASTCHANGED |
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: |
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. |
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 |
|
|
|