Table: INTCONTRACT

INTCONTRACT

Name

INTCONTRACT

Comment

INTCONTRACT shows intervention contract details. These are specific to each intervention.


Description

INTCONTRACT became unused when Ancillary Services Review was implemented in 2001.

Confidential to participant

Source

INTCONTRACT is unused; was updated as required.


Primary Key Columns

Name

CONTRACTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Intervention Contract Identifier

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

DUID

VARCHAR2(10)

 

Dispatchable Unit ID

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

Terminate Date of contract

STARTPERIOD

NUMBER(3,0)

 

Starting period of contract

ENDPERIOD

NUMBER(3,0)

 

Terminate period of contract in trading interval

DEREGISTRATIONDATE

DATE

 

Not Used

DEREGISTRATIONPERIOD

NUMBER(3,0)

 

Not Used

LASTCHANGED

DATE

 

Last changed date/time

REGIONID

VARCHAR2(10)

 

Region Identifier