Name |
|
Comment |
Holds the Product details for each Offer File submitted by each SRA Auction Participant. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private |
Name |
AUCTIONID |
LOADDATE |
OPTIONID |
PARTICIPANTID |
Name |
Data Type |
Mandatory |
Comment |
AUCTIONID |
VARCHAR2(30) |
X |
Unique ID for each Auction date |
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
LOADDATE |
DATE |
X |
The date and time the system loaded the SRA Offer File |
OPTIONID |
NUMBER(4) |
X |
Unique Product identifier (1 - 2000) |
INTERCONNECTORID |
VARCHAR2(10) |
|
Unique Directional Interconnector identifier |
FROMREGIONID |
VARCHAR2(10) |
|
The source Region identifier for the Directional Interconnector |
OFFER_QUANTITY |
NUMBER(5) |
|
The Offer quantity for this Product |
OFFER_PRICE |
NUMBER(18,8) |
|
The Offer price for this Product |
TRANCHEID |
VARCHAR2(30) |
|
Tranche identifier |
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
|
|