predispatch__unit_solution__5

AEMO Description

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	2
Combined Rows	29,229,212
Combined Size	219.22 MiB
Unified View	`nemwebviews.predispatch__unit_solution__5`

Schema Evolution

Column	Type	49a80321	6c777f5a
`AGCSTATUS`	`Nullable(Float64)`	✓	✓
`AVAILABILITY`	`Nullable(Float64)`	✓	✓
`CONFORMANCE_MODE`	`Nullable(Float64)`	✓	✓
`CONNECTIONPOINTID`	`LowCardinality(String)`	✓	✓
`DATETIME`	`Nullable(DateTime64(3))`	✓	✓
`DISPATCHMODE`	`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)`	✓	✓
`LOWERREGFLAGS`	`Nullable(Float64)`	✓	✓
`MARGINAL5MINVALUE`	`Nullable(Float64)`	✓	✓
`MARGINAL60SECVALUE`	`Nullable(Float64)`	✓	✓
`MARGINAL6SECVALUE`	`Nullable(Float64)`	✓	✓
`MARGINALVALUE`	`Nullable(Float64)`	✓	✓
`MIN_AVAILABILITY`	`Nullable(Float64)`	✓	✓
`PERIODID`	`Nullable(Float64)`	✓	✓
`PREDISPATCHSEQNO`	`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)`	✓	✓
`RAISEREGFLAGS`	`Nullable(Float64)`	✓	✓
`RAMPDOWNRATE`	`Nullable(Float64)`	✓	✓
`RAMPUPRATE`	`Nullable(Float64)`	✓	✓
`RUNNO`	`Nullable(Float64)`	✓	✓
`SEMIDISPATCHCAP`	`Nullable(Float64)`	✓	✓
`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
`49a80321`	542,656	5.59 MiB
`6c777f5a`	28,686,556	213.63 MiB

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

unit_solution v4