Skip to content

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