Name |
|
Comment |
MNSP_BIDOFFERPERIOD shows 5-minute availability and data about a specific bid and LinkID for the given Settlement Date and period. MNSP_BIDOFFERPERIOD is a child to MNSP_DAYOFFER and links to MNSP_OFFERTRK. |
Name |
LINKID |
OFFERDATETIME |
PERIODID |
TRADINGDATE |
Name |
Data Type |
Mandatory |
Comment |
LINKID |
VARCHAR2(20) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
TRADINGDATE |
DATE |
X |
The trading date this bid is for |
OFFERDATETIME |
TIMESTAMP(3) |
X |
Time this bid was processed and loaded |
PERIODID |
NUMBER(3,0) |
X |
Period ID, 1 to 288 |
MAXAVAIL |
NUMBER(8,3) |
|
Maximum planned availability MW |
FIXEDLOAD |
NUMBER(8,3) |
|
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 |
NUMBER(6) |
|
Ramp rate (MW / min) in the positive direction of flow for this MNSP link for this half-hour period |
BANDAVAIL1 |
NUMBER(8,3) |
|
Availability at price band 1 |
BANDAVAIL2 |
NUMBER(8,3) |
|
Availability at price band 2 |
BANDAVAIL3 |
NUMBER(8,3) |
|
Availability at price band 3 |
BANDAVAIL4 |
NUMBER(8,3) |
|
Availability at price band 4 |
BANDAVAIL5 |
NUMBER(8,3) |
|
Availability at price band 5 |
BANDAVAIL6 |
NUMBER(8,3) |
|
Availability at price band 6 |
BANDAVAIL7 |
NUMBER(8,3) |
|
Availability at price band 7 |
BANDAVAIL8 |
NUMBER(8,3) |
|
Availability at price band 8 |
BANDAVAIL9 |
NUMBER(8,3) |
|
Availability at price band 9 |
BANDAVAIL10 |
NUMBER(8,3) |
|
Availability at price band 10 |
PASAAVAILABILITY |
NUMBER(8,3) |
|
Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours |
MR_CAPACITY |
NUMBER(8,3) |
|
Mandatory Restriction Offer amount |
|
|
|