NETWORK_SUBSTATIONDETAIL
NETWORK_SUBSTATIONDETAIL sets out the attributes of sub-stations across time.
Package
NETWORK
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SUBSTATIONID |
varchar(30)  |
varchar(30) |
ID uniquely identifying this substation |
| VALIDFROM |
datetime(3) |
datetime2(3) |
The record is valid from this date (inclusive) |
| VALIDTO |
datetime(3) |
datetime2(3) |
The record is valid up until this date (exclusive) |
| DESCRIPTION |
varchar(100) |
varchar(100) |
Description of the substation |
| REGIONID |
varchar(10) |
varchar(10) |
The NEM region the substation is in |
| OWNERID |
varchar(30) |
varchar(30) |
The TNSP who is responsible for this substation |
| LASTCHANGED |
datetime(3) |
datetime2(3) |
The time that this record was last changed. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_SUBSTATIONDETAIL_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_SUBSTATIONDETAIL |
clustered, unique, primary key |
SUBSTATIONID, VALIDFROM |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_NETWORK_SUBSTATIONDETAIL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_NETWORK_SUBSTATIONDETAIL |
clustered, unique, primary key |
SUBSTATIONID, VALIDFROM |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NETWORK_SUBSTATIONDETAIL_LCX |
nonclustered |
LASTCHANGED |
| PK_NETWORK_SUBSTATIONDETAIL |
clustered, unique, primary key |
SUBSTATIONID, VALIDFROM |