OFFERUNLOADINGDATA (Historical table)

OFFERUNLOADINGDATA shows reoffers of rapid unit unloading capability.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(10)	varchar(10)	Contract identifier
EFFECTIVEDATE	datetime(3)	datetime2(0)	Market date of reoffer
VERSIONNO	numeric(3, 0)	smallint	Version No of reoffer
PERIODID	numeric(3, 0)	smallint	Market day trading interval number
AVAILABLELOAD	numeric(4, 0)	smallint	Available load
AUTHORISEDDATE	datetime(3)	datetime2(0)	Authorised date
AUTHORISEDBY	varchar(15)	varchar(15)	Authorised by
FILENAME	varchar(40)	varchar(40)	Name of reoffer file
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERUNLOADINGDATA_LCX	nonclustered	LASTCHANGED
OFFERUNLOADINGDATA_NDX2	nonclustered	CONTRACTID
OFFERUNLOADINGDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_OFFERUNLOADINGDATA_CONTRACTID	nonclustered	CONTRACTID
IX_OFFERUNLOADINGDATA_LASTCHANGED	nonclustered	LASTCHANGED
PK_OFFERUNLOADINGDATA	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERUNLOADINGDATA_LCX	nonclustered	LASTCHANGED
OFFERUNLOADINGDATA_NDX2	nonclustered	CONTRACTID
OFFERUNLOADINGDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID