Table: REALLOCATION

REALLOCATION

Name

REALLOCATION

Comment

The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process.


Description

Note

The column REALLOCATION_TYPE can be used in conjunction with CREDITPARTICIPANT or DEBITPARTICIPANT to determine who submitted a reallocation.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

REALLOCATIONID


Index Columns

Name

LASTCHANGED


Content

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