Table: RESIDUE_CON_DATA

RESIDUE_CON_DATA

Name

RESIDUE_CON_DATA

Comment

RESIDUE_CON_DATA supports the Settlement Residue Auction, by holding for each participant the confidential data from the auction. RESIDUE_CON_DATA joins to RESIDUE_PUBLIC_DATA and RESIDUE_TRK.


Description

Source

RESIDUE_CON_DATA refreshes whenever a Settlement Residue Auction is run (i.e. quarterly).

RESIDUE_CON_DATA data is confidential to the relevant participant.

RESIDUE_CON_DATA excludes contracts and versions without a valid publication date (i.e invalid bids are ignored).

Volume

RESIDUE_CON_DATA shows a maximum of 6000 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(30)

X

SRA Contract unique identifier

VERSIONNO

NUMBER(3,0)

X

Contract run version

PARTICIPANTID

VARCHAR2(10)

X

Identifier of Contracted Participant

INTERCONNECTORID

VARCHAR2(10)

X

Identifier of Contracted Interconnector

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

UNITSPURCHASED

NUMBER(17,5)

 

Units purchased on the directional interconnector (i.e. Contracted quantity)

LINKPAYMENT

NUMBER(17,5)

 

Payment due (i.e. total purchase price)

LASTCHANGED

DATE

 

Last date and time record changed

SECONDARY_UNITS_SOLD

Number(18,8)

 

The number of cancelled Units for all Auction Participants.