REALLOCATIONS (Historical table)
REALLOCATIONS shows reallocation agreement identifiers with corresponding start and end dates of submitted reallocations as accepted by AEMO.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| REALLOCATIONID |
varchar(20)  |
varchar(20) |
Identification of the reallocation agreement |
| STARTDATE |
datetime(3) |
datetime2(0) |
Starting data for the agreement |
| STARTPERIOD |
numeric(3, 0) |
smallint |
Starting period number |
| ENDDATE |
datetime(3) |
datetime2(0) |
Ending date for the agreement |
| ENDPERIOD |
numeric(3, 0) |
smallint |
Ending period number |
| PARTICIPANTTOID |
varchar(10) |
varchar(10) |
Participant who receives the money |
| PARTICIPANTFROMID |
varchar(10) |
varchar(10) |
Participant who provides the money |
| AGREEMENTTYPE |
varchar(10) |
varchar(10) |
Either $ or MWh |
| DEREGISTRATIONDATE |
datetime(3) |
datetime2(0) |
Not used |
| DEREGISTRATIONPERIOD |
numeric(3, 0) |
smallint |
Not used |
| REGIONID |
varchar(10) |
varchar(10) |
Place where the RRP is taken for the agreement |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| REALLOCATIONS_LCX |
nonclustered |
LASTCHANGED |
| REALLOCATIONS_PK |
clustered, unique, primary key |
REALLOCATIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_REALLOCATIONS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_REALLOCATIONS |
clustered, unique, primary key |
REALLOCATIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| REALLOCATIONS_LCX |
nonclustered |
LASTCHANGED |
| REALLOCATIONS_PK |
clustered, unique, primary key |
REALLOCATIONID |