SRA Electricity Data Model tables, files, and reports
You can find the following tables, file IDs, filenames, and report names in the IRAUCTION package.
Table |
File ID |
Filename |
Report name |
Purpose |
---|---|---|---|---|
AUCTION |
AUCTION |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The Auction details |
AUCTION_CALENDAR |
AUCTION_CALENDAR |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The definitions of each auction quarter in a contract year |
AUCTION_IC_ALLOCATIONS |
AUCTION_IC_ALLOCATIONS |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The default definitions for the total number of Units and proportion applicable to each Directional Interconnector for a specified Auction Quarter |
AUCTION_REVENUE_TRACK |
AUCTION_REVENUE_ESTIMATE |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The evaluator’s estimates of revenue for each month of a given Quarter |
AUCTION_REVENUE_TRACK |
AUCTION_REVENUE_TRACK |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The tracking information for each evaluator’s estimates for a given Quarter |
AUCTION_REVENUE_TRACK |
AUCTION_RP_ESTIMATE |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The evaluator’s estimates of revenue prices for a given Quarter |
AUCTION_TRANCHE |
AUCTION_TRANCHE |
*IRAUCTION_CONFIG*.csv |
IRAUCTION_CONFIG |
The default definitions for the percentage number of Allocated Units and dates applicable to each Tranche for a specified Auction Quarter |
RESIDUE_BID_TRK |
RESIDUE_BID_TRK |
*IRAUCTION*.csv |
IRAUCTION |
The Bid used for each SRA contract run |
RESIDUE_CON_DATA |
RESIDUE_CON_DATA |
*IRAUCTION*.csv |
IRAUCTION |
The public details of the Auction for a given contract |
RESIDUE_CON_ESTIMATES_TRK |
RESIDUE_CON_ESTIMATES_TRK |
*IRAUCTION*.csv |
IRAUCTION |
The tracking details of the estimates used to generate the reserve price for each contract |
RESIDUE_CON_FUNDS |
RESIDUE_CON_FUNDS |
*IRAUCTION*.csv |
IRAUCTION |
The fund details for each contract |
RESIDUE_CONTRACTS |
RESIDUE_CONTRACTS |
*IRAUCTION*.csv |
IRAUCTION |
The contract details for each period where a residue contract is offered |
RESIDUE_FUNDS_BID |
SRA_OFFER_ACK |
*IRAUCTION_BIDS*.csv |
IRAUCTION_BIDS |
The fund details for each SRA Bid by each participant |
RESIDUE_PRICE_BID |
RESIDUE_PRICE_BID |
*IRAUCTION*.csv |
IRAUCTION |
The Unit and Bid price details for each participant |
RESIDUE_PRICE_BID |
SRA_OFFER_ACK |
*IRAUCTION_BIDS*.csv |
IRAUCTION_BIDS |
The Unit and Offer price details for each participant |
RESIDUE_PRICE_FUNDS_BID |
RESIDUE_TRK |
*IRAUCTION*.csv |
IRAUCTION |
The Bids producing the auction outcome, without exposing participant-specific details. |
RESIDUE_PUBLIC_DATA |
RESIDUE_PUBLIC_DATA |
*IRAUCTION*.csv |
IRAUCTION |
The public auction results |
RESIDUE_TRK |
RESIDUE_TRK |
*IRAUCTION*.csv |
IRAUCTION |
Tracking records for different SRA runs. |
RESIDUECONTRACTPAYMENTS |
RESIDUECONTRACTPAYMENTS |
*SETTLEMENT_CONFIG*.csv |
SETTLEMENT_CONFIG |
Participant SRA payment notifications |
RESIDUEFILETRK |
SRA_OFFER_ACK |
*IRAUCTION_BIDS*.csv |
IRAUCTION_BIDS |
Participant submitted SRA Offers |
SRA_CASH_SECURITY |
SRA_CASH_SECURITY |
*IRAUCTION*.csv |
IRAUCTION |
The Cash Security details provided by an SRA Auction Participant for collateral to cover their Trading Position in the SRA |
SRA_FINANCIAL_AUC_MARDETAIL |
SRA_FINANCIAL_RUN |
*IRAUCTION*.csv |
IRAUCTION |
Details of the margins returned to participants |
SRA_FINANCIAL_AUC_MARGIN |
SRA_FINANCIAL_RUN |
*IRAUCTION*.csv |
IRAUCTION |
The amount of Cash Security held by an SRA Auction Participant after settlement |
SRA_FINANCIAL_AUC_RECEIPTS |
SRA_FINANCIAL_RUN |
*IRAUCTION*.csv |
IRAUCTION |
Details of the Cancelled Units and their value for the SRA Auction Participant |
SRA_FINANCIAL_AUCPAY_DETAIL |
SRA_FINANCIAL_RUN |
*IRAUCTION*.csv |
IRAUCTION |
The SRA financial Auction payment |
SRA_FINANCIAL_AUCPAY_SUM |
SRA_FINANCIAL_RUN |
*IRAUCTION*.csv |
IRAUCTION |
A summary of the Auction payment amount |
SRA_FINANCIAL_RUNTRK |
SRA_FINANCIAL_RUN |
*IRAUCTION*.csv |
IRAUCTION |
Details of the Settlement process for the cancellation and purchase of SRA Auction Units |
SRA_OFFER_PRODUCT |
SRA_SEC_OFFERS |
*SRA_SEC_OFFERS*.csv |
IRAUCTION |
The product details for each Offer File submitted by each SRA Auction Participant |
SRA_OFFER_PROFILE |
SRA_SEC_OFFERS |
*SRA_SEC_OFFERS*.csv |
IRAUCTION |
The data of an SRA Auction Participant's Offer submission |
SRA_PRUDENTIAL_CASH_SECURITY |
SRA_PRUDENTIAL_RUN |
*SRA_PRUDENTIAL_RUN*.csv |
IRAUCTION |
The Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA |
SRA_PRUDENTIAL_COMP_POSITION |
SRA_PRUDENTIAL_RUN |
*SRA_PRUDENTIAL_RUN*.csv |
IRAUCTION |
The prudential position of each company at the date and time of a specific prudential run |
SRA_PRUDENTIAL_EXPOSURE |
SRA_PRUDENTIAL_RUN |
*SRA_PRUDENTIAL_RUN*.csv |
IRAUCTION |
Details of the Prudential Exposure of an SRA Auction Participant |
SRA_PRUDENTIAL_RUN |
SRA_PRUDENTIAL_RUN |
*SRA_PRUDENTIAL_RUN*.csv |
IRAUCTION |
The prudential run details for each prudential date |
VALUATIONID |
VALUATIONID |
*IRAUCTION*.csv |
IRAUCTION |
The identifiers and descriptions of the valuers submitting estimates of upcoming SRAs. |