MNSP_BIDOFFERPERIOD
MNSP_BIDOFFERPERIOD shows availability for 5-minute periods for a specific Bid and LinkID for the given Trading Date and period. MNSP_BIDOFFERPERIOD is a child to MNSP_DAYOFFER and links to BIDOFFERFILETRK for 5MS Bids.
Package
BIDS
Visibility
Private, Public Next-Day
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| LINKID |
varchar(20)  |
varchar(20) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
| TRADINGDATE |
datetime(3) |
datetime2(0) |
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 planned availability MW |
| FIXEDLOAD |
numeric(8, 3) |
smallint |
Fixed unit output, in MW. A value of NULL means no fixed load so the unit is dispatched according to bid and the market. |
| RAMPUPRATE |
numeric(6, 0) |
smallint (not nullable) |
Ramp rate (MW / min) in the positive direction of flow for this MNSP link for this half-hour period |
| 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 (not nullable) |
Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours |
| 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) |
| MNSP_BIDOFFERPERIOD_PK |
clustered, unique, primary key |
TRADINGDATE, LINKID, OFFERDATETIME, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MNSP_BIDOFFERPERIOD |
clustered, unique, primary key |
TRADINGDATE, LINKID, OFFERDATETIME, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MNSP_BIDOFFERPERIOD |
clustered, unique, primary key |
TRADINGDATE, LINKID, OFFERDATETIME, PERIODID |