OFFERULOADINGDATA (Historical table)

OFFERULOADINGDATA shows reoffers of rapid unit loading 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)	Effective date of contract
VERSIONNO	numeric(3, 0)	smallint	Version No of contract
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)
OFFERULOADINGDATA_LCX	nonclustered	LASTCHANGED
OFFERULOADINGDATA_NDX2	nonclustered	CONTRACTID
OFFERULOADINGDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_OFFERULOADINGDATA_CONTRACTID	nonclustered	CONTRACTID
IX_OFFERULOADINGDATA_LASTCHANGED	nonclustered	LASTCHANGED
PK_OFFERULOADINGDATA	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERULOADINGDATA_LCX	nonclustered	LASTCHANGED
OFFERULOADINGDATA_NDX2	nonclustered	CONTRACTID
OFFERULOADINGDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID