OFFERGOVDATA (Historical table)

OFFERGOVDATA sets out reoffers of governor (6 and 60 second FCAS) availability.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(10)	varchar(10)	Contract Version No.
EFFECTIVEDATE	datetime(3)	datetime2(0)	Effective Date of Re-Offer
VERSIONNO	numeric(3, 0)	smallint	Version No. of Re-Offer
PERIODID	numeric(3, 0)	smallint	Market day trading interval number
SEC6AVAILUP	numeric(6, 0)	smallint	Availability for 6 Second Raise (0 or 1. ''0''= unavailable, ''1'' = available)
SEC6AVAILDOWN	numeric(6, 0)	smallint	Availability for 6 Second Lower (0 or 1)
SEC60AVAILUP	numeric(6, 0)	smallint	Availability for 60 Second Raise (0 or 1)
SEC60AVAILDOWN	numeric(6, 0)	smallint	Availability for 60 Second Lower (0 or 1)
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date Contract was Authorised
AUTHORISEDBY	varchar(15)	varchar(15)	User Name
FILENAME	varchar(40)	varchar(40)	File name of Re-Offer 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)
OFFERGOVDATA_LCX	nonclustered	LASTCHANGED
OFFERGOVDATA_NDX2	nonclustered	CONTRACTID
OFFERGOVDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_OFFERGOVDATA_CONTRACTID	nonclustered	CONTRACTID
IX_OFFERGOVDATA_LASTCHANGED	nonclustered	LASTCHANGED
PK_OFFERGOVDATA	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
OFFERGOVDATA_LCX	nonclustered	LASTCHANGED
OFFERGOVDATA_NDX2	nonclustered	CONTRACTID
OFFERGOVDATA_PK	clustered, unique, primary key	CONTRACTID, EFFECTIVEDATE, VERSIONNO, PERIODID