DISPATCH_AGC_DATA
THIS report delivers 4-second system data from the AEMO AGC system.
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| MEASUREMENT_DATETIME |
datetime(3)  |
datetime2(0)  |
Date and time of the SCADA data(DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone(NEM time) |
| VERSIONNO |
numeric(3, 0)  |
smallint  |
Count of version |
| AGC_AREA |
varchar(20)  |
varchar(20)  |
AGC Control Region |
| AGC_DATA_TYPE |
varchar(20)  |
varchar(20)  |
AGC parameter type |
| AGC_VALUE |
numeric(15, 5) |
numeric(15, 5) |
AGC parameter value |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCH_AGC_DATA_PK |
clustered, unique, primary key |
MEASUREMENT_DATETIME, VERSIONNO, AGC_AREA, AGC_DATA_TYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCH_AGC_DATA |
clustered, unique, primary key |
MEASUREMENT_DATETIME, VERSIONNO, AGC_AREA, AGC_DATA_TYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCH_AGC_DATA |
clustered, unique, primary key |
MEASUREMENT_DATETIME, VERSIONNO, AGC_AREA, AGC_DATA_TYPE |