Table: PEROFFER_D

PEROFFER_D

Name

PEROFFER_D

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).
PEROFFER_D is a child table of DAYOFFER_D.


Description

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.


Primary Key Columns

Name

DUID

OFFERDATE

PERIODID

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

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