predispatch__fcas_req_constraint__1
AEMO Description
The constraint level FCAS cost / price details for constrain
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 512,489,928 |
| Combined Size | 2.32 GiB |
| MMS Table | dispatch_fcas_req_constraint |
| Unified View | nemwebviews.predispatch__fcas_req_constraint__1 |
Schema Evolution
| Column | Type | Description | e42950d3 |
|---|---|---|---|
ADJUSTED_COST |
Nullable(Float64) |
The adjusted cost of the constraint for this service, after the regulation/contingency split | ✓ |
BASE_COST |
Nullable(Float64) |
The base cost of the constraint, before the regulation/contingency split | ✓ |
BIDTYPE |
LowCardinality(String) |
DUID offered type | ✓ |
CONSTRAINTID |
LowCardinality(String) |
ConstraintID join to table GenConData | ✓ |
CONSTRAINT_ENABLEMENT |
Nullable(Float64) |
MW enabled for this bid type within the constraint | ✓ |
INTERVAL_DATETIME |
Nullable(DateTime64(3)) |
The trading interval date and time of the dispatch interval that was processed by the constraint FCAS processor | ✓ |
LHS |
Nullable(Float64) |
Constraints summed LHS - aggregate LHS Solution values from the physical run from the DISPATCHCONSTRAINT table | ✓ |
MARGINALVALUE |
Nullable(Float64) |
Shadow price of constraint from the DISPATCHCONSTRAINT table from the physical run. | ✓ |
PREDISPATCHSEQNO |
Nullable(Float64) |
✓ | |
P_REGULATION |
Nullable(Float64) |
The adjusted marginal value of the constraint for FPP recovery (blank for constraints without REG terms) | ✓ |
REGIONAL_ENABLEMENT |
Nullable(Float64) |
The dispatched MW for the bid type inside the region from the physical run of the DISPATCHREGIONSUM table | ✓ |
REGIONID |
LowCardinality(String) |
Region identifier | ✓ |
REGION_BASE_COST |
Nullable(Float64) |
The regional payment allocated to the constraint for the interval pro-rated based on marginal value ratios over the binding constraints for that service in that region (this is an intermediate calculation to get to the base cost) | ✓ |
RHS |
Nullable(Float64) |
Constraints RHS value used in the solution - may be either dynamic (calculated) or static from the physical run from the DISPATCHCONSTRAINT table | ✓ |
RRP |
Nullable(Float64) |
Bid type prices for the region coming from the pricing run of the DISPATCHREGIONSUM table | ✓ |
RUNNO |
Nullable(Float64) |
The dispatch case run number that has triggers the constraint FCAS processor run | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
The run date and time of the dispatch case that triggers the constraint FCAS processor run | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
e42950d3 |
512,489,928 | 2.32 GiB |
Last updated: 2025-12-10 08:00:07