SRA_OFFER_PRODUCT
Holds the Product details for each Offer File submitted by each SRA Auction Participant.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| AUCTIONID |
varchar(30)  |
varchar(30) |
Unique ID for each Auction date |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| LOADDATE |
datetime(3) |
datetime2(0) |
The date and time the system loaded the SRA Offer File |
| OPTIONID |
numeric(4, 0) |
smallint |
Unique Product identifier (1 - 2000) |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Unique Directional Interconnector identifier |
| FROMREGIONID |
varchar(10) |
varchar(10) |
The source Region identifier for the Directional Interconnector |
| OFFER_QUANTITY |
numeric(5, 0) |
int |
The Offer quantity for this Product |
| OFFER_PRICE |
numeric(18, 8) |
numeric(18, 8) |
The Offer price for this Product |
| TRANCHEID |
varchar(30) |
varchar(30) |
Tranche identifier |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The date and time this record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_OFFER_PRODUCT_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE, OPTIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_OFFER_PRODUCT |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE, OPTIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_OFFER_PRODUCT_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE, OPTIONID |