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

 

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.


Table: OFFERASTRK

OFFERASTRK

Name

OFFERASTRK

Comment

OFFERASTRK tracks successfully acknowledged ancillary service reoffers.


Description

OFFERASTRK data is confidential to the relevant participant.

Source

OFFERASTRK is updated as offers are successfully acknowledged.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

EFFECTIVEDATE

PARTICIPANTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

X

Market day starting at 4:00 am

VERSIONNO

NUMBER(3,0)

X

Version of the offer for that date

PARTICIPANTID

VARCHAR2(10)

X

Participant ID

FILENAME

VARCHAR2(40)

 

Submitted file name.

LASTCHANGED

DATE

 

Last changed date and time.


Table: OFFERLSHEDDATA

OFFERLSHEDDATA

Name

OFFERLSHEDDATA

Comment

OFFERLSHEDDATA shows reoffers of load shed including available load shed quantity.


Description

OFFERLSHEDDATA data is confidential to the relevant participant.

Source

OFFERLSHEDDATA updates as reoffers process.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

EFFECTIVEDATE

PERIODID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract identifier

EFFECTIVEDATE

DATE

X

Market date of reoffer

VERSIONNO

NUMBER(3,0)

X

Version No of reoffer

AVAILABLELOAD

NUMBER(4,0)

 

Available load

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


Table: OFFERRESTARTDATA

OFFERRESTARTDATA

Name

OFFERRESTARTDATA

Comment

OFFERRESTARTDATA sets out reoffers of system restart availability.


Description

OFFERRESTARTDATA data is confidential to the relevant participant.

Source

OFFERRESTARTDATA updates as reoffers process.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

OFFERDATE

PERIODID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract identifier

OFFERDATE

DATE

X

Effective date of contract

VERSIONNO

NUMBER(3,0)

X

Version No of contract

AVAILABILITY

VARCHAR2(3)

 

Available load

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


Table: OFFERRPOWERDATA

OFFERRPOWERDATA

Name

OFFERRPOWERDATA

Comment

OFFERRPOWERDATA shows reoffers of reactive power capability and settlement measurements.


Description

OFFERRPOWERDATA data is confidential to the relevant participant.

Source

OFFERRPOWERDATA updates as reoffers process.


Notes

Name

Comment

Value

Visibility

 

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 Version No.

EFFECTIVEDATE

DATE

X

Contract Version No.

VERSIONNO

NUMBER(3,0)

X

Version No. of Re-Offer

PERIODID

NUMBER(3,0)

X

Market trading interval

AVAILABILITY

NUMBER(3,0)

 

Availability of service

MTA

NUMBER(6,0)

 

Reactive Power Absorption Capability (MVar)

MTG

NUMBER(6,0)

 

Reactive Power Generation Capability (MVar)

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

AUTHORISEDBY

VARCHAR2(15)

 

User Name

FILENAME

VARCHAR2(40)

 

File name of Re-Offer file

LASTCHANGED

DATE

 

Last date and time record changed