REALLOCATION
The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process.
Package
SETTLEMENT_CONFIG
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| REALLOCATIONID |
varchar(20)  |
varchar(20) |
Reallocation identifier |
| CREDITPARTICIPANTID |
varchar(10) |
varchar(10) |
The participant to be credited for the reallocation |
| DEBITPARTICIPANTID |
varchar(10) |
varchar(10) |
The participant to be debited for the reallocation |
| REGIONID |
varchar(10) |
varchar(10) |
Region identifier, being the spot price reference node for this reallocation |
| AGREEMENTTYPE |
varchar(10) |
varchar(10) |
$, (Quantity) Mwh, SWAP, CAP or FLOOR |
| CREDITREFERENCE |
varchar(400) |
varchar(400) |
Optional reference detail for credit participant |
| DEBITREFERENCE |
varchar(400) |
varchar(400) |
Optional reference detail for debit participant |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| STARTDATE |
datetime(3) |
datetime2(0) |
First day of the Reallocation contract |
| ENDDATE |
datetime(3) |
datetime2(0) |
Last day of the Reallocation contract |
| CURRENT_STEPID |
varchar(20) |
varchar(20) |
Reallocation state. One of SUBMITTED, AUTHORISED, CANCELLED. |
| DAYTYPE |
varchar(20) |
varchar(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 |
varchar(1) |
varchar(1) |
Denotes a Credit or Debit reallocation with a value of \"C\" or \"D\" respectively |
| CALENDARID |
varchar(30) |
varchar(30) |
Unique ID of the calendar for which data is requested |
| INTERVALLENGTH |
numeric(3, 0) |
smallint |
The length of settlement intervals (in minutes) in the reallocation profile |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| REALLOCATION_LCX |
nonclustered |
LASTCHANGED |
| REALLOCATION_PK |
clustered, unique, primary key |
REALLOCATIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_REALLOCATION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_REALLOCATION |
clustered, unique, primary key |
REALLOCATIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| REALLOCATION_LCX |
nonclustered |
LASTCHANGED |
| REALLOCATION_PK |
clustered, unique, primary key |
REALLOCATIONID |