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