DEFAULTPEROFFER (Historical table)
DEFAULTPEROFFER shows half hourly period-based data in the default bid for each Dispatchable Unit, such as period availability, rate of change and band quantities.
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 |
| PERIODID |
numeric(3, 0) |
smallint |
Market data. Trading Interval number |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of the offer file. |
| SELFDISPATCH |
numeric(9, 6) |
numeric(9, 6) |
Not used |
| MAXAVAIL |
numeric(12, 6) |
numeric(12, 6) |
Maximum planned availability MW |
| FIXEDLOAD |
numeric(9, 6) |
numeric(9, 6) |
Fixed unit output MW. A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
| ROCUP |
numeric(6, 0) |
smallint |
Rate of change up MW/min |
| ROCDOWN |
numeric(6, 0) |
smallint |
Rate of change down MW/min |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| BANDAVAIL1 |
numeric(6, 0) |
smallint |
Availability at price band 1 |
| BANDAVAIL2 |
numeric(6, 0) |
smallint |
Availability at price band 2 |
| BANDAVAIL3 |
numeric(6, 0) |
smallint |
Availability at price band 3 |
| BANDAVAIL4 |
numeric(6, 0) |
smallint |
Availability at price band 4 |
| BANDAVAIL5 |
numeric(6, 0) |
smallint |
Availability at price band 5 |
| BANDAVAIL6 |
numeric(6, 0) |
smallint |
Availability at price band 6 |
| BANDAVAIL7 |
numeric(6, 0) |
smallint |
Availability at price band 7 |
| BANDAVAIL8 |
numeric(6, 0) |
smallint |
Availability at price band 8 |
| BANDAVAIL9 |
numeric(6, 0) |
smallint |
Availability at price band 9 |
| BANDAVAIL10 |
numeric(6, 0) |
smallint |
Availability at price band 10 |
| PASAAVAILABILITY |
numeric(12, 0) |
smallint |
The physical plant capability including any capability potentially available within 24 hours. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DEFAULTPEROFFER_LCX |
nonclustered |
LASTCHANGED |
| DEFPEROFFER_PK |
clustered, unique, primary key |
DUID, SETTLEMENTDATE, VERSIONNO, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DEFAULTPEROFFER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DEFAULTPEROFFER |
clustered, unique, primary key |
DUID, SETTLEMENTDATE, VERSIONNO, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DEFAULTPEROFFER_LCX |
nonclustered |
LASTCHANGED |
| DEFPEROFFER_PK |
clustered, unique, primary key |
DUID, SETTLEMENTDATE, VERSIONNO, PERIODID |