settlements__set_fcas_regulation_trk__1
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,744,700 |
| Combined Size | 63.05 MiB |
| MMS Table | set_fcas_regulation_trk |
| Unified View | nemwebviews.settlements__set_fcas_regulation_trk__1 |
Schema Evolution
| Column | Type | Description | 711fb659 |
|---|---|---|---|
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. | ✓ |
SETTLEMENTDATE |
Nullable(DateTime64(3)) |
Settlement Date | ✓ |
VERSIONNO |
Nullable(Float64) |
Settlement Run No | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
711fb659 |
7,744,700 | 63.05 MiB |
Last updated: 2025-12-10 08:00:08