settlements__set_fcas_regulation_trk__3
AEMO Description
SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constr
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 1,086,732 |
| Combined Size | 34.22 MiB |
| MMS Table | set_fcas_regulation_trk |
| Unified View | nemwebviews.settlements__set_fcas_regulation_trk__3 |
Schema Evolution
| Column | Type | Description | 15be61f4 |
|---|---|---|---|
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,086,732 | 34.22 MiB |
Last updated: 2025-12-10 08:00:08