|
Name |
|
|
Comment |
STATIONOWNERTRK shows the tracking for the associated object STATIONOWNER. Together, STATIONOWNERTRK and STATIONOWNER sets out the owner details of each station. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|