Table: RESIDUE_PUBLIC_DATA

RESIDUE_PUBLIC_DATA

Name

RESIDUE_PUBLIC_DATA

Comment

RESIDUE_PUBLIC_DATA shows the public auction results.
RESIDUE_PUBLIC_DATA supports the Settlement Residue Auction, by holding the public details of the auction for a given contract. RESIDUE_PUBLIC_DATA joins to RESIDUE_CON_DATA and RESIDUE.


Description

RESIDUE_PUBLIC_DATA excludes contracts and versions without a valid publication date (i.e. invalid bids are ignored).

The data is available to all auction participants post the associated auction date.

Source

RESIDUE_PUBLIC_DATA updates are quarterly from NEMMCO.

Volume

RESIDUE_PUBLIC_DATA shows a maximum of 120 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTID

FROMREGIONID

INTERCONNECTORID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(30)

X

Unique id for each contract to be specified by AEMO

VERSIONNO

NUMBER(3,0)

X

Version Number

INTERCONNECTORID

VARCHAR2(10)

X

Unique interconnector identifier

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

UNITSOFFERED

NUMBER(5,0)

 

Total units offered for auction

UNITSSOLD

NUMBER(16,6)

 

Units Sold (modified format and usage in March 2003 to support SRA Inter-Temporal Linking)

CLEARINGPRICE

NUMBER(17,5)

 

Clearing price

RESERVEPRICE

NUMBER(17,5)

 

Reserve price

LASTCHANGED

DATE

 

Date and time this record was last changed