|
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 |
|
|
|