Skip to content

PREDISPATCHLOAD

PREDISPATCHLOAD shows pre-dispatch targets for each dispatchable unit, including additional fields to handle the Ancillary Services functionality. No record is written where a unit is not dispatched. PREDISPATCHLOAD shows all the results for each period.

Source

Own (confidential) data updates every thirty minutes, with whole market data for the day before available as part of next day market data.

Note

** A flag exists for each ancillary service type such that a unit trapped or stranded in one or more service type can be immediately identified. The flag is defined using the low 3 bits as follows:

Flag Name Bit Description
Enabled 0 The unit is enabled to provide this ancillary service type.
Trapped 1 The unit is enabled to provide this ancillary service type, however the profile for this service type is causing the unit to be trapped in the energy market.
Stranded 2 The unit is bid available to provide this ancillary service type, however, the unit is operating in the energy market outside of the profile for this service type and is stranded from providing this service.

Interpretation of the bit-flags as a number gives the following possibilities (i.e. other combinations are not possible):

Numeric Value Bit (2,1,0) Meaning
0 000 Not stranded, not trapped, not enabled.
1 001 Not stranded, not trapped, is enabled.
3 011 Not stranded, is trapped, is enabled.
4 100 Is stranded, not trapped, not enabled.

For example, testing for availability can be done by checking for odd (=available) or even (=unavailable) number (e.g. mod(flag,2) results in 0 for unavailable and 1 for available).

*** "Actual FCAS availability" is determined in a post-processing step based on the energy target (TotalCleared) and bid FCAS trapezium for that interval. However, if the unit is outside the bid FCAS trapezium at the start of the interval (InitialMW), the "Actual FCAS availability" is set to zero. For regulation services, the trapezium is the most restrictive of the bid/SCADA trapezium values.

Tip

1 second, 6 second, 5 minute, 60 second and regulation refer to types of FCAS markets.

Column Schema

DATETIME

Period date and time

SQL Type: DATE Polars Type: pl.Datetime()

This column is mandatory, and a primary key.

Example: 2026/09/01 04:30:00

DUID

Dispatchable unit identifier for fast start

Warning

This column may contain funny characters such as / (slash) or # (hash). This may break hive-style partitioning.

For more information, see the dedicated documentation page.

SQL Type: VARCHAR2(10) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Examples:

  • ADPBA1
  • ADPPV1
  • AGLHAL
  • AGLSOM
  • ALDGASF1
  • ANGAST1
  • APD01
  • ARWF1
  • ASACLE01
  • ASDEVI01

AGCSTATUS

AGC Status from EMS

SQL Type: NUMBER(2,0) Polars Type: pl.Int8

This column is not mandatory.

Examples: 0, 1

AVAILABILITY

For Scheduled units, this is the MAXAVAIL bid availability For Semi-scheduled units, this is the lower of MAXAVAIL bid availability and UIGF

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 3.103, 0, 1, 1475

CONFORMANCE_MODE

Mode specific to units within an aggregate. 0 - no monitoring, 1 - aggregate monitoring, 2 - individual monitoring due to constraint

SQL Type: NUMBER(6,0) Polars Type: pl.Int32

This column is not mandatory.

Examples: 0, 1

CONNECTIONPOINTID

Connection point identifier

SQL Type: VARCHAR2(12) Polars Type: pl.Categorical

This column is not mandatory.

Examples:

  • AKWB1W
  • NAL11C
  • NAL12M
  • NASACA01
  • NASAGL03
  • NASENG01
  • NASGRD01
  • NASGRU01
  • NASHYD01
  • NASSHU01

DISPATCHMODE

Dispatch mode of unit for fast start (1-4)

SQL Type: NUMBER(2,0) Polars Type: pl.Int8

This column is not mandatory.

Example: 0

ELEMENT_CAP

Cap on the number of turbines or inverters at a DUID.

SQL Type: NUMBER(5,0) Polars Type: pl.Int32

This column is not mandatory.

ENERGY_STORAGE

