Name |
|
Comment |
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 shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data. Volume 192, 000 per year |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private; Public Next-Day |
Name |
LINKID |
OFFERDATE |
PARTICIPANTID |
PERIODID |
SETTLEMENTDATE |
VERSIONNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENTDATE |
DATE |
X |
Market Date from which bid is active |
OFFERDATE |
DATE |
X |
Offer date for bid |
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data will take precedence |
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
LINKID |
VARCHAR2(10) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
PERIODID |
NUMBER(22,0) |
X |
Trading Interval number |
MAXAVAIL |
NUMBER(6,0) |
|
Maximum planned availability MW |
BANDAVAIL1 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL2 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL3 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL4 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL5 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL6 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL7 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL8 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL9 |
NUMBER(6,0) |
|
Band Availability for current Period |
BANDAVAIL10 |
NUMBER(6,0) |
|
Band Availability for current Period |
LASTCHANGED |
DATE |
|
Last date and time record changed |
FIXEDLOAD |
NUMBER(12,6) |
|
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 |
NUMBER(6,0) |
|
Ramp rate (MW / min) in the positive direction of flow for this MNSP link for this half-hour period |
PASAAVAILABILITY |
NUMBER(12,0) |
|
Allows for future use for energy bids, being the physical plant capability including any capability potentially available within 24 hours |
MR_CAPACITY |
NUMBER(6,0) |
|
Mandatory Restriction Offer amount |
|
|
|