constraintsolution v3

stpasa__constraintsolution__3

AEMO Description

STPASA_CONSTRAINTSOLUTION shows binding and violated constra

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 190,037,728
Combined Size 633.00 MiB
MMS Table stpasa_constraintsolution
Unified View nemwebviews.stpasa__constraintsolution__3

Schema Evolution

Column Type Description 324e7aac
CAPACITYMARGINALVALUE Nullable(Float64) Capacity adequacy assessment marginal value, 0 if not binding
CAPACITYRHS Nullable(Float64) The RHS value in the capacity evaluation.
CAPACITYVIOLATIONDEGREE Nullable(Float64) Capacity adequacy assessment violation degree for generic constraint; 0 if not violating
CONSTRAINTID LowCardinality(String) Constraint identifier (synonymous with GenConID)
INTERVAL_DATETIME Nullable(DateTime64(3)) The unique identifier for the interval within this study
LASTCHANGED Nullable(DateTime64(3)) Last changed date of this record
RUNTYPE LowCardinality(String) Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR.
RUN_DATETIME Nullable(DateTime64(3)) Unique Timestamp Identifier for this study
STUDYREGIONID LowCardinality(String) Primary Region for LP Solve (or MARKET if none).
processed_at DateTime64(3)
source_zip String

Schema Versions

Version Rows Size
324e7aac 190,037,728 633.00 MiB

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