|
Name |
|
|
Comment |
REALLOCATIONS shows reallocation agreement identifiers with corresponding start and end dates of submitted reallocations as accepted by AEMO. |
|
Not in Use - discontinued 10/06/2004 Source This view is populated upon submission of a reallocation contract and accepted by AEMO. Volume Generally 3 rows are inserted by week. |
|
Name |
|
REALLOCATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Identification of the reallocation agreement |
|
STARTDATE |
DATE |
|
Starting data for the agreement |
|
STARTPERIOD |
NUMBER(3,0) |
|
Starting period number |
|
ENDDATE |
DATE |
|
Ending date for the agreement |
|
ENDPERIOD |
NUMBER(3,0) |
|
Ending period number |
|
PARTICIPANTTOID |
VARCHAR2(10) |
|
Participant who receives the money |
|
PARTICIPANTFROMID |
VARCHAR2(10) |
|
Participant who provides the money |
|
AGREEMENTTYPE |
VARCHAR2(10) |
|
Either $ or MWh |
|
DEREGISTRATIONDATE |
DATE |
|
Not used |
|
DEREGISTRATIONPERIOD |
NUMBER(3,0) |
|
Not used |
|
REGIONID |
VARCHAR2(10) |
|
Place where the RRP is taken for the agreement |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|