Name |
|
Comment |
The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process. |
Note The column REALLOCATION_TYPE can be used in conjunction with CREDITPARTICIPANT or DEBITPARTICIPANT to determine who submitted a reallocation. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Private |
Name |
REALLOCATIONID |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
REALLOCATIONID |
VARCHAR2(20) |
X |
Reallocation identifier |
CREDITPARTICIPANTID |
VARCHAR2(10) |
|
The participant to be credited for the reallocation |
DEBITPARTICIPANTID |
VARCHAR2(10) |
|
The participant to be debited for the reallocation |
REGIONID |
VARCHAR2(10) |
|
Region identifier, being the spot price reference node for this reallocation |
AGREEMENTTYPE |
VARCHAR2(10) |
|
$, (Quantity) Mwh, SWAP, CAP or FLOOR |
CREDITREFERENCE |
VARCHAR2(400) |
|
Optional reference detail for credit participant |
DEBITREFERENCE |
VARCHAR2(400) |
|
Optional reference detail for debit participant |
LASTCHANGED |
DATE |
|
Last date and time record changed |
STARTDATE |
DATE |
|
First day of the Reallocation contract |
ENDDATE |
DATE |
|
Last day of the Reallocation contract |
CURRENT_STEPID |
VARCHAR2(20) |
|
Reallocation state. One of SUBMITTED, AUTHORISED, CANCELLED. |
DAYTYPE |
VARCHAR2(20) |
|
The day type profile for which the reallocation applies over the start and end date range. Valid entries are BUSINESS, NON_BUSINESS or FLAT. |
REALLOCATION_TYPE |
VARCHAR2(1) |
|
Denotes a Credit or Debit reallocation with a value of "C" or "D" respectively |
CALENDARID |
VARCHAR2(30) |
|
Unique ID of the calendar for which data is requested |
INTERVALLENGTH |
NUMBER(3,0) |
|
The length of settlement intervals (in minutes) in the reallocation profile |
|
|
|