NETWORK_EQUIPMENTDETAIL
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.
Package
NETWORK
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SUBSTATIONID |
varchar(30)  |
varchar(30) |
ID uniquely identifying the substation this equipment is located at |
| EQUIPMENTTYPE |
varchar(10) |
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) |
varchar(30) |
A unique identifier for this type of equipment at this substation |
| VALIDFROM |
datetime(3) |
datetime2(3) |
The date that this record is applies from (inclusive) |
| VALIDTO |
datetime(3) |
datetime2(3) |
The date that this record applies until (exclusive) |
| VOLTAGE |
varchar(20) |
varchar(20) |
The voltage in KV for this equipment. Transformers may have multiple voltages defined. E.g. 132_110_33 |
| DESCRIPTION |
varchar(100) |
varchar(100) |
A short description for this equipment. |
| LASTCHANGED |
datetime(3) |
datetime2(3) |
The time that this record was last changed. |
| ELEMENTID |
numeric(15, 0) |
bigint |
Equipment element id |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_EQUIPMENTDETAIL_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_EQUIPMENTDETAIL |
clustered, unique, primary key |
ELEMENTID, SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, VALIDFROM |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_EQUIPMENTDETAIL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_EQUIPMENTDETAIL |
clustered, unique, primary key |
ELEMENTID, SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, VALIDFROM |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_EQUIPMENTDETAIL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_EQUIPMENTDETAIL |
clustered, unique, primary key |
ELEMENTID, SUBSTATIONID, EQUIPMENTTYPE, EQUIPMENTID, VALIDFROM |