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.


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

Settlements Trading Interval.

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