The projected energy storage based on cleared energy and regulation FCAS dispatch(MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.01265, 0, 496.89452

ENERGY_STORAGE_MAX

BDU only - Maximum Energy Storage constraint limit (MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

ENERGY_STORAGE_MIN

BDU only - Minimum Energy Storage constraint limit (MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

INITIAL_ENERGY_STORAGE

The energy storage at the start of this dispatch interval(MWh)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

INITIALMW

Initial MW at start of first period. For periods subsequent to the first period of a Pre-Dispatch run, this value represents the cleared target for the previous period of that Pre-Dispatch run. Negative values when Bi-directional Unit start from importing power, otherwise positive.

Warning

In AEMO data, datetimes usually refer to the end of an interval. Power values usually do too. However this column refers to the start of the interval. So you need to subtract 5 minutes from SETTLEMENTDATE to align it with INITIALMW.

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: -0.008, 0.00001, 0, 405

INTERVENTION

Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0

Warning

Unlike most tables with an INTERVENTION column, INTERVENTION is not a primary key of PREDISPATCHLOAD.

For more information, see the dedicated documentation page.

SQL Type: NUMBER(2,0) Polars Type: pl.Boolean

This column is not mandatory.

Example: 0

LASTCHANGED

Last date and time record changed

For more information, see the dedicated documentation page.

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2026/09/01 04:02:00

LOWER1SEC

Dispatched Lower1Sec - TraderSolution element L1Target attribute

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 5.30709, 0, 27, 35

LOWER1SECACTUALAVAILABILITY

Trapezium adjusted Lower 1Sec Availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 1, 225

LOWER1SECFLAGS

TraderSolution element L1Flags attribute

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

LOWER5MIN

Lower 5 min MW target in period

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 4.42822, 0, 2, 80

LOWER5MINACTUALAVAILABILITY

trapezium adjusted lower 5min availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 2.025974, 0, 1, 236

LOWER5MINFLAGS

Lower 5min status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

LOWER6SEC

Lower 6 sec MW target in period

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 46.66455, 0, 2, 80

LOWER6SECACTUALAVAILABILITY

trapezium adjusted lower 6sec availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 3.333333, 0, 1, 225

LOWER6SECFLAGS

Lower 6sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

LOWER60SEC

Lower 60 sec MW target in period

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 30.91022, 0, 2, 114

LOWER60SECACTUALAVAILABILITY

trapezium adjusted lower 60sec availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 3.591837, 0, 1, 236

LOWER60SECFLAGS

Lower 60sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

LOWERREG

Lower Regulation reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 4, 64

LOWERREGACTUALAVAILABILITY

trapezium adjusted lower reg availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 59.99988, 0, 2, 415

LOWERREGFLAGS

Lower Reg status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

MARGINAL5MINVALUE

Marginal $ value for 5 min from LP Solver

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

MARGINAL6SECVALUE

Marginal $ value for 6 seconds from LP Solver

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

MARGINAL60SECVALUE

Marginal $ value for 60 seconds from LP Solver

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

MARGINALVALUE

Marginal $ value for energy from LP Solver

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

MIN_AVAILABILITY

BDU only. Load side availability (BidOfferPeriod.MAXAVAIL where DIRECTION = LOAD)

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 2, 415

PERIODID

PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period.

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Example: 01

PREDISPATCHSEQNO

Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

  • 2026090101
  • 2026090102

RAISE1SEC

Dispatched Raise1Sec - TraderSolution element R1Target attribute

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 69.52352, 0, 1, 80

RAISE1SECACTUALAVAILABILITY

Trapezium adjusted Raise 1Sec Availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 8.739724, 0, 1, 225

RAISE1SECFLAGS

TraderSolution element R1Flags attribute

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAISE5MIN

Raise 5 min MW target in period

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 84.40087, 0, 1, 80

RAISE5MINACTUALAVAILABILITY

trapezium adjusted raise 5min availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 20.7, 0, 1, 450

RAISE5MINFLAGS

Raise 5min status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

RAISE6SEC

Raise 6 sec MW target in period

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 1.12106, 0, 1, 80

RAISE6SECACTUALAVAILABILITY

trapezium adjusted raise 6sec availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 7.425, 0, 1, 450

RAISE6SECFLAGS

Raise 6sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

RAISE60SEC

Raise 60 sec MW target in period

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 35.65183, 0, 1, 80

RAISE60SECACTUALAVAILABILITY

trapezium adjusted raise 60sec availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 27.5, 0, 1, 450

RAISE60SECFLAGS

Raise 60sec status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

RAISEREG

Raise Regulation reserve target

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 3, 42

RAISEREGACTUALAVAILABILITY

trapezium adjusted raise reg availability

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

Examples: 13.18253, 0, 2, 255

RAISEREGFLAGS

Raise reg status flag

SQL Type: NUMBER(3,0) Polars Type: pl.Int16

This column is not mandatory.

Examples: 0, 1, 4

RAMPDOWNRATE

Ramp down rate in period in MW/minute

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 60, 20400

RAMPUPRATE

Ramp up rate in period in MW/minute

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0, 60, 20400

RUNNO

SPD Predispatch run no, typically 1. It increments if the case is re-run.

SQL Type: NUMBER(3,0) Polars Type: pl.UInt16

This column is not mandatory.

Example: 1

SEMIDISPATCHCAP

Boolean representation flagging if the Target is Capped

SQL Type: NUMBER(3,0) Polars Type: pl.Boolean

This column is not mandatory.

Examples: 0, 1

TOTALCLEARED

Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive.

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 3.109, 0, -1, 685

UIGF

For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: 3.103, 0, 23, 99

VIOLATION5MINDEGREE

Violation MW 5 min

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

VIOLATION6SECDEGREE

Violation MW 6 seconds

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

VIOLATION60SECDEGREE

Violation MW 60 seconds

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

VIOLATIONDEGREE

Violation MW energy

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is not mandatory.

DOWNEPF

Not used in Pre-Dispatch

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is unused.

TRADETYPE

Not used

SQL Type: NUMBER(2,0) Polars Type: pl.Int8

This column is unused.

UPEPF

Not used in Pre-Dispatch

SQL Type: NUMBER(15,5) Polars Type: pl.Float64

This column is unused.

New Data Timing

Every 30 minutes, with whole market data for the day before available as part of next day market data

Code Examples

Polars

Casting is enums, categoricals etc is not essential, but may speed up parsing. Swapping int for pl.UInt16, pl.Int32 would also speed up parsing. However some of the datatypes are inferred, so they may be wrong.

This code deduplicates for you. Deduplication is normally only required across multiple months.

This code assumes that all columns are present, which may not be true for older files.

import polars as pl
import polars.selectors as cs

# e.g. "2029/03/15 00:05:00"
dt_s_fmt = "%Y/%m/%d %H:%M:%S"

csv_paths = ["SOMEFILE.CSV", "OTHERFILE.CSV"]

lf = (
    pl.concat(
        [
            pl.scan_csv(
                csv_path,  # must be unzipped beforehand
                skip_rows=1,  # skip the header
                infer_schema=False,  # much faster
            )
            .filter(cs.by_index(0) == "D")  # drop the footer
            .select(~cs.by_index(range(4)))  # drop metadata columns
            for csv_path in csv_paths
        ],
        how="diagonal_relaxed",
    )
    .with_columns(
        pl.col("DATETIME", "LASTCHANGED").str.strptime(pl.Datetime, dt_s_fmt),
    )
    # Polars can't cast string straight to bool. Need to go via something else.
    .cast(
        {
            "INTERVENTION": pl.UInt8,
            "LOWER1SECFLAGS": pl.UInt8,
            "RAISE1SECFLAGS": pl.UInt8,
            "RAISE5MINFLAGS": pl.UInt8,
            "SEMIDISPATCHCAP": pl.UInt8,
        }
    )
    .cast(
        {
            "DUID": pl.Categorical,
            "AGCSTATUS": int,  # or pl.Int8
            "AVAILABILITY": pl.Float64,
            "CONFORMANCE_MODE": int,  # or pl.Int32
            "CONNECTIONPOINTID": pl.Categorical,
            "DISPATCHMODE": int,  # or pl.Int8
            "ELEMENT_CAP": int,  # or pl.Int32
            "ENERGY_STORAGE": pl.Float64,
            "ENERGY_STORAGE_MAX": pl.Float64,
            "ENERGY_STORAGE_MIN": pl.Float64,
            "INITIAL_ENERGY_STORAGE": pl.Float64,
            "INITIALMW": pl.Float64,
            "INTERVENTION": pl.Boolean,
            "LOWER1SEC": pl.Float64,
            "LOWER1SECACTUALAVAILABILITY": pl.Float64,
            "LOWER1SECFLAGS": pl.Boolean,
            "LOWER5MIN": pl.Float64,
            "LOWER5MINACTUALAVAILABILITY": pl.Float64,
            "LOWER5MINFLAGS": int,  # or pl.Int16
            "LOWER6SEC": pl.Float64,
            "LOWER6SECACTUALAVAILABILITY": pl.Float64,
            "LOWER6SECFLAGS": int,  # or pl.Int16
            "LOWER60SEC": pl.Float64,
            "LOWER60SECACTUALAVAILABILITY": pl.Float64,
            "LOWER60SECFLAGS": int,  # or pl.Int16
            "LOWERREG": pl.Float64,
            "LOWERREGACTUALAVAILABILITY": pl.Float64,
            "LOWERREGFLAGS": int,  # or pl.Int16
            "MARGINAL5MINVALUE": pl.Float64,
            "MARGINAL6SECVALUE": pl.Float64,
            "MARGINAL60SECVALUE": pl.Float64,
            "MARGINALVALUE": pl.Float64,
            "MIN_AVAILABILITY": pl.Float64,
            "PERIODID": str,
            "PREDISPATCHSEQNO": str,
            "RAISE1SEC": pl.Float64,
            "RAISE1SECACTUALAVAILABILITY": pl.Float64,
            "RAISE1SECFLAGS": pl.Boolean,
            "RAISE5MIN": pl.Float64,
            "RAISE5MINACTUALAVAILABILITY": pl.Float64,
            "RAISE5MINFLAGS": pl.Boolean,
            "RAISE6SEC": pl.Float64,
            "RAISE6SECACTUALAVAILABILITY": pl.Float64,
            "RAISE6SECFLAGS": int,  # or pl.Int16
            "RAISE60SEC": pl.Float64,
            "RAISE60SECACTUALAVAILABILITY": pl.Float64,
            "RAISE60SECFLAGS": int,  # or pl.Int16
            "RAISEREG": pl.Float64,
            "RAISEREGACTUALAVAILABILITY": pl.Float64,
            "RAISEREGFLAGS": int,  # or pl.Int16
            "RAMPDOWNRATE": pl.Float64,
            "RAMPUPRATE": pl.Float64,
            "RUNNO": int,  # or pl.UInt16
            "SEMIDISPATCHCAP": pl.Boolean,
            "TOTALCLEARED": pl.Float64,
            "UIGF": pl.Float64,
            "VIOLATION5MINDEGREE": pl.Float64,
            "VIOLATION6SECDEGREE": pl.Float64,
            "VIOLATION60SECDEGREE": pl.Float64,
            "VIOLATIONDEGREE": pl.Float64,
            "DOWNEPF": pl.Float64,
            "TRADETYPE": int,  # or pl.Int8
            "UPEPF": pl.Float64,
        }
    )
    # Drop deprecated/unused columns
    .drop("DOWNEPF", "TRADETYPE", "UPEPF")
    # Deduplicate
    # We want one row per ['DATETIME', 'DUID']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["DATETIME", "DUID"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_PREDISPATCHLOAD_FILE01_202609010000.zip

PREDISPATCHSEQNORUNNODUIDTRADETYPEPERIODIDINTERVENTIONCONNECTIONPOINTIDAGCSTATUSDISPATCHMODEINITIALMWTOTALCLEAREDLOWER5MINLOWER60SECLOWER6SECRAISE5MINRAISE60SECRAISE6SECRAMPDOWNRATERAMPUPRATEDOWNEPFUPEPFMARGINAL5MINVALUEMARGINAL60SECVALUEMARGINAL6SECVALUEMARGINALVALUEVIOLATION5MINDEGREEVIOLATION60SECDEGREEVIOLATION6SECDEGREEVIOLATIONDEGREELASTCHANGEDDATETIMELOWERREGRAISEREGAVAILABILITYRAISE6SECFLAGSRAISE60SECFLAGSRAISE5MINFLAGSRAISEREGFLAGSLOWER6SECFLAGSLOWER60SECFLAGSLOWER5MINFLAGSLOWERREGFLAGSRAISE6SECACTUALAVAILABILITYRAISE60SECACTUALAVAILABILITYRAISE5MINACTUALAVAILABILITYRAISEREGACTUALAVAILABILITYLOWER6SECACTUALAVAILABILITYLOWER60SECACTUALAVAILABILITYLOWER5MINACTUALAVAILABILITYLOWERREGACTUALAVAILABILITYSEMIDISPATCHCAPCONFORMANCE_MODEUIGFRAISE1SECRAISE1SECFLAGSLOWER1SECLOWER1SECFLAGSRAISE1SECACTUALAVAILABILITYLOWER1SECACTUALAVAILABILITYINITIAL_ENERGY_STORAGEENERGY_STORAGEENERGY_STORAGE_MINENERGY_STORAGE_MAXMIN_AVAILABILITYELEMENT_CAP
20260901011YWPS4010VYP2400000000001801802026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
20260901011YWPS3010VYP2310298.968753000000001801802026/09/01 04:02:002026/09/01 04:30:00003850000000000000000000000000
20260901011YWPS2010VYP2210319.53200000001801802026/09/01 04:02:002026/09/01 04:30:00003200000000000000000000000000
20260901011YWPS1010VYP2110329.53300000001801802026/09/01 04:02:002026/09/01 04:30:00003450000000000000000000000000
20260901011YENDWF1010VBAW1Y00127.94119.747000000168016802026/09/01 04:02:002026/09/01 04:30:0000119.74700000000000000000119.7470000000
20260901011YATSF1010VRCS2Y00000000009609602026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
20260901011YARWUN_1010QYAG1R0072.2872.28000000002026/09/01 04:02:002026/09/01 04:30:00001650000000000000000000000000
20260901011YARANSF1010QMRY1Y0000000000120012002026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
20260901011YABULU2010QGAR100000000004802402026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
20260901011YABULU010QTYP00000000009609602026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
20260901011WYASF1010NWGJ4W00000000006606602026/09/01 04:02:002026/09/01 04:30:000000000000000000000100000000
...

CSETP.WORLDDVD_PREDISPATCHLOADAEMOPUBLIC2026/10/0916:27:03001791527223985MONTHLY_ARCHIVE001791527223985
IPREDISPATCHUNIT_SOLUTION5PREDISPATCHSEQNORUNNODUIDTRADETYPEPERIODIDINTERVENTIONCONNECTIONPOINTIDAGCSTATUSDISPATCHMODEINITIALMWTOTALCLEAREDLOWER5MINLOWER60SECLOWER6SECRAISE5MINRAISE60SECRAISE6SECRAMPDOWNRATERAMPUPRATEDOWNEPFUPEPFMARGINAL5MINVALUEMARGINAL60SECVALUEMARGINAL6SECVALUEMARGINALVALUEVIOLATION5MINDEGREEVIOLATION60SECDEGREEVIOLATION6SECDEGREEVIOLATIONDEGREELASTCHANGEDDATETIMELOWERREGRAISEREGAVAILABILITYRAISE6SECFLAGSRAISE60SECFLAGSRAISE5MINFLAGSRAISEREGFLAGSLOWER6SECFLAGSLOWER60SECFLAGSLOWER5MINFLAGSLOWERREGFLAGSRAISE6SECACTUALAVAILABILITYRAISE60SECACTUALAVAILABILITYRAISE5MINACTUALAVAILABILITYRAISEREGACTUALAVAILABILITYLOWER6SECACTUALAVAILABILITYLOWER60SECACTUALAVAILABILITYLOWER5MINACTUALAVAILABILITYLOWERREGACTUALAVAILABILITYSEMIDISPATCHCAPCONFORMANCE_MODEUIGFRAISE1SECRAISE1SECFLAGSLOWER1SECLOWER1SECFLAGSRAISE1SECACTUALAVAILABILITYLOWER1SECACTUALAVAILABILITYINITIAL_ENERGY_STORAGEENERGY_STORAGEENERGY_STORAGE_MINENERGY_STORAGE_MAXMIN_AVAILABILITYELEMENT_CAP
DPREDISPATCHUNIT_SOLUTION520260901011YWPS4010VYP2400000000001801802026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YWPS3010VYP2310298.968753000000001801802026/09/01 04:02:002026/09/01 04:30:00003850000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YWPS2010VYP2210319.53200000001801802026/09/01 04:02:002026/09/01 04:30:00003200000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YWPS1010VYP2110329.53300000001801802026/09/01 04:02:002026/09/01 04:30:00003450000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YENDWF1010VBAW1Y00127.94119.747000000168016802026/09/01 04:02:002026/09/01 04:30:0000119.74700000000000000000119.7470000000
DPREDISPATCHUNIT_SOLUTION520260901011YATSF1010VRCS2Y00000000009609602026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YARWUN_1010QYAG1R0072.2872.28000000002026/09/01 04:02:002026/09/01 04:30:00001650000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YARANSF1010QMRY1Y0000000000120012002026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YABULU2010QGAR100000000004802402026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011YABULU010QTYP00000000009609602026/09/01 04:02:002026/09/01 04:30:000000000000000000000000000000
DPREDISPATCHUNIT_SOLUTION520260901011WYASF1010NWGJ4W00000000006606602026/09/01 04:02:002026/09/01 04:30:000000000000000000000100000000
...
CEND OF REPORT1003

PREDISPATCHSEQNO,RUNNO,DUID,TRADETYPE,PERIODID,INTERVENTION,CONNECTIONPOINTID,AGCSTATUS,DISPATCHMODE,INITIALMW,TOTALCLEARED,LOWER5MIN,LOWER60SEC,LOWER6SEC,RAISE5MIN,RAISE60SEC,RAISE6SEC,RAMPDOWNRATE,RAMPUPRATE,DOWNEPF,UPEPF,MARGINAL5MINVALUE,MARGINAL60SECVALUE,MARGINAL6SECVALUE,MARGINALVALUE,VIOLATION5MINDEGREE,VIOLATION60SECDEGREE,VIOLATION6SECDEGREE,VIOLATIONDEGREE,LASTCHANGED,DATETIME,LOWERREG,RAISEREG,AVAILABILITY,RAISE6SECFLAGS,RAISE60SECFLAGS,RAISE5MINFLAGS,RAISEREGFLAGS,LOWER6SECFLAGS,LOWER60SECFLAGS,LOWER5MINFLAGS,LOWERREGFLAGS,RAISE6SECACTUALAVAILABILITY,RAISE60SECACTUALAVAILABILITY,RAISE5MINACTUALAVAILABILITY,RAISEREGACTUALAVAILABILITY,LOWER6SECACTUALAVAILABILITY,LOWER60SECACTUALAVAILABILITY,LOWER5MINACTUALAVAILABILITY,LOWERREGACTUALAVAILABILITY,SEMIDISPATCHCAP,CONFORMANCE_MODE,UIGF,RAISE1SEC,RAISE1SECFLAGS,LOWER1SEC,LOWER1SECFLAGS,RAISE1SECACTUALAVAILABILITY,LOWER1SECACTUALAVAILABILITY,INITIAL_ENERGY_STORAGE,ENERGY_STORAGE,ENERGY_STORAGE_MIN,ENERGY_STORAGE_MAX,MIN_AVAILABILITY,ELEMENT_CAP
2026090101,1,YWPS4,,01,0,VYP24,0,0,0,0,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YWPS3,,01,0,VYP23,1,0,298.96875,300,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,385,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YWPS2,,01,0,VYP22,1,0,319.5,320,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,320,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YWPS1,,01,0,VYP21,1,0,329.5,330,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,345,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YENDWF1,,01,0,VBAW1Y,0,0,127.94,119.747,0,0,0,0,0,0,1680,1680,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,119.747,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,119.747,0,0,0,0,0,0,,,,,0,
2026090101,1,YATSF1,,01,0,VRCS2Y,0,0,0,0,0,0,0,0,0,0,960,960,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YARWUN_1,,01,0,QYAG1R,0,0,72.28,72.28,0,0,0,0,0,0,0,0,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,165,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YARANSF1,,01,0,QMRY1Y,0,0,0,0,0,0,0,0,0,0,1200,1200,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YABULU2,,01,0,QGAR1,0,0,0,0,0,0,0,0,0,0,480,240,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,YABULU,,01,0,QTYP,0,0,0,0,0,0,0,0,0,0,960,960,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
2026090101,1,WYASF1,,01,0,NWGJ4W,0,0,0,0,0,0,0,0,0,0,660,660,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,,0,0,0,0,0,0,0,,,,,0,
...

C,SETP.WORLD,DVD_PREDISPATCHLOAD,AEMO,PUBLIC,2026/10/09,16:27:03,001791527223985,MONTHLY_ARCHIVE,001791527223985
I,PREDISPATCH,UNIT_SOLUTION,5,PREDISPATCHSEQNO,RUNNO,DUID,TRADETYPE,PERIODID,INTERVENTION,CONNECTIONPOINTID,AGCSTATUS,DISPATCHMODE,INITIALMW,TOTALCLEARED,LOWER5MIN,LOWER60SEC,LOWER6SEC,RAISE5MIN,RAISE60SEC,RAISE6SEC,RAMPDOWNRATE,RAMPUPRATE,DOWNEPF,UPEPF,MARGINAL5MINVALUE,MARGINAL60SECVALUE,MARGINAL6SECVALUE,MARGINALVALUE,VIOLATION5MINDEGREE,VIOLATION60SECDEGREE,VIOLATION6SECDEGREE,VIOLATIONDEGREE,LASTCHANGED,DATETIME,LOWERREG,RAISEREG,AVAILABILITY,RAISE6SECFLAGS,RAISE60SECFLAGS,RAISE5MINFLAGS,RAISEREGFLAGS,LOWER6SECFLAGS,LOWER60SECFLAGS,LOWER5MINFLAGS,LOWERREGFLAGS,RAISE6SECACTUALAVAILABILITY,RAISE60SECACTUALAVAILABILITY,RAISE5MINACTUALAVAILABILITY,RAISEREGACTUALAVAILABILITY,LOWER6SECACTUALAVAILABILITY,LOWER60SECACTUALAVAILABILITY,LOWER5MINACTUALAVAILABILITY,LOWERREGACTUALAVAILABILITY,SEMIDISPATCHCAP,CONFORMANCE_MODE,UIGF,RAISE1SEC,RAISE1SECFLAGS,LOWER1SEC,LOWER1SECFLAGS,RAISE1SECACTUALAVAILABILITY,LOWER1SECACTUALAVAILABILITY,INITIAL_ENERGY_STORAGE,ENERGY_STORAGE,ENERGY_STORAGE_MIN,ENERGY_STORAGE_MAX,MIN_AVAILABILITY,ELEMENT_CAP
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YWPS4,,01,0,VYP24,0,0,0,0,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YWPS3,,01,0,VYP23,1,0,298.96875,300,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,385,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YWPS2,,01,0,VYP22,1,0,319.5,320,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,320,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YWPS1,,01,0,VYP21,1,0,329.5,330,0,0,0,0,0,0,180,180,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,345,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YENDWF1,,01,0,VBAW1Y,0,0,127.94,119.747,0,0,0,0,0,0,1680,1680,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,119.747,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,119.747,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YATSF1,,01,0,VRCS2Y,0,0,0,0,0,0,0,0,0,0,960,960,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YARWUN_1,,01,0,QYAG1R,0,0,72.28,72.28,0,0,0,0,0,0,0,0,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,165,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YARANSF1,,01,0,QMRY1Y,0,0,0,0,0,0,0,0,0,0,1200,1200,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YABULU2,,01,0,QGAR1,0,0,0,0,0,0,0,0,0,0,480,240,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,YABULU,,01,0,QTYP,0,0,0,0,0,0,0,0,0,0,960,960,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,,,0,
D,PREDISPATCH,UNIT_SOLUTION,5,2026090101,1,WYASF1,,01,0,NWGJ4W,0,0,0,0,0,0,0,0,0,0,660,660,,,,,,,,,,,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,,0,0,0,0,0,0,0,,,,,0,
...
C,"END OF REPORT",1003

Availability

Visibility: Private & Public Next-Day

This table is in the public monthly MMSDM archive.

I have collated the list of all those files into one place, in this CSV metadata file. (Columns year, month, url, compressed_size in bytes).

The earliest available data is month 1 of 2015. The most recent available data is month 9 of 2026.

Every month in between has a file. (No gaps.)

Data Size

Each year of data is approximately 221 MB when zipped, 2 GB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

The transaction type is "UPDATE-INSERT", which means that you will likely see duplicate data with different values.

You should deduplicate by sorting based on LASTCHANGED, within each group of primary keys.

PDR Loader configuration is:

Report Name Report Subtype Version
PREDISPATCH UNIT_SOLUTION 4
PREDISPATCH UNIT_SOLUTION 5

This means that the CSV files start with metadata columns:

I,PREDISPATCH,UNIT_SOLUTION,4,...
D,PREDISPATCH,UNIT_SOLUTION,4,...

or

I,PREDISPATCH,UNIT_SOLUTION,5,...
D,PREDISPATCH,UNIT_SOLUTION,5,...

ROW_FILTER_TYPE is LASTCHANGED

Indexes

There is more than one index.

Index 1:

Index 2:

Index 3:

This page as JSON (schema documented here, but may change)

Download a JSON Schema specification for this table.

Official AEMO schema documentation (multi-page):

Other Information

Package: PRE_DISPATCH