STATIONOWNER

STATIONOWNER sets out the owner details of each station.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
EFFECTIVEDATE	datetime(3)	date	Effective date of this record
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
STATIONID	varchar(10)	varchar(10)	Station Identifier
VERSIONNO	numeric(3, 0)	smallint	Version no of record within the effective date
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
STATIONOWNER_LCX	nonclustered	LASTCHANGED
STATIONOWNER_NDX2	nonclustered	STATIONID, EFFECTIVEDATE, VERSIONNO
STATIONOWNER_NDX3	nonclustered	PARTICIPANTID
STATIONOWNER_PK	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO, STATIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_STATIONOWNER_LASTCHANGED	nonclustered	LASTCHANGED
IX_STATIONOWNER_PARTICIPANTID	nonclustered	PARTICIPANTID
IX_STATIONOWNER_STATIONID_EFFECTIVEDATE_VERSIONNO	nonclustered	STATIONID, EFFECTIVEDATE, VERSIONNO
PK_STATIONOWNER	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO, STATIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_STATIONOWNER_STATIONID_EFFECTIVEDATE_VERSIONNO	nonclustered	STATIONID, EFFECTIVEDATE, VERSIONNO
PK_STATIONOWNER	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO, STATIONID