REALLOCATIONINTERVAL
30-minute or (5-minute for 5MS) data comprising a single reallocation transaction.
Package
SETTLEMENT_CONFIG
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| REALLOCATIONID |
varchar(20)  |
varchar(20) |
Reallocation identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Trading Interval |
| VALUE |
numeric(15, 5) |
numeric(15, 5) |
Reallocation value in the units of the agreement type |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| NRP |
numeric(15, 5) |
numeric(15, 5) |
Nominated Reallocation Price, only used in agreement types of SWAP, CAP and FLOOR, being the contract strike price in $/MWh |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| REALLOCATIONINTERVAL_LCX |
nonclustered |
LASTCHANGED |
| REALLOCATIONINTERVAL_PK |
clustered, unique, primary key |
REALLOCATIONID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_REALLOCATIONINTERVAL_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_REALLOCATIONINTERVAL |
clustered, unique, primary key |
REALLOCATIONID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| REALLOCATIONINTERVAL_LCX |
nonclustered |
LASTCHANGED |
| REALLOCATIONINTERVAL_PK |
clustered, unique, primary key |
REALLOCATIONID, PERIODID |