Table: SETREALLOCATIONS

SETREALLOCATIONS

Name

SETREALLOCATIONS

Comment

SETREALLOCATIONS shows the trading interval value of reallocations processed, for those participants whose reallocation submissions have been accepted by AEMO.


Description

SETREALLOCATIONS data is confidential to participants party to the reallocation.

Source

SETREALLOCATIONS updates by the posting of a billing run.

Volume

Generally, there are approximately 550 records inserted per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

PARTICIPANTID

PERIODID

REALLOCATIONID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

RUNNO

NUMBER(3,0)

X

Settlement run no

PERIODID

NUMBER(3,0)

X

Settlement Period identifier

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

REALLOCATIONID

VARCHAR2(20)

X

Reallocation contract identifier

REALLOCATIONVALUE

NUMBER(15,5)

 

Reallocation value in $

ENERGY

NUMBER(15,5)

 

Energy in MWh if reallocation agreement type is MWh

RRP

NUMBER(15,5)

 

Regional Reference Price

LASTCHANGED

DATE

 

Last date and time record changed