|
Name |
|
|
Comment |
Inter-regional Residue Auction data |
|
Name |
Comment |
Visibility |
|
AUCTION holds auction details. AUCTION is new in March 2003 to support SRA Inter-Temporal Linking. |
Public |
|
|
AUCTION_CALENDAR holds the definitions of each auction quarter in a contract year. AUCTION_CALENDAR supports the Settlement Residue Auction. |
Public |
|
|
AUCTION_IC_ALLOCATIONS supports the Settlement Residue Auction by providing the basis for setting up contracts for individual tranches. AUCTION_IC_ALLOCATIONS shows the default definitions for the total number of units and proportion applicable to each directional interconnector for a specified auction quarter. |
Public |
|
|
AUCTION_REVENUE_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue for each month of a given quarter. |
Public |
|
|
AUCTION_REVENUE_TRACK supports the Settlement Residue Auction, by holding the tracking information for each evaluator’s estimates for a given quarter. The status field is dynamic and is used for selection of estimates to be published. |
Public |
|
|
AUCTION_RP_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue prices for a given quarter. |
Public |
|
|
AUCTION_TRANCHE supports the Settlement Residue Auction, by holding the default definitions for the percentage number of units allocated and dates applicable to each tranche for a specified auction quarter. This information provides the basis for setting up contracts for individual tranches. |
Public |
|
|
RESIDUE_BID_TRK supports the Settlement Residue Auction, by detailing which bid was used for which SRA Contract run. |
Private |
|
|
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. |
Private |
|
|
RESIDUE_CON_ESTIMATES_TRK supports the Settlement Residue Auction, by holding the tracking details of the estimates used to generate the reserve price for each contract. |
Public |
|
|
RESIDUE_CON_FUNDS supports the Settlement Residue Auction, by holding the fund details for each contract. |
Public |
|
|
RESIDUE_CONTRACTS supports the Settlement Residue Auction, by holding the contract details for each period for which a residue contract will be offered. |
Public |
|
|
RESIDUE_FUNDS_BID supports the Settlement Residue Auction, by showing the fund details for each SRA bid by each Participant. |
Private |
|
|
RESIDUE_PRICE_BID supports the Settlement Residue Auction, holding the unit and bid price details for each participant. |
Private |
|
|
RESIDUE_PRICE_FUNDS_BIDshows the bids producing the auction outcome, without exposing participant-specific details. RESIDUE_PRICE_FUNDS_BID is new in March 2003 to support SRA Inter-Temporal Linking. |
Public |
|
|
RESIDUE_PUBLIC_DATA shows the public auction results. |
Public |
|
|
RESIDUE_TRK supports the Settlement Residue Auction, by showing the tracking records for different residue auction runs. RESIDUE_TRK joins to RESIDUE_PUBLIC_DATA and RESIDUE_CON_DATA. |
Public |
|
|
RESIDUECONTRACTPAYMENTS shows Settlement Residue Auction payment Participant notifications. |
Private |
|
|
RESIDUEFILETRK records all Settlement Residue Auction offers submitted by participants. |
Private |
|
|
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market |
Private |
|
|
This table stores details of the margins returned to the participants. |
Private |
|
|
Records the amount of Cash Security required to be held by an Auction Participant after settlement |
Private |
|
|
Records details of the Cancelled Units and their value for the Auction Participant |
Private |
|
|
Records details of the SRA financial auction payment |
Private |
|
|
Records a summary of the Auction payment amount |
Private |
|
|
Records details of the settlement process for the cancellation and purchase of SRA Auction Units |
Public |
|
|
Holds the Product details for each Offer File submitted by each SRA Auction Participant. |
Private |
|
|
Holds the data of an SRA Auction Participant Offer Submission. |
Private |
|
|
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market |
Private |
|
|
The prudential position of each company at the date and time of a specific prudential run |
Private |
|
|
Records details of the Prudential Exposure of an SRA Auction Participant |
Private |
|
|
Records the prudential run details for each prudential date |
Public |
|
|
VALUATIONID shows the identifiers and descriptions of the valuers submitting estimates of upcoming settlement residues. VALUATIONID supports the Settlement Residue Auction. |
Public |
|
|
|
|