TRADING_IRSR
This is a non-data model table that does not appear in the AEMO MMS schema.
It contains dispatch / trading inter-regional settlement residue data for interconnectors.
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| TRADING_INTERVAL |
- |
datetime2(0)  |
- |
| INTERCONNECTORID |
- |
varchar(10) |
- |
| FROMREGIONID |
- |
varchar(10) |
- |
| RESIDUE |
- |
numeric(15, 5) (not nullable) |
- |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_TRADING_IRSR |
clustered, unique, primary key |
TRADING_INTERVAL, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CCI_TRADING_IRSR |
clustered, columnstore |
n/a |
| PK_TRADING_IRSR |
nonclustered, unique, primary key |
TRADING_INTERVAL, INTERCONNECTORID, FROMREGIONID |