FPP_REGION_FREQ_MEASURE

This report delivers the curated 4 second frequency deviation and frequency measure data for each region.

Package

FPP

Public

Column	Official MMS Datatype	GR-MMS Datatype	Comment
INTERVAL_DATETIME	datetime(3)	datetime2(0)	Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)
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)
REGIONID	varchar(20)	varchar(10)	Region ID of the frequency deviation / frequency measure
VERSIONNO	numeric(5, 0)	smallint	Version (FPP run number from the FPP database)
FREQ_DEVIATION_HZ	numeric(18, 8)	numeric(18, 8)	Frequency Deviation (4 second frequency deviation in Hz for that region)
HZ_QUALITY_FLAG	numeric(5, 0)	smallint	Frequency Quality (4 second frequency deviation quality for that region) Supported values are: 0 = Bad Quality 1 = Good Quality 2 = Suspect Quality -1 = Value not used as input in the FPP calculation (generally used to indicate when SCADA data was late arriving after the FPP calculation commenced)
FREQ_MEASURE_HZ	numeric(18, 8)	numeric(18, 8)	Calculated 4 second Frequency Measure for that region from FPP database
FM_ALIGNMENT_FLAG	numeric(5, 0)	smallint	Alignment Flag (4 second frequency deviation is aligned with 4 second frequency measure for that region) Supported values are: 0 = Misaligned 1 = Aligned

Index name	Index type	Index columns (in order)
FPP_REGION_FREQ_MEASURE_PK	clustered, unique, primary key	INTERVAL_DATETIME, MEASUREMENT_DATETIME, REGIONID, VERSIONNO

Index name	Index type	Index columns (in order)
PK_FPP_REGION_FREQ_MEASURE	clustered, unique, primary key	INTERVAL_DATETIME, MEASUREMENT_DATETIME, REGIONID, VERSIONNO

Index name	Index type	Index columns (in order)
PK_FPP_REGION_FREQ_MEASURE	clustered, unique, primary key	INTERVAL_DATETIME, MEASUREMENT_DATETIME, REGIONID, VERSIONNO