settlements__set_fcas_regulation_trk
AEMO Description
SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constr
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 3 |
| Combined Rows | 16,899,977 |
| Combined Size | 250.39 MiB |
| MMS Table | set_fcas_regulation_trk |
| Unified View | nemwebviews.settlements__set_fcas_regulation_trk |
Schema Evolution
| Column | Type | Description | 15be61f4 | 711fb659 | ab15b95c |
|---|---|---|---|---|---|
CMPF |
Nullable(Float64) |
Constraint Market Participant Factor. This column is NULL for Settlement Dates past FPP Rule Effective Date | ✓ | ✓ | ✓ |
CONSTRAINTID |
LowCardinality(String) |
Generic Constraint ID | ✓ | ✓ | ✓ |
CRMPF |
Nullable(Float64) |
Constraint Residual Market Participant Factor. This column is NULL for Settlement Dates past FPP Rule Effective Date | ✓ | ✓ | ✓ |
DRCF |
Nullable(Float64) |
The DRCF Value from the FPP Inputs for the Constraint Id used to calculate Unused Residual Amount | ✓ | - | - |
FPP_AMOUNT |
Nullable(Float64) |
The total FPP Amount from Eligible Units for the Constraint Id | ✓ | - | - |
FPP_RESIDUAL_AMOUNT |
Nullable(Float64) |
The total FPP Residual Amount for the Constraint Id | ✓ | - | - |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
Dispatch Interval Date Time | ✓ | ✓ | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ | ✓ | ✓ |
NRCF |
Nullable(Float64) |
The NRCF Value from the FPP Inputs for the Constraint Id used to calculate Used Residual Amount | ✓ | - | - |
P_REGULATION |
Nullable(Float64) |
The PRegulation Value from Constraints FCAS Requirement data | ✓ | - | - |
RCF |
Nullable(Float64) |
The RCF Value from the FPP Inputs for the Constraint Id used to calculate FPP Residual | ✓ | - | - |
RCR |
Nullable(Float64) |
The RCR Value from the FPP Inputs for the Constraint Id used to calculate FPP Amount | ✓ | - | - |
RECOVERY_FACTOR_CMPF |
Nullable(Float64) |
Recovery factor for CMPF based recovery. This column is NULL for Settlement Dates past FPP Rule Effective Date | ✓ | ✓ | ✓ |
RECOVERY_FACTOR_CRMPF |
Nullable(Float64) |
Recovery factor for CRMPF based recovery. This column is NULL for Settlement Dates past FPP Rule Effective Date. | ✓ | ✓ | ✓ |
REQUIREMENTDEMAND |
Nullable(Float64) |
the aggregate customer demand value used to recover the cost of this requirement | ✓ | - | ✓ |
RESIDUALTOTAL_MWH |
Nullable(Float64) |
The total residual MWh(ABS(ACE_MWh) + ASOE(MWh)) of the requirement regions. | ✓ | - | - |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Settlement Date | ✓ | ✓ | ✓ |
TSFCAS |
Nullable(Float64) |
The Adjusted Cost Value from Constraints FCAS Requirement data | ✓ | - | - |
UNUSED_AMOUNT |
Nullable(Float64) |
The total Reg Unused Amount from Eligible Units for the Constraint Id | ✓ | - | - |
UNUSED_RESIDUAL_AMOUNT |
Nullable(Float64) |
The total Reg Unused Residual Amount for the Constraint Id | ✓ | - | - |
USAGE_VALUE |
Nullable(Float64) |
The Usage Value from the FPP Inputs for the Constraint Id used to calculate Used Amount | ✓ | - | - |
USED_AMOUNT |
Nullable(Float64) |
The total Reg Used Amount from Eligible Units for the Constraint Id | ✓ | - | - |
USED_RESIDUAL_AMOUNT |
Nullable(Float64) |
The total Reg Used Residual Amount for the Constraint Id | ✓ | - | - |
USESUBSTITUTEDEMAND |
Nullable(Float64) |
Flag to indication that substitute demand was used to recover this requirement | ✓ | - | ✓ |
VERSIONNO |
Nullable(Float64) |
Settlement Run No | ✓ | ✓ | ✓ |
processed_at |
DateTime64(3) |
✓ | ✓ | ✓ | |
source_zip |
String |
✓ | ✓ | ✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
15be61f4 |
1,208,980 | 37.37 MiB |
711fb659 |
7,744,700 | 63.05 MiB |
ab15b95c |
7,946,297 | 149.97 MiB |
Last updated: 2026-01-02 16:00:09