MNSP_PEROFFER (Historical table)
MNSP_PEROFFER shows period by period availability and other period data pertaining to a specific bid and LinkID for the given Settlement Date. MNSP_PEROFFER is a child to MNSP_DAYOFFER and links to MNSP_OFFERTRK.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market Date from which bid is active |
| OFFERDATE |
datetime(3) |
datetime2(0) |
Offer date for bid |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version of data for other key data - a higher version for same key data will take precedence |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant Identifier |
| LINKID |
varchar(10) |
varchar(10) |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
| PERIODID |
numeric(22, 0) |
tinyint |
Trading Interval number |
| MAXAVAIL |
numeric(6, 0) |
smallint (not nullable) |
Maximum planned availability MW |
| BANDAVAIL1 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL2 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL3 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL4 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL5 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL6 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL7 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL8 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL9 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| BANDAVAIL10 |
numeric(6, 0) |
smallint (not nullable) |
Band Availability for current Period |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| FIXEDLOAD |
numeric(12, 6) |
smallint |
Inflexibility flag and availability. 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) |
| 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 |
| 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) |
| MNSP_PEROFFER_LCX |
nonclustered |
LASTCHANGED |
| MNSP_PEROFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, LINKID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MNSP_PEROFFER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MNSP_PEROFFER |
clustered, unique, primary key |
SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, LINKID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MNSP_PEROFFER_LCX |
nonclustered |
LASTCHANGED |
| MNSP_PEROFFER_PK |
clustered, unique, primary key |
SETTLEMENTDATE, OFFERDATE, VERSIONNO, PARTICIPANTID, LINKID, PERIODID |