fpp__fpp_usage__1
AEMO Description
This report delivers the calculated usage for each constrain
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 417,043 |
| Combined Size | 7.55 MiB |
| MMS Table | fpp_usage |
| Unified View | nemwebviews.fpp__fpp_usage__1 |
Schema Evolution
| Column | Type | Description | 0a10709f | a0f742fe |
|---|---|---|---|---|
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) | ✓ | ✓ |
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) | ✓ | ✓ |
REGULATION_MW |
Nullable(Float64) |
Enabled regulation MW used in the FPP calculation (from FPP database) | ✓ | ✓ |
USAGE |
Nullable(Float64) |
✓ | ✓ | |
USAGE_REASON_FLAG |
Nullable(Float64) |
The reason flag showing the decision matrix for the usage calculation Supported values are: 0 = Usage is calculated based on good input data 1 = Usage is 0 as FM is unreliable 2 = Usage is 0 as the percentage of units with unavailable input or bad data is greater than the threshold percentage | ✓ | ✓ |
USAGE_VALUE |
Nullable(Float64) |
Usage (calculation of the proportion of regulation FCAS that was calculated to be used) | ✓ | - |
USED_MW |
Nullable(Float64) |
Maximum used regulation MW value (quantity of regulation FCAS that was calculated to be used in MW) | ✓ | ✓ |
VERSIONNO |
Nullable(Float64) |
Version (FPP run number from the FPP database) | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | |
source_zip |
String |
✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
0a10709f |
256,370 | 5.19 MiB |
a0f742fe |
160,673 | 2.36 MiB |
Last updated: 2025-12-10 08:00:06