| DUID |
varchar(10)  |
varchar(10) |
Dispatchable Unit Identifier |
| START_DATE |
datetime(3) |
datetime2(0) |
Start date for effective record |
| END_DATE |
datetime(3) (not nullable) |
datetime2(0) (not nullable) |
End date for effective record |
| DISPATCHTYPE |
varchar(20) |
varchar(20) |
Identifies LOAD, GENERATOR or BIDIRECTIONAL. This will likely expand to more generic models as new technology types are integrated into the NEM |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Country wide - Unique id of a connection point |
| REGIONID |
varchar(10) |
varchar(10) |
Region identifier that unit is in |
| STATIONID |
varchar(10) |
varchar(10) |
Station that unit is in |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Participant that owns unit during effective record period |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| TRANSMISSIONLOSSFACTOR |
numeric(15, 5) |
numeric(15, 5) |
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). |
| STARTTYPE |
varchar(20) |
varchar(20) |
Unit start type. At this time restricted to Fast, Slow or Non Dispatched |
| DISTRIBUTIONLOSSFACTOR |
numeric(15, 5) |
numeric(15, 5) |
The distribution loss factor to the currently assigned connection point |
| MINIMUM_ENERGY_PRICE |
numeric(9, 2) |
numeric(9, 2) |
Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF |
| MAXIMUM_ENERGY_PRICE |
numeric(9, 2) |
numeric(9, 2) |
Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL |
| SCHEDULE_TYPE |
varchar(20) |
varchar(20) |
Scheduled status of the unit: ''SCHEDULED'' ''NON-SCHEDULED'' ''SEMI-SCHEDULED |
| MIN_RAMP_RATE_UP |
numeric(6, 0) |
smallint |
MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation |
| MIN_RAMP_RATE_DOWN |
numeric(6, 0) |
smallint |
MW/Min. Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation |
| MAX_RAMP_RATE_UP |
numeric(6, 0) |
smallint |
Maximum ramp up rate for Unit (Mw/min) - from DUDetail table |
| MAX_RAMP_RATE_DOWN |
numeric(6, 0) |
smallint |
Maximum ramp down rate for Unit (Mw/min) - from DUDetail table |
| IS_AGGREGATED |
numeric(1, 0) |
tinyint |
Whether the DUID is classified as an \"Aggregated Unit\" under the rules. This impacts the Minimum Ramp Rate calculation |
| DISPATCHSUBTYPE |
varchar(20) |
varchar(20) |
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. |
| ADG_ID |
varchar(20) |
varchar(20) |
Aggregate Dispatch Group. Group into which the DUID is aggregated for Conformance. Null if DUID not aggregated for Conformance |
| LOAD_MAXIMUM_ENERGY_PRICE |
numeric(9, 2) |
numeric(9, 2) |
BDU only. Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL for energy imports |
| LOAD_MAX_RAMP_RATE_DOWN |
numeric(6, 0) |
smallint |
BDU only. MW/Min. Registered Maximum Ramp Rate Down value accepted for Energy Offers or Bids for energy imports |
| LOAD_MAX_RAMP_RATE_UP |
numeric(6, 0) |
smallint |
BDU only. MW/Min. Registered Maximum Ramp Rate Up value accepted for Energy Offers or Bids for energy imports |
| LOAD_MINIMUM_ENERGY_PRICE |
numeric(9, 2) |
numeric(9, 2) |
BDU only. Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF for energy imports |
| LOAD_MIN_RAMP_RATE_DOWN |
numeric(6, 0) |
smallint |
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 |
numeric(6, 0) |
smallint |
BDU only. MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation for energy imports |
| SECONDARY_TLF |
numeric(18, 8) |
numeric(18, 8) |
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). |