MNSP_FILETRK (Historical table)

MNSP_FILETRK shows all MNSPOFFERS transmitted to the MMS system.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Market Date from which bid is active
OFFERDATE	datetime(3)	datetime2(0)	The actual date and time the bid file was submitted by the participant
PARTICIPANTID	varchar(10)	varchar(10)	Participant Identifier
FILENAME	varchar(40)	varchar(40)	File name for default bids, bids, rebids, re-offers or meter files, as appropriate to table
STATUS	varchar(10)	varchar(10)	Load status [SUCCESSFUL/CORRUPT]
ACKFILENAME	varchar(40)	varchar(40)	Acknowledge file name for bids, rebids
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
MNSP_FILETRK_LCX	nonclustered	LASTCHANGED
MNSP_FILETRK_PK	clustered, unique, primary key	SETTLEMENTDATE, OFFERDATE, PARTICIPANTID, FILENAME

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_MNSP_FILETRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_MNSP_FILETRK	clustered, unique, primary key	SETTLEMENTDATE, OFFERDATE, PARTICIPANTID, FILENAME

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
MNSP_FILETRK_LCX	nonclustered	LASTCHANGED
MNSP_FILETRK_PK	clustered, unique, primary key	SETTLEMENTDATE, OFFERDATE, PARTICIPANTID, FILENAME