Table: STATIONOWNERTRK

STATIONOWNERTRK

Name

STATIONOWNERTRK

Comment

STATIONOWNERTRK shows the tracking for the associated object STATIONOWNER. Together, STATIONOWNERTRK and 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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

EFFECTIVEDATE

PARTICIPANTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

X

Effective date of this record

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

VERSIONNO

NUMBER(3,0)

X

Version no of record within the effective date

AUTHORISEDBY

VARCHAR2(15)

 

User authorising record

AUTHORISEDDATE

DATE

 

Date record authorised

LASTCHANGED

DATE

 

Last date and time record changed