casesolution v3

pdpasa__casesolution__3

AEMO Description

The top-level table identifying a PDPASA case, reporting opt

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 19,812
Combined Size 622.52 KiB
MMS Table pdpasa_casesolution
Unified View nemwebviews.pdpasa__casesolution__3

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 Probability of Exceedance (POE) demand forecast used for capacity adequacy (LRC) assessment. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE.
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 Probability of Exceedance (POE) demand forecast used for assessment of Maximum Spare Capacity. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE
MAXSURPLUSRESERVEOPTION Nullable(Float64) Not populated as of 2005 End of Year Release; was the Probability of Exceedance (POE) demand forecast used for assessment of Maximum surplus Reserve. 0 if no assessment, 1 for 10% POE, 2 for 50% POE, 3 for 90% POE
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)) Case identifier by the time the case was run
processed_at DateTime64(3)
source_zip String

Schema Versions

Version Rows Size
a82cccde 19,812 622.52 KiB

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