Table: RESIDUE_CONTRACTS

RESIDUE_CONTRACTS

Name

RESIDUE_CONTRACTS

Comment

RESIDUE_CONTRACTS supports the Settlement Residue Auction, by holding the contract details for each period for which a residue contract will be offered.


Description

RESIDUE_CONTRACTS data is public, so is available to all participants.

Source

RESIDUE_CONTRACTS updates are quarterly by AEMO.

Volume

Assuming quarterly contracts, RESIDUE_CONTRACTS contains a maximum of 50 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTYEAR

QUARTER

TRANCHE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

SRA Contracted Year

QUARTER

NUMBER(1,0)

X

SRA Contracted Quarter

TRANCHE

NUMBER(2,0)

X

Label identifying the arbitrary segmented share of the Interconnector flow

CONTRACTID

VARCHAR2(30)

 

Unique identifier for each SRA Contract as specified by AEMO

STARTDATE

DATE

 

SRA Quarter start date

ENDDATE

DATE

 

SRA Quarter end date

NOTIFYDATE

DATE

 

Open date of bidding, calculated as RNOTIFYDATE business days before the auction date

AUCTIONDATE

DATE

 

Close date of bidding, calculated as RAUCDATE business days before the contract start date

CALCMETHOD

VARCHAR2(20)

 

Identifies methodology used

AUTHORISEDDATE

DATE

 

Authorisation date for this record

AUTHORISEDBY

VARCHAR2(15)

 

Name of authorising officer or process

NOTIFYPOSTDATE

DATE

 

Date notification posted

NOTIFYBY

VARCHAR2(15)

 

Name of notifying person

POSTDATE

DATE

 

Date of publishing the auction results

POSTEDBY

VARCHAR2(15)

 

Name of publishing officer or process

LASTCHANGED

DATE

 

Last date and time record changed

DESCRIPTION

VARCHAR2(80)

 

Description of Contract

AUCTIONID

VARCHAR2(30)

 

Unique id for each auction date (new in March 2003 to support SRA Inter-Temporal Linking)