Table: STATIONOPERATINGSTATUS

STATIONOPERATINGSTATUS

Name

STATIONOPERATINGSTATUS

Comment

STATIONOPERATINGSTATUS sets out the operating status 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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

EFFECTIVEDATE

STATIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

X

Effective date of this record

STATIONID

VARCHAR2(10)

X

Unique station identifier

VERSIONNO

NUMBER(3,0)

X

Version no of record within the effective date

STATUS

VARCHAR2(20)

 

The operating status of this station, valid values are COMMISSIONED and DECOMMISSIONED

AUTHORISEDBY

VARCHAR2(15)

 

User authorising record

AUTHORISEDDATE

DATE

 

Date record authorised

LASTCHANGED

DATE

 

Last date and time record changed