MNSP_OFFERTRK (Historical table)

MNSP_OFFERTRK records all valid MNSPOFFERS loaded into the MMS system. The authorised date reflects the date and time of the load. MNSP_OFFERTRK is key for tracking MNSP bid submission.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	-
OFFERDATE	datetime(3)	datetime2(0)	-
VERSIONNO	numeric(3, 0)	smallint	-
PARTICIPANTID	varchar(10)	varchar(10)	-
FILENAME	varchar(40)	varchar(40)	-
AUTHORISEDDATE	datetime(3)	datetime2(0)	-
AUTHORISEDBY	varchar(15)	varchar(15)	-
LASTCHANGED	datetime(3)	datetime2(0)	-

Official MMS data model indexes

Index name	Index type	Index columns (in order)
MNSP_OFFERTRK_LCX	nonclustered	LASTCHANGED
MNSP_OFFERTRK_PK	clustered, unique, primary key	SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, FILENAME

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_MNSP_OFFERTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_MNSP_OFFERTRK	clustered, unique, primary key	SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, FILENAME

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
MNSP_OFFERTRK_LCX	nonclustered	LASTCHANGED
MNSP_OFFERTRK_PK	clustered, unique, primary key	SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, FILENAME