Table: MNSP_PEROFFER

MNSP_PEROFFER

Name

MNSP_PEROFFER

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 is a child to MNSP_DAYOFFER and links to MNSP_OFFERTRK.


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private; Public Next-Day


Primary Key Columns

Name

LINKID

OFFERDATE

PARTICIPANTID

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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