Table: DAYOFFER_D

DAYOFFER_D

Name

DAYOFFER_D

Comment

DAYOFFER_D sets out the participants’ daily components of participant bid containing just the latest details (such as prices, daily energy constraint and fast start profiles).
To retrieve latest bid details, read in conjunction with PEROFFER_D.


Description

Not in Use - discontinued 16/11/2003

DAYOFFER data was confidential to the submitting participant until made public after 4am the next day.

The table DAYOFFER is quite distinct, with same field names (see DAYOFFER).


Primary Key Columns

Name

DUID

OFFERDATE

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

DUID

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market date starting at 04:00am

DUID

VARCHAR2(10)

X

Dispatchable unit identifier

VERSIONNO

NUMBER(3,0)

X

Version no. for given offer date

OFFERDATE

DATE

X

Offer date of data

SELFCOMMITFLAG

VARCHAR2(1)

 

Not used

DAILYENERGYCONSTRAINT

NUMBER(12,6)

 

Maximum energy available from Energy Constrained Plant.

ENTRYTYPE

VARCHAR2(20)

 

Daily or Rebid

CONTINGENCYPRICE

NUMBER(9,2)

 

Not used

REBIDEXPLANATION

VARCHAR2(64)

 

Explanation for all rebids and inflexibilities

BANDQUANTISATIONID

NUMBER(2,0)

 

Not used

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

MAXRAMPUP

NUMBER(9,2)

 

Not used

MAXRAMPDOWN

NUMBER(9,2)

 

Not used

MINIMUMLOAD

NUMBER(6,0)

 

Minimum MW load fast start plant in MW

T1

NUMBER(6,0)

 

Time to synchronise in minutes

T2

NUMBER(6,0)

 

Time to minimum load in minutes

T3

NUMBER(6,0)

 

Time at minimum load in minutes

T4

NUMBER(6,0)

 

Time to shutdown in minutes

NORMALSTATUS

VARCHAR2(3)

 

ON/OFF for loads

LASTCHANGED

DATE

 

Last date and time record changed

MR_FACTOR

NUMBER(6,0)

 

Mandatory Restriction Price Scaling Factor