Table: RESIDUE_CON_ESTIMATES_TRK

RESIDUE_CON_ESTIMATES_TRK

Name

RESIDUE_CON_ESTIMATES_TRK

Comment

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.


Description

Source

RESIDUE_CON_ESTIMATES_TRK updates are quarterly by SRA team.

Volume

Assuming monthly contracts, RESIDUE_CON_ESTIMATES_TRK shows a maximum of 50 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTID

CONTRACTYEAR

QUARTER

VALUATIONID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(30)

X

SRA Contract unique identifier

CONTRACTYEAR

NUMBER(4,0)

X

AEMO Contract Year number starting in week containing 1st January

QUARTER

NUMBER(1,0)

X

Contract Quarter

VALUATIONID

VARCHAR2(15)

X

Identifier of the estimator

VERSIONNO

NUMBER(3,0)

 

Version of a record, as nominated by the participant

LASTCHANGED

DATE

 

Date and time this record was changed