DAYOFFER_D (Historical table)
DAYOFFER_D sets out the participants' daily components of participant bid containing just the latest details (such as prices, daily energy constraint and fast start profiles). To retrieve latest bid details, read in conjunction with PEROFFER_D.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:00am |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no. for given offer date |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Offer date of data |
| SELFCOMMITFLAG |
varchar(1) |
varchar(1) |
Not used |
| DAILYENERGYCONSTRAINT |
numeric(12, 6) |
numeric(12, 6) |
Maximum energy available from Energy Constrained Plant. |
| ENTRYTYPE |
varchar(20) |
varchar(20) |
Daily or Rebid |
| CONTINGENCYPRICE |
numeric(9, 2) |
numeric(9, 2) |
Not used |
| REBIDEXPLANATION |
varchar(64) |
varchar(64) |
Explanation for all rebids and inflexibilities |
| BANDQUANTISATIONID |
numeric(2, 0) |
tinyint |
Not used |
| PRICEBAND1 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 1 |
| PRICEBAND2 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 2 |
| PRICEBAND3 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 3 |
| PRICEBAND4 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 4 |
| PRICEBAND5 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 5 |
| PRICEBAND6 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 6 |
| PRICEBAND7 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 7 |
| PRICEBAND8 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 8 |
| PRICEBAND9 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 9 |
| PRICEBAND10 |
numeric(9, 2) |
numeric(9, 2) |
Price for Availability Band 10 |
| MAXRAMPUP |
numeric(9, 2) |
numeric(9, 2) |
Not used |
| MAXRAMPDOWN |
numeric(9, 2) |
numeric(9, 2) |
Not used |
| MINIMUMLOAD |
numeric(6, 0) |
smallint |
Minimum MW load fast start plant in MW |
| T1 |
numeric(6, 0) |
smallint |
Time to synchronise in minutes |
| T2 |
numeric(6, 0) |
smallint |
Time to minimum load in minutes |
| T3 |
numeric(6, 0) |
smallint |
Time at minimum load in minutes |
| T4 |
numeric(6, 0) |
smallint |
Time to shutdown in minutes |
| NORMALSTATUS |
varchar(3) |
varchar(3) |
ON/OFF for loads |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| MR_FACTOR |
numeric(6, 0) |
smallint |
Mandatory Restriction Price Scaling Factor |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DAYOFFER_D_LCX |
nonclustered |
LASTCHANGED |
| DAYOFFER_D_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| DAYOFFER_D_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DAYOFFER_D_DUID_LASTCHANGED |
nonclustered |
DUID, LASTCHANGED |
| IX_DAYOFFER_D_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DAYOFFER_D |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DAYOFFER_D_LCX |
nonclustered |
LASTCHANGED |
| DAYOFFER_D_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| DAYOFFER_D_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, OFFERDATE, VERSIONNO |