OFFERFILETRK (Historical table)

OFFERFILETRK shows an audit trail of all bid files submitted containing energy bids, including corrupt bids / rebids.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
OFFERDATE	datetime(3)	datetime2(0)	Date file offered
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
FILENAME	varchar(40)	varchar(40)	Load file name
STATUS	varchar(10)	varchar(10)	Load status [SUCCESSFUL/CORRUPT]
ACKFILENAME	varchar(40)	varchar(40)	Acknowledge file name
ENDDATE	datetime(3)	datetime2(0)	Not used
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERFILETRK_LCX	nonclustered	LASTCHANGED
OFFERFILETRK_NDX2	nonclustered	PARTICIPANTID
OFFERFILETRK_PK	clustered, unique, primary key	OFFERDATE, FILENAME, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_OFFERFILETRK_LASTCHANGED	nonclustered	LASTCHANGED
IX_OFFERFILETRK_PARTICIPANTID	nonclustered	PARTICIPANTID
PK_OFFERFILETRK	clustered, unique, primary key	OFFERDATE, FILENAME, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERFILETRK_LCX	nonclustered	LASTCHANGED
OFFERFILETRK_NDX2	nonclustered	PARTICIPANTID
OFFERFILETRK_PK	clustered, unique, primary key	OFFERDATE, FILENAME, PARTICIPANTID