|
Name |
|
|
Comment |
SETREALLOCATIONS shows the trading interval value of reallocations processed, for those participants whose reallocation submissions have been accepted by AEMO. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REALLOCATIONID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|