Table: CONTRACTAGC

CONTRACTAGC

Name

CONTRACTAGC

Comment

CONTRACTAGC shows Automatic Generation Control (AGC) contract details for each dispatchable unit. There is a separate contract for each unit.


Description

CONTRACTAGC data is confidential to the relevant participant.

Source

CONTRACTAGC updates only where there is a contract variation.


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID

CONTRACTID


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Contract Version No

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

End date of contract

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

DUID

VARCHAR2(10)

 

Dispatchable Unit ID

CRR

NUMBER(4,0)

 

Control Range Raise 5 Min MW

CRL

NUMBER(4,0)

 

Control Range Lower 5 Min MW

RLPRICE

NUMBER(10,2)

 

Enabling Price in $

CCPRICE

NUMBER(10,2)

 

Compensation Cap in $

BS

NUMBER(10,2)

 

Block Size

AUTHORISEDBY

VARCHAR2(15)

 

User Name

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

LASTCHANGED

DATE

 

Last date and time record changed