|
Name |
|
|
Comment |
BIDPEROFFER shows period-based Energy and Ancillary Service bid data. BIDPEROFFER is a child table of BIDDAYOFFER. |
|
The new ancillary service arrangements require availability and prices for each Frequency Control Ancillary Service to be bid on a similar basis to energy. Three new tables facilitate ancillary service bidding. The new tables (BIDOFFERFILETRK, BIDDAYOFFER and BIDPEROFFER) are similar in structure to energy bidding tables (OFFERFILETRK, DAYOFFER and PEROFFER). The significant differences with the new tables are: · The OFFERDATE field reflects the time the bid was loaded and this field alone provides the key for versioning of bids. The VERSIONNO field is retained for participant use as information only. · The new tables support bids for multiple services. The BIDTYPE field defines the service to which the bid applies. · There are no default bids. In the absence of a bid for a specific settlement date, the latest bid submitted for a previous settlement date applies. BIDPEROFFER data is confidential to the submitting participant until made public after 4am the next day. Source BIDPEROFFER updates as energy and ancillary service bids are processed. BIDPEROFFER includes all accepted energy and ancillary service bids. Volume Approximately 72,000,000 records per year |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
Name |
|
BIDTYPE |
|
DUID |
|
OFFERDATE |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:05 |
|
OFFERDATE |
DATE |
X |
Offer date |
|
PERIODID |
NUMBER(22,0) |
X |
Period ID |
|
VERSIONNO |
NUMBER(22,0) |
|
Version number of offer |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum availability for this BidType in this period |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Fixed unit output MW (Energy Bids Only) A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
|
ROCUP |
NUMBER(6,0) |
|
MW/min for raise (Energy Bids Only) |
|
ROCDOWN |
NUMBER(6,0) |
|
MW/Min for lower (Energy Bids Only) |
|
ENABLEMENTMIN |
NUMBER(6,0) |
|
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
|
ENABLEMENTMAX |
NUMBER(6,0) |
|
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
|
LOWBREAKPOINT |
NUMBER(6,0) |
|
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
HIGHBREAKPOINT |
NUMBER(6,0) |
|
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
BANDAVAIL1 |
NUMBER(22,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(22,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(22,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(22,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(22,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(22,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(22,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(22,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(22,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(22,0) |
|
Availability at price band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
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 |
|
|
|