Name |
|
Comment |
NETWORK_SUBSTATIONDETAIL sets out the attributes of sub-stations across time |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
SUBSTATIONID |
VALIDFROM |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
SUBSTATIONID |
VARCHAR(30) |
X |
ID uniquely identifying this substation |
VALIDFROM |
DATE |
X |
The record is valid from this date (inclusive) |
VALIDTO |
DATE |
|
The record is valid up until this date (exclusive) |
DESCRIPTION |
VARCHAR(100) |
|
Description of the substation |
REGIONID |
VARCHAR(10) |
|
The NEM region the substation is in |
OWNERID |
VARCHAR(30) |
|
The TNSP who is responsible for this substation |
LASTCHANGED |
DATE |
|
The time that this record was last changed. |
|
|
|