dispatch__unit_solution

AEMO Description

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	2
Combined Rows	67,416,192
Combined Size	871.16 MiB
Unified View	`nemwebviews.dispatch__unit_solution`

Schema Evolution

Column	Type	479f84c5	d203d640
`AGCSTATUS`	`Nullable(Float64)`	✓	✓
`AVAILABILITY`	`Nullable(Float64)`	✓	✓
`CONFORMANCE_MODE`	`Nullable(Float64)`	✓	✓
`CONNECTIONPOINTID`	`LowCardinality(String)`	✓	✓
`DISPATCHINTERVAL`	`Nullable(Float64)`	✓	✓
`DISPATCHMODE`	`Nullable(Float64)`	✓	✓
`DISPATCHMODETIME`	`Nullable(Float64)`	✓	✓
`DOWNEPF`	`Nullable(Float64)`	✓	✓
`DUID`	`LowCardinality(String)`	✓	✓
`ELEMENT_CAP`	`Nullable(Float64)`	-	✓
`ENERGY_STORAGE`	`Nullable(Float64)`	✓	✓
`INITIALMW`	`Nullable(Float64)`	✓	✓
`INITIAL_ENERGY_STORAGE`	`Nullable(Float64)`	✓	✓
`INTERVENTION`	`Nullable(Float64)`	✓	✓
`LASTCHANGED`	`Nullable(DateTime64(3))`	✓	✓
`LOWER1SEC`	`Nullable(Float64)`	✓	✓
`LOWER1SECACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`LOWER1SECFLAGS`	`Nullable(Float64)`	✓	✓
`LOWER5MIN`	`Nullable(Float64)`	✓	✓
`LOWER5MINACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`LOWER5MINFLAGS`	`Nullable(Float64)`	✓	✓
`LOWER60SEC`	`Nullable(Float64)`	✓	✓
`LOWER60SECACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`LOWER60SECFLAGS`	`Nullable(Float64)`	✓	✓
`LOWER6SEC`	`Nullable(Float64)`	✓	✓
`LOWER6SECACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`LOWER6SECFLAGS`	`Nullable(Float64)`	✓	✓
`LOWERREG`	`Nullable(Float64)`	✓	✓
`LOWERREGACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`LOWERREGAVAILABILITY`	`Nullable(Float64)`	✓	✓
`LOWERREGENABLEMENTMAX`	`Nullable(Float64)`	✓	✓
`LOWERREGENABLEMENTMIN`	`Nullable(Float64)`	✓	✓
`LOWERREGFLAGS`	`Nullable(Float64)`	✓	✓
`MARGINAL5MINVALUE`	`Nullable(Float64)`	✓	✓
`MARGINAL60SECVALUE`	`Nullable(Float64)`	✓	✓
`MARGINAL6SECVALUE`	`Nullable(Float64)`	✓	✓
`MARGINALVALUE`	`Nullable(Float64)`	✓	✓
`MIN_AVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISE1SEC`	`Nullable(Float64)`	✓	✓
`RAISE1SECACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISE1SECFLAGS`	`Nullable(Float64)`	✓	✓
`RAISE5MIN`	`Nullable(Float64)`	✓	✓
`RAISE5MINACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISE5MINFLAGS`	`Nullable(Float64)`	✓	✓
`RAISE60SEC`	`Nullable(Float64)`	✓	✓
`RAISE60SECACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISE60SECFLAGS`	`Nullable(Float64)`	✓	✓
`RAISE6SEC`	`Nullable(Float64)`	✓	✓
`RAISE6SECACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISE6SECFLAGS`	`Nullable(Float64)`	✓	✓
`RAISEREG`	`Nullable(Float64)`	✓	✓
`RAISEREGACTUALAVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISEREGAVAILABILITY`	`Nullable(Float64)`	✓	✓
`RAISEREGENABLEMENTMAX`	`Nullable(Float64)`	✓	✓
`RAISEREGENABLEMENTMIN`	`Nullable(Float64)`	✓	✓
`RAISEREGFLAGS`	`Nullable(Float64)`	✓	✓
`RAMPDOWNRATE`	`Nullable(Float64)`	✓	✓
`RAMPUPRATE`	`Nullable(Float64)`	✓	✓
`RUNNO`	`Nullable(Float64)`	✓	✓
`SEMIDISPATCHCAP`	`Nullable(Float64)`	✓	✓
`SETTLEMENTDATE`	`Nullable(DateTime64(3))`	✓	✓
`TOTALCLEARED`	`Nullable(Float64)`	✓	✓
`TRADETYPE`	`Nullable(Float64)`	✓	✓
`UIGF`	`Nullable(Float64)`	✓	✓
`UPEPF`	`Nullable(Float64)`	✓	✓
`VIOLATION5MINDEGREE`	`Nullable(Float64)`	✓	✓
`VIOLATION60SECDEGREE`	`Nullable(Float64)`	✓	✓
`VIOLATION6SECDEGREE`	`Nullable(Float64)`	✓	✓
`VIOLATIONDEGREE`	`Nullable(Float64)`	✓	✓
`processed_at`	`DateTime64(3)`	✓	✓
`source_zip`	`String`	✓	✓

Schema Versions

Version	Rows	Size
`479f84c5`	60,569,808	775.65 MiB
`d203d640`	6,846,384	95.51 MiB

Last updated: 2026-01-02 16:00:06

unit_scada v1 unit_solution v5