Table: OFFERAGCDATA

OFFERAGCDATA

Name

OFFERAGCDATA

Comment

OFFERAGCDATA shows availability reoffers of Automatic Generation Control.


Description

OFFERAGCDATA data is confidential to the relevant participant.

Source

OFFERAGCDATA updates as reoffers submitted.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

EFFECTIVEDATE

PERIODID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

CONTRACTID


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

EFFECTIVEDATE

DATE

X

Market date of offer

VERSIONNO

NUMBER(3,0)

X

Version no of record

AVAILABILITY

NUMBER(4,0)

 

Availability flag (0 or 1)

UPPERLIMIT

NUMBER(4,0)

 

Upper control limit. This is used by SPD.

LOWERLIMIT

NUMBER(4,0)

 

Lower control limit MW. This is used by SPD.

AUTHORISEDDATE

DATE

 

Authorised date

AUTHORISEDBY

VARCHAR2(15)

 

Authorised by

FILENAME

VARCHAR2(40)

 

Name of reoffer file

LASTCHANGED

DATE

 

Last date and time record changed

PERIODID

NUMBER(3,0)

X

Market day trading interval number

AGCUP

NUMBER(3,0)

 

AGC Ramp Rate Up. This is used by SPD.

AGCDOWN

NUMBER(3,0)

 

AGC Ramp Rate Down. This is used by SPD.