Table: NETWORK_SUBSTATIONDETAIL

NETWORK_SUBSTATIONDETAIL

Name

NETWORK_SUBSTATIONDETAIL

Comment

NETWORK_SUBSTATIONDETAIL sets out the attributes of sub-stations across time


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

SUBSTATIONID

VALIDFROM


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SUBSTATIONID

VARCHAR(30)

X

ID uniquely identifying this substation

VALIDFROM

TIMESTAMP(3)

X

The record is valid from this date (inclusive)

VALIDTO

TIMESTAMP(3)

 

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

TIMESTAMP(3)

 

The time that this record was last changed.