fpp__region_freq_measure
AEMO Description
This report delivers the curated 4 second frequency deviatio
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 42,400,800 |
| Combined Size | 399.43 MiB |
| MMS Table | fpp_region_freq_measure |
| Unified View | nemwebviews.fpp__region_freq_measure |
Schema Evolution
| Column | Type | Description | 6a0301d8 | 8e854450 |
|---|---|---|---|---|
FM_ALIGNMENT_FLAG |
Nullable(Float64) |
Alignment Flag (4 second frequency deviation is aligned with 4 second frequency measure for that region) Supported values are: 0 = Misaligned 1 = Aligned | ✓ | ✓ |
FREQ_DEVIATION_HZ |
Nullable(Float64) |
Frequency Deviation (4 second frequency deviation in Hz for that region) | ✓ | ✓ |
FREQ_MEASURE_HZ |
Nullable(Float64) |
Calculated 4 second Frequency Measure for that region from FPP database | ✓ | ✓ |
HZ_QUALITY_FLAG |
Nullable(Float64) |
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) | ✓ | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
- | ✓ | |
MEASUREMENT_DATETIME |
Nullable(DateTime64(3)) |
Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) | ✓ | ✓ |
REGIONID |
LowCardinality(String) |
Region ID of the frequency deviation / frequency measure | ✓ | ✓ |
VERSIONNO |
Nullable(Float64) |
Version (FPP run number from the FPP database) | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | |
source_zip |
String |
✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
6a0301d8 |
24,305,550 | 228.86 MiB |
8e854450 |
18,095,250 | 170.57 MiB |
Last updated: 2026-10-28 14:00:05