BIDOFFERPERIOD_DENSE
BIDOFFERPERIOD shows 5-minute period-based Energy and Ancillary Service bid data. BIDOFFERPERIOD is a child table of BIDDAYOFFER.
Warning
This table is a GR addition to the schema, used for processing real-time private bids. The next-day public data can be found in BIDOFFERPERIOD_SPARSE or the view BIDOFFERPERIOD.
Package
BIDS
Visibility
Private
Table schema
| Column | Official MMS Datatype | GR-MMS Datatype | Comment |
|---|---|---|---|
| DUID | varchar(20)  |
varchar(20) |
Dispatchable Unit ID |
| BIDTYPE | varchar(10) |
varchar(10) |
The type of bid, one-of ENERGY, RAISE6SEC, RAISE60SEC, RAISE5MIN, RAISEREG, LOWER6SEC, LOWER60SEC, LOWER5MIN, LOWERREG |
| TRADINGDATE | datetime(3) |
date |
The trading date this bid is for |
| OFFERDATETIME | datetime(3) |
datetime2(0) |
Time this bid was processed and loaded |
| PERIODID | numeric(3, 0) |
smallint |
Period ID 1 to 288 |
| MAXAVAIL | numeric(8, 3) | smallint (not nullable) | Maximum availability for this BidType in this period |
| FIXEDLOAD | numeric(8, 3) | smallint | Fixed unit output MW (Energy bids only) A null value means no fixed load so the unit is dispatched according to bid and market |
| RAMPUPRATE | numeric(6, 0) | smallint | MW/Min for raise (Energy bids only) |
| RAMPDOWNRATE | numeric(6, 0) | smallint | MW/Min for lower (Energy bids only) |
| ENABLEMENTMIN | numeric(8, 3) | smallint | Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
| ENABLEMENTMAX | numeric(8, 3) | smallint | Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
| LOWBREAKPOINT | numeric(8, 3) | smallint | Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
| HIGHBREAKPOINT | numeric(8, 3) | smallint | Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
| BANDAVAIL1 | numeric(8, 3) | smallint (not nullable) | Availability at price band 1 |
| BANDAVAIL2 | numeric(8, 3) | smallint (not nullable) | Availability at price band 2 |
| BANDAVAIL3 | numeric(8, 3) | smallint (not nullable) | Availability at price band 3 |
| BANDAVAIL4 | numeric(8, 3) | smallint (not nullable) | Availability at price band 4 |
| BANDAVAIL5 | numeric(8, 3) | smallint (not nullable) | Availability at price band 5 |
| BANDAVAIL6 | numeric(8, 3) | smallint (not nullable) | Availability at price band 6 |
| BANDAVAIL7 | numeric(8, 3) | smallint (not nullable) | Availability at price band 7 |
| BANDAVAIL8 | numeric(8, 3) | smallint (not nullable) | Availability at price band 8 |
| BANDAVAIL9 | numeric(8, 3) | smallint (not nullable) | Availability at price band 9 |
| BANDAVAIL10 | numeric(8, 3) | smallint (not nullable) | Availability at price band 10 |
| PASAAVAILABILITY | numeric(8, 3) | smallint | Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours |
| DIRECTION | varchar(20) |
varchar(20) |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL |
| ENERGYLIMIT | numeric(15, 5) | int | The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit |
| RECALL_PERIOD | numeric(8, 3) | numeric(8, 3) | The advance notice(in hours) that a Scheduled Resource requires to achieve the PASA Availability MW for this trading interval |
Official MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| BIDOFFERPERIOD_PK | clustered, unique, primary key | TRADINGDATE, BIDTYPE, DUID, OFFERDATETIME, DIRECTION, PERIODID |
GR-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PK_BIDOFFERPERIOD_DENSE | clustered, unique, primary key | BIDTYPE, TRADINGDATE, DUID, OFFERDATETIME, DIRECTION, PERIODID |
Historical-MMS data model indexes
| Index name | Index type | Index columns (in order) |
|---|---|---|
| PK_BIDOFFERPERIOD_DENSE | clustered, unique, primary key | TRADINGDATE, BIDTYPE, DUID, DIRECTION, OFFERDATETIME, PERIODID |