participant_registration__dudetailsummary

AEMO Description

DUDETAILSUMMARY sets out a single summary unit table so redu

Note that the provided table descriptions are truncated by AEMO.


Total Schema Versions	1
Combined Rows	155,323
Combined Size	874.63 KiB
MMS Table	`dudetailsummary`
Unified View	`nemwebviews.participant_registration__dudetailsummary`

Schema Evolution

Column	Type	Description	af53c352
`ADG_ID`	`LowCardinality(String)`	Aggregate Dispatch Group. Group into which the DUID is aggregated for Conformance. Null if DUID not aggregated for Conformance	✓
`CONNECTIONPOINTID`	`LowCardinality(String)`	Country wide - Unique id of a connection point	✓
`DISPATCHSUBTYPE`	`LowCardinality(String)`	Additional information for DISPATCHTYPE. For DISPATCHTYPE = LOAD, subtype value is WDR for wholesale demand response units For DISPATCHTYPE = LOAD, subtype value is NULL for Scheduled Loads. For DISPATCHTYPE = GENERATOR type, subtype value is NULL.	✓
`DISPATCHTYPE`	`LowCardinality(String)`	Identifies LOAD, GENERATOR or BIDIRECTIONAL. This will likely expand to more generic models as new technology types are integrated into the NEM	✓
`DISTRIBUTIONLOSSFACTOR`	`Nullable(Float64)`	The distribution loss factor to the currently assigned connection point	✓
`DUID`	`LowCardinality(String)`	Dispatchable Unit Identifier	✓
`END_DATE`	`Nullable(DateTime64(3))`	End date for effective record	✓
`IS_AGGREGATED`	`Nullable(Float64)`	Whether the DUID is classified as an “Aggregated Unit” under the rules. This impacts the Minimum Ramp Rate calculation	✓
`LASTCHANGED`	`Nullable(DateTime64(3))`	Last date and time record changed	✓
`LOAD_MAXIMUM_ENERGY_PRICE`	`Nullable(Float64)`	BDU only. Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL for energy imports	✓
`LOAD_MAX_RAMP_RATE_DOWN`	`Nullable(Float64)`	BDU only. MW/Min. Registered Maximum Ramp Rate Down value accepted for Energy Offers or Bids for energy imports	✓
`LOAD_MAX_RAMP_RATE_UP`	`Nullable(Float64)`	BDU only. MW/Min. Registered Maximum Ramp Rate Up value accepted for Energy Offers or Bids for energy imports	✓
`LOAD_MINIMUM_ENERGY_PRICE`	`Nullable(Float64)`	BDU only. Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF for energy imports	✓
`LOAD_MIN_RAMP_RATE_DOWN`	`Nullable(Float64)`	BDU only. MW/Min. Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation for energy imports	✓
`LOAD_MIN_RAMP_RATE_UP`	`Nullable(Float64)`	BDU only. MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation for energy imports	✓
`MAXIMUM_ENERGY_PRICE`	`Nullable(Float64)`	Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL	✓
`MAX_RAMP_RATE_DOWN`	`Nullable(Float64)`	Maximum ramp down rate for Unit (Mw/min) - from DUDetail table	✓
`MAX_RAMP_RATE_UP`	`Nullable(Float64)`	Maximum ramp up rate for Unit (Mw/min) - from DUDetail table	✓
`MINIMUM_ENERGY_PRICE`	`Nullable(Float64)`	Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF	✓
`MIN_RAMP_RATE_DOWN`	`Nullable(Float64)`	MW/Min. Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation	✓
`MIN_RAMP_RATE_UP`	`Nullable(Float64)`	MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation	✓
`PARTICIPANTID`	`LowCardinality(String)`	Participant that owns unit during effective record period	✓
`REGIONID`	`LowCardinality(String)`	Region identifier that unit is in	✓
`SCHEDULE_TYPE`	`LowCardinality(String)`	Scheduled status of the unit:	✓
`SECONDARY_TLF`	`Nullable(Float64)`	Used in Bidding, Dispatch and Settlements, only populated where Dual TLFs apply. For Bidding and Dispatch, the TLF for the generation component of a BDU, when null the TRANSMISSIONLOSSFACTOR is used for both the load and generation components. For Settlements, the secondary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is positive (net generation).	✓
`STARTTYPE`	`LowCardinality(String)`	Unit start type. At this time restricted to Fast, Slow or Non Dispatched	✓
`START_DATE`	`Nullable(DateTime64(3))`	Start date for effective record	✓
`STATIONID`	`LowCardinality(String)`	Station that unit is in	✓
`TRANSMISSIONLOSSFACTOR`	`Nullable(Float64)`	Used in Bidding, Dispatch and Settlements. For Bidding and Dispatch, where the DUID is a BDU with DISPATCHTYPE of BIDIRECTIONAL, the TLF for the load component of the BDU. For Settlements, where dual TLFs apply, the primary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is negative (net load).	✓
`processed_at`	`DateTime64(3)`		✓
`source_zip`	`String`		✓

Schema Versions

Version	Rows	Size
`af53c352`	155,323	874.63 KiB

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

dudetailsummary v7