predispatch__offertrk__1

AEMO Description

PREDISPATCHOFFERTRK is for the ancillary service bid trackin

Note that the provided table descriptions are truncated by AEMO.

Total Schema Versions 1
Combined Rows 61,468,422
Combined Size 178.85 MiB
MMS Table predispatchoffertrk
Unified View nemwebviews.predispatch__offertrk__1

Schema Evolution

Column Type Description 440e3d24
BIDOFFERDATE Nullable(DateTime64(3)) Time this bid was processed and loaded ✓
BIDSETTLEMENTDATE Nullable(DateTime64(3)) Settlement date of bid applied ✓
BIDTYPE LowCardinality(String) Bid type Identifier - the ancillary service to which the bid applies ✓
DATETIME Nullable(DateTime64(3)) Period date and time ✓
DUID LowCardinality(String) Dispatchable Unit identifier ✓
LASTCHANGED Nullable(DateTime64(3)) Last date and time record changed ✓
PERIODID Nullable(Float64) PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period. ✓
PREDISPATCHSEQNO Nullable(Float64) Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 ✓
processed_at DateTime64(3) ✓
source_zip String ✓

Schema Versions

Version Rows Size
440e3d24 61,468,422 178.85 MiB

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