Package: IRAUCTION

Name

IRAUCTION

Comment

Inter-regional Residue Auction data


List of tables

Name

Comment

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: Entities: IRAuction

Table: AUCTION Table: VALUATIONID Table: RESIDUE_TRK Table: SRA_CASH_SECURITY Table: AUCTION_CALENDAR Table: RESIDUEFILETRK Table: SRA_PRUDENTIAL_RUN Table: RESIDUE_BID_TRK Table: SRA_OFFER_PROFILE Table: RESIDUE_CONTRACTS Table: RESIDUE_CON_FUNDS Table: RESIDUECONTRACTPAYMENTS Table: AUCTION_TRANCHE Table: SRA_FINANCIAL_RUNTRK Table: RESIDUE_PRICE_BID Table: SRA_OFFER_PRODUCT Table: RESIDUE_PUBLIC_DATA Table: RESIDUE_CON_DATA Table: AUCTION_REVENUE_TRACK Table: RESIDUE_FUNDS_BID Table: SRA_PRUDENTIAL_COMP_POSITION Table: SRA_FINANCIAL_AUC_MARGIN Table: SRA_FINANCIAL_AUCPAY_SUM Table: RESIDUE_CON_ESTIMATES_TRK Table: AUCTION_IC_ALLOCATIONS Table: AUCTION_RP_ESTIMATE Table: RESIDUE_PRICE_FUNDS_BID Table: SRA_PRUDENTIAL_CASH_SECURITY Table: SRA_FINANCIAL_AUC_MARDETAIL Table: SRA_PRUDENTIAL_EXPOSURE Table: AUCTION_REVENUE_ESTIMATE Table: SRA_FINANCIAL_AUC_RECEIPTS Table: SRA_FINANCIAL_AUCPAY_DETAIL
Entities: IRAuction