RESIDUE_CON_ESTIMATES_TRK
RESIDUE_CON_ESTIMATES_TRK supports the Settlement Residue Auction, by holding the tracking details of the estimates used to generate the reserve price for each contract.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTID |
varchar(30)  |
varchar(30) |
SRA Contract unique identifier |
| CONTRACTYEAR |
numeric(4, 0) |
smallint |
AEMO Contract Year number starting in week containing 1st January |
| QUARTER |
numeric(1, 0) |
tinyint |
Contract Quarter |
| VALUATIONID |
varchar(15) |
varchar(15) |
Identifier of the estimator |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version of a record, as nominated by the participant |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time this record was changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_CON_ESTIMATES_TRK_PK |
clustered, unique, primary key |
CONTRACTID, CONTRACTYEAR, QUARTER, VALUATIONID |
| REVCONESTIMATESTRK_NDX_LCHD |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_CON_ESTIMATES_TRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_CON_ESTIMATES_TRK |
clustered, unique, primary key |
CONTRACTID, CONTRACTYEAR, QUARTER, VALUATIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_CON_ESTIMATES_TRK_PK |
clustered, unique, primary key |
CONTRACTID, CONTRACTYEAR, QUARTER, VALUATIONID |
| REVCONESTIMATESTRK_NDX_LCHD |
nonclustered |
LASTCHANGED |