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