IRAUCTION
Inter-regional Residue Auction data
Tables
This package contains the following tables:
| Name | Description |
|---|---|
AUCTION |
AUCTION holds auction details. AUCTION is new in March 2003 to support SRA Inter-Temporal Linking. |
AUCTION_CALENDAR |
AUCTION_CALENDAR holds the definitions of each auction quarter in a contract year. AUCTION_CALENDAR supports the Settlement Residue Auction. |
AUCTION_IC_ALLOCATIONS |
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. |
AUCTION_REVENUE_ESTIMATE |
AUCTION_REVENUE_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue for each month of a given quarter. Since reserve prices are no longer applicable from the end of 2001, zero is used as a default to avoid rewriting the system. |
AUCTION_REVENUE_TRACK |
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. |
AUCTION_RP_ESTIMATE |
AUCTION_RP_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue prices for a given quarter. Since reserve prices are no longer applicable from the end of 2001, zero is used as a default to avoid rewriting the system. |
AUCTION_TRANCHE |
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. |
RESIDUE_BID_TRK |
RESIDUE_BID_TRK supports the Settlement Residue Auction, by detailing which bid was used for which SRA Contract run. |
RESIDUE_CON_DATA |
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. |
RESIDUE_CON_ESTIMATES_TRK |
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. |
RESIDUE_CON_FUNDS |
RESIDUE_CON_FUNDS supports the Settlement Residue Auction, by holding the fund details for each contract. |
RESIDUE_CONTRACTS |
RESIDUE_CONTRACTS supports the Settlement Residue Auction, by holding the contract details for each period for which a residue contract will be offered. |
RESIDUE_FUNDS_BID |
RESIDUE_FUNDS_BID supports the Settlement Residue Auction, by showing the fund details for each SRA bid by each Participant. |
RESIDUE_PRICE_BID |
RESIDUE_PRICE_BID supports the Settlement Residue Auction, holding the unit and bid price details for each participant. |
RESIDUE_PRICE_FUNDS_BID |
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. |
RESIDUE_PUBLIC_DATA |
RESIDUE_PUBLIC_DATA shows the public auction results. RESIDUE_PUBLIC_DATA supports the Settlement Residue Auction, by holding the public details of the auction for a given contract. RESIDUE_PUBLIC_DATA joins to RESIDUE_CON_DATA and RESIDUE. |
RESIDUE_TRK |
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. |
RESIDUECONTRACTPAYMENTS |
RESIDUECONTRACTPAYMENTS shows Settlement Residue Auction payment Participant notifications. |
RESIDUEFILETRK |
RESIDUEFILETRK records all Settlement Residue Auction offers submitted by participants. |
SRA_CASH_SECURITY |
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market |
SRA_FINANCIAL_AUC_MARDETAIL |
This table stores details of the margins returned to the participants. |
SRA_FINANCIAL_AUC_MARGIN |
Records the amount of Cash Security required to be held by an Auction Participant after settlement |
SRA_FINANCIAL_AUC_RECEIPTS |
Records details of the Cancelled Units and their value for the Auction Participant |
SRA_FINANCIAL_AUCPAY_DETAIL |
Records details of the SRA financial auction payment |
SRA_FINANCIAL_AUCPAY_SUM |
Records a summary of the Auction payment amount |
SRA_FINANCIAL_RUNTRK |
Records details of the settlement process for the cancellation and purchase of SRA Auction Units |
SRA_OFFER_PRODUCT |
Holds the Product details for each Offer File submitted by each SRA Auction Participant. |
SRA_OFFER_PROFILE |
Holds the data of an SRA Auction Participant Offer Submission. |
SRA_PRUDENTIAL_CASH_SECURITY |
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market |
SRA_PRUDENTIAL_COMP_POSITION |
The prudential position of each company at the date and time of a specific prudential run |
SRA_PRUDENTIAL_EXPOSURE |
Records details of the Prudential Exposure of an SRA Auction Participant |
SRA_PRUDENTIAL_RUN |
Records the prudential run details for each prudential date |
VALUATIONID |
VALUATIONID shows the identifiers and descriptions of the valuers submitting estimates of upcoming settlement residues. VALUATIONID supports the Settlement Residue Auction. |
Diagram
