Table: SRA_OFFER_PRODUCT

SRA_OFFER_PRODUCT

Name

SRA_OFFER_PRODUCT

Comment

Holds the Product details for each Offer File submitted by each SRA Auction Participant.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

AUCTIONID

LOADDATE

OPTIONID

PARTICIPANTID


Content

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