Table: SRA_FINANCIAL_AUCPAY_DETAIL

SRA_FINANCIAL_AUCPAY_DETAIL

Name

SRA_FINANCIAL_AUCPAY_DETAIL

Comment

Records details of the SRA financial auction payment


Primary Key Columns

Name

CONTRACTID

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

SRA_QUARTER

SRA_RUNNO

SRA_YEAR


Content

Name

Data Type

Mandatory

Comment

SRA_YEAR

NUMBER(4)

X

Year of the Tranche

SRA_QUARTER

NUMBER(3)

X

Relevant Quarter of the Tranche

SRA_RUNNO

NUMBER(3)

X

SRA Run Number

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

INTERCONNECTORID

VARCHAR2(10)

X

The identifier for the Directional Interconnector

FROMREGIONID

VARCHAR2(10)

X

The source Region identifier for the Directional Interconnector

CONTRACTID

VARCHAR2(10)

X

The SRA contract identifier

MAXIMUM_UNITS

NUMBER(18,8)

 

The Maximum Units Available for purchase in the Auction

UNITS_SOLD

NUMBER(18,8)

 

The total number of Allocated Units in the Auction, including Cancelled Units by an Auction Participant

SHORTFALL_UNITS

NUMBER(18,8)

 

The total number of units unpaid for in the auction

RESERVE_PRICE

NUMBER(18,8)

 

The reserve price of the auction

CLEARING_PRICE

NUMBER(18,8)

 

The Market Clearing Price of the Auction

PAYMENT_AMOUNT

NUMBER(18,8)

 

The payment amount owed by AEMO before shortfall

SHORTFALL_AMOUNT

NUMBER(18,8)

 

The shortfall amount

ALLOCATION

NUMBER(18,8)

 

The percentage of the auction proceeds allocated to the TNSP on the directional link

NET_PAYMENT_AMOUNT

NUMBER(18,8)

 

The payment amount owed by AEMO, including shortfall

LASTCHANGED

DATE

 

The date and time this record was last modified