RESIDUE_CONTRACTS
RESIDUE_CONTRACTS supports the Settlement Residue Auction, by holding the contract details for each period for which a residue contract will be offered.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
SRA Contracted Year |
| QUARTER |
numeric(1, 0) |
tinyint |
SRA Contracted Quarter |
| TRANCHE |
numeric(2, 0) |
tinyint |
Label identifying the arbitrary segmented share of the Interconnector flow |
| CONTRACTID |
varchar(30) |
varchar(30) |
Unique identifier for each SRA Contract as specified by AEMO |
| STARTDATE |
datetime(3) |
datetime2(0) |
SRA Quarter start date |
| ENDDATE |
datetime(3) |
datetime2(0) |
SRA Quarter end date |
| NOTIFYDATE |
datetime(3) |
datetime2(0) |
Open date of bidding, calculated as RNOTIFYDATE business days before the auction date |
| AUCTIONDATE |
datetime(3) |
datetime2(0) |
Close date of bidding, calculated as RAUCDATE business days before the contract start date |
| CALCMETHOD |
varchar(20) |
varchar(20) |
Identifies methodology used |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Authorisation date for this record |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
Name of authorising officer or process |
| NOTIFYPOSTDATE |
datetime(3) |
datetime2(0) |
Date notification posted |
| NOTIFYBY |
varchar(15) |
varchar(15) |
Name of notifying person |
| POSTDATE |
datetime(3) |
datetime2(0) |
Date of publishing the auction results |
| POSTEDBY |
varchar(15) |
varchar(15) |
Name of publishing officer or process |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| DESCRIPTION |
varchar(80) |
varchar(80) |
Description of Contract |
| AUCTIONID |
varchar(30) |
varchar(30) |
Unique id for each auction date (new in March 2003 to support SRA Inter-Temporal Linking) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_CONTRACTS_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_CONTRACTS_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, TRANCHE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_CONTRACTS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_CONTRACTS |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, TRANCHE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_CONTRACTS_LCX |
nonclustered |
LASTCHANGED |
| RESIDUE_CONTRACTS_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, TRANCHE |