Table: STATIONOWNER

STATIONOWNER

Name

STATIONOWNER

Comment

STATIONOWNER sets out the owner details of each station.


Description

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

Source

STATIONOWNER is updated whenever there is a change in the station owner or new units are registered.


Primary Key Columns

Name

EFFECTIVEDATE

PARTICIPANTID

STATIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

STATIONID

EFFECTIVEDATE

VERSIONNO


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

X

Effective date of this record

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

STATIONID

VARCHAR2(10)

X

Station Identifier

VERSIONNO

NUMBER(3,0)

X

Version no of record within the effective date

LASTCHANGED

DATE

 

Last date and time record changed