dispatch__casesolution
AEMO Description
DISPATCHCASESOLUTION shows information relating to the compl
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 2 |
| Combined Rows | 188,430 |
| Combined Size | 2.63 MiB |
| MMS Table | dispatchcasesolution |
| Unified View | nemwebviews.dispatch__casesolution |
Schema Evolution
| Column | Type | Description | 69633016 | c17839f5 |
|---|---|---|---|---|
CASESUBTYPE |
String |
Overconstrained dispatch indicator: | ✓ | - |
CASESUBTYPE |
Nullable(Float64) |
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 |
186,284 | 2.60 MiB |
c17839f5 |
2,146 | 27.19 KiB |
Last updated: 2026-07-16 05:00:07