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.