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 |
|
|
|