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