Table: MNSP_BIDOFFERPERIOD

MNSP_BIDOFFERPERIOD

Name

MNSP_BIDOFFERPERIOD

Comment

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.


Primary Key Columns

Name

LINKID

OFFERDATETIME

PERIODID

TRADINGDATE


Content

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