Table: STATION

STATION

Name

STATION

Comment

STATION sets out valid station identifiers.


Description

STATION is public data, and is available to all participants.

Source

STATION updates whenever there is a station configuration change or new unit registration.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

STATIONID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

STATIONID

VARCHAR2(10)

X

Station Identifier

STATIONNAME

VARCHAR2(80)

 

Full name of station

ADDRESS1

VARCHAR2(80)

 

Station Address

ADDRESS2

VARCHAR2(80)

 

Station Address

ADDRESS3

VARCHAR2(80)

 

Station Address

ADDRESS4

VARCHAR2(80)

 

Station Address

CITY

VARCHAR2(40)

 

City

STATE

VARCHAR2(10)

 

State of Australia

POSTCODE

VARCHAR2(10)

 

Post Code

LASTCHANGED

DATE

 

Last date and time record changed

CONNECTIONPOINTID

VARCHAR2(10)

 

Not used. Do not use as the Connection Point Identifier for station load