settlements__set_fcas_regulation_trk__2
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 | 7,946,297 |
| Combined Size | 149.97 MiB |
| MMS Table | set_fcas_regulation_trk |
| Unified View | nemwebviews.settlements__set_fcas_regulation_trk__2 |
Schema Evolution
| Column | Type | Description | 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 | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
Dispatch Interval Date Time | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Last date and time record changed | ✓ |
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 | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Settlement Date | ✓ |
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 |
|---|---|---|
ab15b95c |
7,946,297 | 149.97 MiB |
Last updated: 2025-12-10 08:00:08