Table: AUCTION_CALENDAR

AUCTION_CALENDAR

Name

AUCTION_CALENDAR

Comment

AUCTION_CALENDAR holds the definitions of each auction quarter in a contract year. AUCTION_CALENDAR supports the Settlement Residue Auction.


Description

AUCTION_CALENDAR is public data, and is available to all participants.

Source

Updates are usually quarterly by the SRA team.

Volume

AUCTION_CALENDAR shows a maximum of 16 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTYEAR

QUARTER


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

SRA Contracted Year

QUARTER

NUMBER(1,0)

X

SRA Contracted Quarter

STARTDATE

DATE

 

First day of SRA Contract Quarter expressed as Date

ENDDATE

DATE

 

Last day of SRA Contract Quarter expressed as Date

NOTIFYDATE

DATE

 

Default notification date

PAYMENTDATE

DATE

 

Date for payment by Participant

RECONCILIATIONDATE

DATE

 

Date of reconciliation for the quarter

LASTCHANGED

DATE

 

Last date and time record changed

PRELIMPURCHASESTMTDATE

DATE

 

The date the Prelim Purchase Statement is generated

PRELIMPROCEEDSSTMTDATE

DATE

 

The date the Prelim Proceeds Statement is generated

FINALPURCHASESTMTDATE

DATE

 

The date the Final Purchase Statement is generated

FINALPROCEEDSSTMTDATE

DATE

 

The date the Final Proceeds Statement is generated