SRA_OFFER_PROFILE
Holds the data of an SRA Auction Participant Offer Submission.
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 |
| FILENAME |
varchar(40) |
varchar(40) |
SRA Offer File name |
| ACKFILENAME |
varchar(40) |
varchar(40) |
SRA acknowledgment file name |
| TRANSACTIONID |
varchar(100) |
varchar(100) |
Transaction ID used for tracking |
| 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_PROFILE_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_OFFER_PROFILE |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_OFFER_PROFILE_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE |