fpp__constraint_freq_measure__1
AEMO Description
This report delivers the weighted 4 second frequency measure
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 31,277,925 |
| Combined Size | 168.46 MiB |
| MMS Table | fpp_constraint_freq_measure |
| Unified View | nemwebviews.fpp__constraint_freq_measure__1 |
Schema Evolution
| Column | Type | Description | 599bfd75 |
|---|---|---|---|
BIDTYPE |
LowCardinality(String) |
Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations) | ✓ |
CONSTRAINTID |
LowCardinality(String) |
Constraint ID (binding constraint ID from FCAS data used in FPP calculations) | ✓ |
CORRELATION_FLAG |
Nullable(Float64) |
Flag to indicate the result of the Frequency Measure correlation check between regions in the same constraint. Supported values are: 0 = Frequency measures in this constraint are not correlated (e.g. system separation between two regions) 1 = Frequency measures in this constraint are correlated | ✓ |
FM_LOWER_HZ |
Nullable(Float64) |
Calculated 4 second Frequency Measure in Hz for that constraint from the FPP database. Frequency Measure data is split across these two raise and lower columns in the following ways: >0 = Allocated to the FM_RAISE_HZ column <0 = Allocated to the FM_LOWER_HZ column 0 = To fill any gaps where the alternative column is not applicable (or no deviation from 50 Hz) | ✓ |
FM_RAISE_HZ |
Nullable(Float64) |
Calculated 4 second Frequency Measure in Hz for that constraint from the FPP database. Frequency Measure data is split across these two raise and lower columns in the following ways: >0 = Allocated to the FM_RAISE_HZ column <0 = Allocated to the FM_LOWER_HZ column 0 = To fill any gaps where the alternative column is not applicable (or no deviation from 50 Hz) | ✓ |
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) | ✓ |
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) | ✓ |
USED_IN_RCR_FLAG |
Nullable(Float64) |
Flag to indicate the result of the Frequency Measure alignment check between Mainland and Tasmania for global constraints. Supported values are: 0 = Not used in RCR calculation as the signs for the frequency measures between Mainland and Tasmania do not align 1 = Used in the RCR calculation as the signs for the frequency measures between Mainland and Tasmania do align in the case of global constraints. For non-global constraints this flag is set to 1 | ✓ |
VERSIONNO |
Nullable(Float64) |
Version (FPP run number from the FPP database) | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
599bfd75 |
31,277,925 | 168.46 MiB |
Last updated: 2025-12-10 08:00:05