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