BIDPEROFFER (Historical table)
BIDPEROFFER shows period-based Energy and Ancillary Service bid data. BIDPEROFFER is a child table of BIDDAYOFFER.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| DUID |
varchar(10)  |
varchar(10) |
Dispatchable Unit identifier |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid Type Identifier |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Market date starting at 04:05 |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Offer date |
| PERIODID |
numeric(22, 0) |
tinyint |
Period ID |
| VERSIONNO |
numeric(22, 0) |
smallint (not nullable) |
Version number of offer |
| MAXAVAIL |
numeric(12, 6) |
smallint (not nullable) |
Maximum availability for this BidType in this period |
| FIXEDLOAD |
numeric(12, 6) |
smallint |
Fixed unit output MW (Energy Bids Only) 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 |
MW/min for raise (Energy Bids Only) |
| ROCDOWN |
numeric(6, 0) |
smallint |
MW/Min for lower (Energy Bids Only) |
| ENABLEMENTMIN |
numeric(6, 0) |
smallint |
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
| ENABLEMENTMAX |
numeric(6, 0) |
smallint |
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
| LOWBREAKPOINT |
numeric(6, 0) |
smallint |
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
| HIGHBREAKPOINT |
numeric(6, 0) |
smallint |
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
| BANDAVAIL1 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 1 |
| BANDAVAIL2 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 2 |
| BANDAVAIL3 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 3 |
| BANDAVAIL4 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 4 |
| BANDAVAIL5 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 5 |
| BANDAVAIL6 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 6 |
| BANDAVAIL7 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 7 |
| BANDAVAIL8 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 8 |
| BANDAVAIL9 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 9 |
| BANDAVAIL10 |
numeric(22, 0) |
smallint (not nullable) |
Availability at price band 10 |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
| PASAAVAILABILITY |
numeric(12, 0) |
smallint |
Allows for future use for energy bids, being the physical plant capability including any capability potentially available within 24 hours |
| MR_CAPACITY |
numeric(6, 0) |
smallint |
Mandatory Restriction Offer amount |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| BIDPEROFFER_LCHD_IDX |
nonclustered |
LASTCHANGED |
| BIDPEROFFER_PK |
clustered, unique, primary key |
DUID, BIDTYPE, SETTLEMENTDATE, OFFERDATE, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_BIDPEROFFER |
clustered, unique, primary key |
BIDTYPE, SETTLEMENTDATE, DUID, OFFERDATE, PERIODID |