Skip to content

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