PREDISPATCH_IRSR
This is a non-data model table that does not appear in the AEMO MMS schema.
It contains forecast (P30) inter-regional settlement residue data for interconnectors.
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
- |
int  |
- |
| PERIODID |
- |
tinyint |
- |
| 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_PREDISPATCH_IRSR |
clustered, unique, primary key |
PREDISPATCHSEQNO, PERIODID, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| CCI_PREDISPATCH_IRSR |
clustered, columnstore |
n/a |
| PK_PREDISPATCH_IRSR |
nonclustered, unique, primary key |
PREDISPATCHSEQNO, PERIODID, INTERCONNECTORID, FROMREGIONID |