Table: BIDOFFERPERIOD

BIDOFFERPERIOD

Name

BIDOFFERPERIOD

Comment

BIDOFFERPERIOD shows 5-minute period-based Energy and Ancillary Service bid data.BIDOFFERPERIOD is a child table of BIDDAYOFFER


Primary Key Columns

Name

BIDTYPE

DUID

OFFERDATETIME

PERIODID

TRADINGDATE


Content

Name

Data Type

Mandatory

Comment

DUID

VARCHAR2(20)

X

Dispatchable Unit ID

BIDTYPE

VARCHAR2(10)

X

The type of bid, one-of ENERGY, RAISE6SEC, RAISE60SEC, RAISE5MIN, RAISEREG, LOWER6SEC, LOWER60SEC, LOWER5MIN

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 availability for this BidType in this period

FIXEDLOAD

NUMBER(8,3)

 

Fixed unit output MW (Energy bids only) A null value means no fixed load so the unit is dispatched according to bid and market

RAMPUPRATE

NUMBER(6)

 

MW/Min for lower (Energy bids only)

RAMPDOWNRATE

NUMBER(6)

 

MW/Min for lower (Energy bids only)

ENABLEMENTMIN

NUMBER(8,3)

 

Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only)

ENABLEMENTMAX

NUMBER(8,3)

 

Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only)

LOWBREAKPOINT

NUMBER(8,3)

 

Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only)

HIGHBREAKPOINT

NUMBER(8,3)

 

Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only)

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