Table: BIDDAYOFFER_D

BIDDAYOFFER_D

Name

BIDDAYOFFER_D

Comment

BIDDAYOFFER_D shows the public summary of the energy and FCAS offers applicable in the Dispatch for the
intervals identified. BIDDAYOFFER_D is the parent table to BIDPEROFFER_D.


Description

BIDDAYOFFER_D data is made public after 4am the next day.

Source

BIDDAYOFFER_D updates as ancillary service bids are processed. BIDDAYOFFER_D shows latest accepted energy and ancillary service bids.

Volume

Summary - approximately 1,000 rows per day


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BIDTYPE

DUID

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market date for which the bid applied

DUID

VARCHAR2(10)

X

Dispatchable unit identifier

BIDTYPE

VARCHAR2(10)

X

Bid Type Identifier

BIDSETTLEMENTDATE

DATE

 

Market date for which the bid was submitted.

OFFERDATE

DATE

 

Offer date and time

VERSIONNO

NUMBER(22,0)

 

Version No. for given offer date

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

DAILYENERGYCONSTRAINT

NUMBER(12,6)

 

Maximum energy available from Energy Constrained Plant. (Energy Bids Only)

REBIDEXPLANATION

VARCHAR2(500)

 

Explanation for all rebids and inflexibilities

PRICEBAND1

NUMBER(9,2)

 

Price for Availability Band 1

PRICEBAND2

NUMBER(9,2)

 

Price for Availability Band 2

PRICEBAND3

NUMBER(9,2)

 

Price for Availability Band 3

PRICEBAND4

NUMBER(9,2)

 

Price for Availability Band 4

PRICEBAND5

NUMBER(9,2)

 

Price for Availability Band 5

PRICEBAND6

NUMBER(9,2)

 

Price for Availability Band 6

PRICEBAND7

NUMBER(9,2)

 

Price for Availability Band 7

PRICEBAND8

NUMBER(9,2)

 

Price for Availability Band 8

PRICEBAND9

NUMBER(9,2)

 

Price for Availability Band 9

PRICEBAND10

NUMBER(9,2)

 

Price for Availability Band 10

MINIMUMLOAD

NUMBER(22,0)

 

Minimum MW load fast start plant

T1

NUMBER(22,0)

 

Time to synchronise in minutes (Energy Bids Only)

T2

NUMBER(22,0)

 

Time to minimum load in minutes (Energy Bids Only)

T3

NUMBER(22,0)

 

Time at minimum load in minutes (Energy Bids Only)

T4

NUMBER(22,0)

 

Time to shutdown in minutes (Energy Bids Only)

NORMALSTATUS

VARCHAR2(3)

 

ON/OFF for loads (Energy Bids Only)

LASTCHANGED

DATE

 

Last date and time record changed

MR_FACTOR

NUMBER(16,6)

 

Mandatory Restriction Scaling Factor

ENTRYTYPE

VARCHAR2(20)

 

Daily if processed before BidCutOff of previous day, otherwise REBID