casesolution v1

dispatch__casesolution__1

AEMO Description

DISPATCHCASESOLUTION shows information relating to the compl

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 125,446
Combined Size 2.00 MiB
MMS Table dispatchcasesolution
Unified View nemwebviews.dispatch__casesolution__1

Schema Evolution

Column Type Description 69633016
CASESUBTYPE String Overconstrained dispatch indicator: ✓
INTERVENTION Nullable(Float64) Intervention flag - refer to package documentation for definition and practical query examples ✓
LASTCHANGED Nullable(DateTime64(3)) Last date and time record changed ✓
NONPHYSICALLOSSES Nullable(Float64) Non-Physical Losses algorithm invoked occurred during this run ✓
RUNNO Nullable(Float64) Dispatch run no; always 1 ✓
SETTLEMENTDATE Nullable(DateTime64(3)) Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35) ✓
SOLUTIONSTATUS Nullable(Float64) If non-zero indicated one of the following conditions: ✓
SPDVERSION Nullable(Float64) Current version of SPD ✓
TOTAL5MINVIOLATION Nullable(Float64) Total of 5 minute ancillary service region violations ✓
TOTAL60SECVIOLATION Nullable(Float64) Total of 60 second ancillary service region violations ✓
TOTAL6SECVIOLATION Nullable(Float64) Total of 6 second ancillary service region violations ✓
TOTALAREAGENVIOLATION Nullable(Float64) Total Region Demand violations ✓
TOTALASPROFILEVIOLATION Nullable(Float64) Total of ancillary service trader profile violations ✓
TOTALENERGYOFFERVIOLATION Nullable(Float64) Total of unit summated offer band violations ✓
TOTALFASTSTARTVIOLATION Nullable(Float64) Total of fast start trader profile violations ✓
TOTALGENERICVIOLATION Nullable(Float64) Total generic constraint violations ✓
TOTALINTERCONNECTORVIOLATION Nullable(Float64) Total interconnector violations ✓
TOTALOBJECTIVE Nullable(Float64) The Objective function from the LP ✓
TOTALRAMPRATEVIOLATION Nullable(Float64) Total ramp rate violations ✓
TOTALREGVIOLATION Nullable(Float64) Total of Regulation ancillary service region violations ✓
TOTALUNITMWCAPACITYVIOLATION Nullable(Float64) Total unit capacity violations ✓
processed_at DateTime64(3) ✓
source_zip String ✓

Schema Versions

Version Rows Size
69633016 125,446 2.00 MiB

Last updated: 2025-12-10 08:00:04