stpasa__casesolution
AEMO Description
STPASA_CASESOLUTION holds one record containing results pert
Note that the provided table descriptions are truncated by AEMO.
| Total Schema Versions | 1 |
| Combined Rows | 15,686 |
| Combined Size | 510.81 KiB |
| MMS Table | stpasa_casesolution |
| Unified View | nemwebviews.stpasa__casesolution |
Schema Evolution
| Column | Type | Description | a82cccde |
|---|---|---|---|
CAPACITYOBJFUNCTION |
Nullable(Float64) |
Objective Function from the Capacity Adequacy run | ✓ |
CAPACITYOPTION |
Nullable(Float64) |
Not populated as of 2005 End of Year Release; was the demand forecast used for capacity adequacy assessment. 0 if no assessment, 1 for 10%, 2 for 50%, 3 for 90% | ✓ |
INTERCONNECTORFLOWPENALTY |
Nullable(Float64) |
The penalty for non-zero interconnector flow | ✓ |
LASTCHANGED |
Nullable(DateTime64(3)) |
Date and time the record was created or modified | ✓ |
LORCAPACITYOPTION |
LowCardinality(String) |
Generation Availability to be used in LOR run (either PASA or MARKET) | ✓ |
LORCONDITION |
Nullable(Float64) |
Lack of Reserve Condition (LOR) flag for the case indicates the most severe condition in the case (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR) | ✓ |
LORDEMANDOPTION |
Nullable(Float64) |
Specifies the Probability of Exceedence (POE) demand forecast for LOR assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) | ✓ |
LORUIGFOPTION |
Nullable(Float64) |
UIGF POE forecast availability used for this option | ✓ |
MAXSPARECAPACITYOPTION |
Nullable(Float64) |
Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum Spare Capacity. 0 if no assessment, 1 for 10%, 2 for 50%, 3 for 90% | ✓ |
MAXSURPLUSRESERVEOPTION |
Nullable(Float64) |
Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum surplus Reserve. 0 if no assessment, 1 for 10%, 2 for 50%, 3 for 90% | ✓ |
OUTAGELRCCAPACITYOPTION |
LowCardinality(String) |
Generation Availability to be used in Outage LRC run (either PASA or MARKET) | ✓ |
OUTAGELRCDEMANDOPTION |
Nullable(Float64) |
Specifies the Probability of Exceedence (POE) demand forecast for outage LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) | ✓ |
OUTAGELRCUIGFOPTION |
Nullable(Float64) |
UIGF POE forecast availability used for this option | ✓ |
PASAVERSION |
LowCardinality(String) |
Version of the PASA solver used to solve this case | ✓ |
RELIABILITYLRCCAPACITYOPTION |
LowCardinality(String) |
Generation Availability to be used in Reliability LRC run (either PASA or MARKET) | ✓ |
RELIABILITYLRCDEMANDOPTION |
Nullable(Float64) |
Specifies the Probability of Exceedence (POE) demand forecast for Reliability LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) | ✓ |
RELIABILITYLRCUIGFOPTION |
Nullable(Float64) |
UIGF POE forecast availability used for this option | ✓ |
RESERVECONDITION |
Nullable(Float64) |
Low Reserve Condition (LRC) flag for the case (1 - LRC in the case, 0 - No LRCs in the case) for capacity run | ✓ |
RUN_DATETIME |
Nullable(DateTime64(3)) |
Unique Timestamp Identifier for this study | ✓ |
processed_at |
DateTime64(3) |
✓ | |
source_zip |
String |
✓ |
Schema Versions
| Version | Rows | Size |
|---|---|---|
a82cccde |
15,686 | 510.81 KiB |
Last updated: 2026-07-16 05:00:10