|
Name |
|
|
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. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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. |
|
|
|