AUCTION_CALENDAR
AUCTION_CALENDAR holds the definitions of each auction quarter in a contract year. AUCTION_CALENDAR supports the Settlement Residue Auction.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
SRA Contracted Year |
| QUARTER |
numeric(1, 0) |
tinyint |
SRA Contracted Quarter |
| STARTDATE |
datetime(3) |
datetime2(0) |
First day of SRA Contract Quarter expressed as Date |
| ENDDATE |
datetime(3) |
datetime2(0) |
Last day of SRA Contract Quarter expressed as Date |
| NOTIFYDATE |
datetime(3) |
datetime2(0) |
Default notification date |
| PAYMENTDATE |
datetime(3) |
datetime2(0) |
Date for payment by Participant |
| RECONCILIATIONDATE |
datetime(3) |
datetime2(0) |
Date of reconciliation for the quarter |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| PRELIMPURCHASESTMTDATE |
datetime(3) |
datetime2(0) |
The date the Prelim Purchase Statement is generated |
| PRELIMPROCEEDSSTMTDATE |
datetime(3) |
datetime2(0) |
The date the Prelim Proceeds Statement is generated |
| FINALPURCHASESTMTDATE |
datetime(3) |
datetime2(0) |
The date the Final Purchase Statement is generated |
| FINALPROCEEDSSTMTDATE |
datetime(3) |
datetime2(0) |
The date the Final Proceeds Statement is generated |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_CALENDAR_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_CALENDAR_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_AUCTION_CALENDAR_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_AUCTION_CALENDAR |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_CALENDAR_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_CALENDAR_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER |