|
Name |
|
|
Comment |
PEROFFER_D contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER_D. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). |
|
Not in Use - discontinued 16/11/2003 Status PEROFFER and its related views are obsolete. please see BIDPEROFFER views. For a transition period, the PEROFFER views exist, being based on the BIDPEROFFER table. Source PEROFFER is obsolete; confidential data was updated for each bid and rebid, with full visibility of rest of market were updated daily as part of next day data. |
|
Name |
|
DUID |
|
OFFERDATE |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:00am |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
OFFERDATE |
DATE |
X |
Offer date made |
|
PERIODID |
NUMBER(3,0) |
X |
Period identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of offer |
|
SELFDISPATCH |
NUMBER(12,6) |
|
Not used |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum plant availability |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Fixed unit output MW. 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 |
|
ROCDOWN |
NUMBER(6,0) |
|
MW/Min for lower |
|
BANDAVAIL1 |
NUMBER(6,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(6,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(6,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(6,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(6,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(6,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(6,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(6,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(6,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(6,0) |
|
Availability at price band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
The physical plant capability including any capability potentially available within 24 hours. |
|
MR_CAPACITY |
NUMBER(6,0) |
|
Mandatory Restriction Offer amount |
|
|
|