DEFAULTDAYOFFER (Historical table)
DEFAULTDAYOFFER shows day-based details of participants' default bids unit for the same day.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date starting at 04:30 |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit Identifier |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version No for given offer date |
| 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 stable load |
| 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 shut down in minutes |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DEFAULTDAYOFFER_LCX |
nonclustered |
LASTCHANGED |
| DEFDAYOFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DEFAULTDAYOFFER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DEFAULTDAYOFFER |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DEFAULTDAYOFFER_LCX |
nonclustered |
LASTCHANGED |
| DEFDAYOFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, DUID, VERSIONNO |