RESIDUE_PRICE_FUNDS_BID
RESIDUE_PRICE_FUNDS_BIDshows the bids producing the auction outcome, without exposing participant-specific details. RESIDUE_PRICE_FUNDS_BID is new in March 2003 to support SRA Inter-Temporal Linking.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTID |
varchar(30)  |
varchar(30) |
Unique id for each contract specified by AEMO |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Unique interconnector identifier |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Unique region identifier |
| LINKEDBIDFLAG |
numeric(6, 0) |
int |
A unique option id, with respect to the auction, created to show which bid elements are linked. |
| AUCTIONID |
varchar(30) |
varchar(30) |
Unique id for each auction date |
| UNITS |
numeric(5, 0) |
smallint |
Quantity of units bid |
| BIDPRICE |
numeric(17, 5) |
numeric(17, 5) |
Price bid 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_FUNDS_BID_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_PRICE_FUNDS_BID_PK |
clustered, unique, primary key |
AUCTIONID, CONTRACTID, INTERCONNECTORID, FROMREGIONID, LINKEDBIDFLAG |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_PRICE_FUNDS_BID_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_PRICE_FUNDS_BID |
clustered, unique, primary key |
AUCTIONID, CONTRACTID, INTERCONNECTORID, FROMREGIONID, LINKEDBIDFLAG |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_PRICE_FUNDS_BID_PK |
clustered, unique, primary key |
AUCTIONID, CONTRACTID, INTERCONNECTORID, FROMREGIONID, LINKEDBIDFLAG |