RESIDUE_PRICE_BID
RESIDUE_PRICE_BID supports the Settlement Residue Auction, holding the unit and bid price details for each participant.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PARTICIPANTID |
varchar(10)  |
varchar(10) |
Participant identifier |
| LOADDATE |
datetime(3) |
datetime2(0) |
Date and Time the batcher loaded the bid |
| OPTIONID |
numeric(3, 0) |
smallint |
Unique option (bid) identifier (1..800) |
| AUCTIONID |
varchar(30) |
varchar(30) |
Unique id for each auction date (new in March 2003 to support SRA Inter-Temporal Linking) |
| CONTRACTID |
varchar(30) |
varchar(30) |
Not to be used. Unique id for each SRA contract (specified by AEMO) |
| BIDPRICE |
numeric(17, 5) |
numeric(17, 5) |
Price offered for each unit |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time this record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_PRICE_BID_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_PRICE_BID_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE, OPTIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_PRICE_BID_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_PRICE_BID |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE, OPTIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_PRICE_BID_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_PRICE_BID_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE, OPTIONID |