Skip to content

PREDISPATCHINTERCONNECTORRES

PREDISPATCHINTERCONNECTORRES records Interconnector flows and losses for the periods calculated in each predispatch run. Only binding and interconnector constraints are reported. Some fields are for the Frequency Controlled Ancillary Services export and import limits and extra reporting of the generic constraint setting the energy import and export limits.

Source

PREDISPATCHINTERCONNECTORRES updates with every thirty-minute predispatch run.

Note

MW losses can be negative depending on the flow.

The definition of direction of flow for an interconnector is that positive flow starts from the FROMREGION in INTERCONNECTOR.

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

INTERCONNECTORID

Interconnector identifier

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

This column is mandatory, and a primary key.

Examples:

  • N-Q-MNSP1
  • NSW1-QLD1
  • T-V-MNSP1
  • V-S-MNSP1
  • V-SA
  • VIC1-NSW1

EXPORTGENCONID

Generic Constraint setting the export limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

  • I_6F_NS_150
  • N::N_CNCW_2
  • N::Q_BWMP_LDTW
  • N::Q_BWMP_TNT
  • N>>NIL_33_34
  • N>NIL_LSDU
  • N>Q-NIL_757_758
  • NQ_950_TEST
  • NRM_VIC1_SA1
  • N^^N_NIL_WGLT

EXPORTLIMIT

Calculated export limit.

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

This column is not mandatory.

Examples: -0.00001, 4.37233, 0, 950

FCASEXPORTLIMIT

Calculated export limit applying to energy + FCAS.

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

This column is not mandatory.

Examples: -0.00001, 64.80056, 0, 2399

FCASIMPORTLIMIT

Calculated import limit applying to energy + FCAS.

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

This column is not mandatory.

Examples: -20.78175, 0.00001, 0, 50

IMPORTGENCONID

Generic Constraint setting the import limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

  • CA_SYDS_59A889E5_1
  • F_MAIN++APD_TL_L5
  • F_MAIN++LREG_0210
  • F_Q++NIL_R5
  • F_Q++NIL_R6
  • F_Q++NIL_R60
  • F_T++NIL_CHWF_TG_R6
  • F_T++NIL_MG_R6
  • F_T++NIL_MRWF_TG_R6
  • F_T++NIL_WF_TG_R60

IMPORTLIMIT

Calculated import limit.

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

This column is not mandatory.

Examples: -8.13072, 0.00001, 0, 50

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 PREDISPATCHINTERCONNECTORRES.

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 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

LOCAL_PRICE_ADJUSTMENT_EXPORT

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)

SQL Type: NUMBER(10,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: -0.22, 0, -3, -8352000

LOCAL_PRICE_ADJUSTMENT_IMPORT

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)

SQL Type: NUMBER(10,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.11, 0, 6, 8352940

LOCALLY_CONSTRAINED_EXPORT

Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

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

This column is not mandatory.

Examples: 0, 1, 2

LOCALLY_CONSTRAINED_IMPORT

Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

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

This column is not mandatory.

Examples: 0, 1, 2

MARGINALLOSS

Marginal loss factor. Use this to adjust bids between reports.

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

This column is not mandatory.

Examples: 0.46117, 1.59769

MARGINALVALUE

$ Marginal value of interconnector constraint from SPD

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

This column is not mandatory.

Example: 0

METEREDMWFLOW

Metered MW Flow from EMS. 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.

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

This column is not mandatory.

Examples: -0.1, 0.1, 0, 326

MWFLOW

Calculated MW Flow

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

This column is not mandatory.

Examples: -6.34144, 4.37233, 0, 547

MWLOSSES

Calculated MW Losses

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

This column is not mandatory.

Examples: -0.01251, 0.01466, 0, 120.57315

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
  • 2026090423

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

VIOLATIONDEGREE

Degree of violation of interconnector constraint in MW

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

This column is not mandatory.

Example: 0

New Data Timing

Every thirty-minute pre-dispatch run

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})
    .cast(
        {
            "INTERCONNECTORID": pl.Categorical,
            "EXPORTGENCONID": str,
            "EXPORTLIMIT": pl.Float64,
            "FCASEXPORTLIMIT": pl.Float64,
            "FCASIMPORTLIMIT": pl.Float64,
            "IMPORTGENCONID": str,
            "IMPORTLIMIT": pl.Float64,
            "INTERVENTION": pl.Boolean,
            "LOCAL_PRICE_ADJUSTMENT_EXPORT": pl.Float64,
            "LOCAL_PRICE_ADJUSTMENT_IMPORT": pl.Float64,
            "LOCALLY_CONSTRAINED_EXPORT": int,  # or pl.Int8
            "LOCALLY_CONSTRAINED_IMPORT": int,  # or pl.Int8
            "MARGINALLOSS": pl.Float64,
            "MARGINALVALUE": pl.Float64,
            "METEREDMWFLOW": pl.Float64,
            "MWFLOW": pl.Float64,
            "MWLOSSES": pl.Float64,
            "PERIODID": str,
            "PREDISPATCHSEQNO": str,
            "RUNNO": int,  # or pl.UInt16
            "VIOLATIONDEGREE": pl.Float64,
        }
    )
    # Deduplicate
    # We want one row per ['DATETIME', 'INTERCONNECTORID']
    # Tie-breaker: greatest value of ['PREDISPATCHSEQNO']
    .sort(["PREDISPATCHSEQNO"], descending=False)
    .unique(subset=["DATETIME", "INTERCONNECTORID"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_PREDISPATCHINTERCONNECTORRES_FILE01_202609010000.zip

PREDISPATCHSEQNORUNNOINTERCONNECTORIDPERIODIDINTERVENTIONMETEREDMWFLOWMWFLOWMWLOSSESMARGINALVALUEVIOLATIONDEGREELASTCHANGEDDATETIMEEXPORTLIMITIMPORTLIMITMARGINALLOSSEXPORTGENCONIDIMPORTGENCONIDFCASEXPORTLIMITFCASIMPORTLIMITLOCAL_PRICE_ADJUSTMENT_EXPORTLOCALLY_CONSTRAINED_EXPORTLOCAL_PRICE_ADJUSTMENT_IMPORTLOCALLY_CONSTRAINED_IMPORT
20260901011N-Q-MNSP1010-39.99951-413.06127002026/09/01 04:02:002026/09/01 04:30:0094.35349-1910.86671N>NIL_LSDUN_NIL_TE_B94.35349-1910000
20260901011NSW1-QLD1010-899.89063-93576.10822002026/09/01 04:02:002026/09/01 04:30:00851.75839-1207.622880.84764N::Q_BWMP_TNTQ^^N_NIL_SRAR2204-24780000
20260901011T-V-MNSP1010-375.39844-394.9487.40234002026/09/01 04:02:002026/09/01 04:30:00100.78928-394.943890.94613V>>NIL_SMTX_SMTX_R5F_T++NIL_CHWF_TG_R6630-4780000
20260901011V-S-MNSP1010-0.300002026/09/01 04:02:002026/09/01 04:30:00000.96832VSML_ZEROSVML_ZERO00-12.23183520002
20260901011V-SA010-547.46484-630.4932346.29338002026/09/01 04:02:002026/09/01 04:30:00108.03158-681.570640.86496V::N_NIL_V2I_6F_SN_1501050-10500000
20260901011VIC1-NSW1010980.171081007.06751105.35021002026/09/01 04:02:002026/09/01 04:30:001007.06751-119.417791.20702V^^N_NIL_1N^^V_MLNK_ARWBBA2399-2299-63.68100
20260901021V-S-MNSP10100.5999900002026/09/01 04:32:002026/09/01 05:00:00-0.0000200.96832V^^N_NIL_1SVML_ZERO-0.000020-12.89183520002
20260901021N-Q-MNSP1010-48.99951-494.46807002026/09/01 04:32:002026/09/01 05:00:0096.01511-1920.83836N>NIL_LSDUN_NIL_TE_B96.01511-1920000
20260901021NSW1-QLD1010-989.09375-991.4083984.4827002026/09/01 04:32:002026/09/01 05:00:00844.6522-1230.40590.83823N::Q_BWMP_TNTQ^^N_NIL_SRAR2204-24780000
20260901021T-V-MNSP1010-402.89844-397.4147.50775002026/09/01 04:32:002026/09/01 05:00:00105.91855-397.411010.94621V>>NIL_SMTX_SMTX_R5F_T++NIL_WF_TG_R60630-4780000
20260901021V-SA010-709.58203-643.8600849.62309002026/09/01 04:32:002026/09/01 05:00:00-55.96902-7000.85957V::N_NIL_V2S:V_700_HY_TEST1050-10500000
...

CSETP.WORLDDVD_PREDISPATCHINTERCONNECTORRESAEMOPUBLIC2026/10/0916:27:01001791527221486MONTHLY_ARCHIVE001791527221486
IPREDISPATCHINTERCONNECTOR_SOLN3PREDISPATCHSEQNORUNNOINTERCONNECTORIDPERIODIDINTERVENTIONMETEREDMWFLOWMWFLOWMWLOSSESMARGINALVALUEVIOLATIONDEGREELASTCHANGEDDATETIMEEXPORTLIMITIMPORTLIMITMARGINALLOSSEXPORTGENCONIDIMPORTGENCONIDFCASEXPORTLIMITFCASIMPORTLIMITLOCAL_PRICE_ADJUSTMENT_EXPORTLOCALLY_CONSTRAINED_EXPORTLOCAL_PRICE_ADJUSTMENT_IMPORTLOCALLY_CONSTRAINED_IMPORT
DPREDISPATCHINTERCONNECTOR_SOLN320260901011N-Q-MNSP1010-39.99951-413.06127002026/09/01 04:02:002026/09/01 04:30:0094.35349-1910.86671N>NIL_LSDUN_NIL_TE_B94.35349-1910000
DPREDISPATCHINTERCONNECTOR_SOLN320260901011NSW1-QLD1010-899.89063-93576.10822002026/09/01 04:02:002026/09/01 04:30:00851.75839-1207.622880.84764N::Q_BWMP_TNTQ^^N_NIL_SRAR2204-24780000
DPREDISPATCHINTERCONNECTOR_SOLN320260901011T-V-MNSP1010-375.39844-394.9487.40234002026/09/01 04:02:002026/09/01 04:30:00100.78928-394.943890.94613V>>NIL_SMTX_SMTX_R5F_T++NIL_CHWF_TG_R6630-4780000
DPREDISPATCHINTERCONNECTOR_SOLN320260901011V-S-MNSP1010-0.300002026/09/01 04:02:002026/09/01 04:30:00000.96832VSML_ZEROSVML_ZERO00-12.23183520002
DPREDISPATCHINTERCONNECTOR_SOLN320260901011V-SA010-547.46484-630.4932346.29338002026/09/01 04:02:002026/09/01 04:30:00108.03158-681.570640.86496V::N_NIL_V2I_6F_SN_1501050-10500000
DPREDISPATCHINTERCONNECTOR_SOLN320260901011VIC1-NSW1010980.171081007.06751105.35021002026/09/01 04:02:002026/09/01 04:30:001007.06751-119.417791.20702V^^N_NIL_1N^^V_MLNK_ARWBBA2399-2299-63.68100
DPREDISPATCHINTERCONNECTOR_SOLN320260901021V-S-MNSP10100.5999900002026/09/01 04:32:002026/09/01 05:00:00-0.0000200.96832V^^N_NIL_1SVML_ZERO-0.000020-12.89183520002
DPREDISPATCHINTERCONNECTOR_SOLN320260901021N-Q-MNSP1010-48.99951-494.46807002026/09/01 04:32:002026/09/01 05:00:0096.01511-1920.83836N>NIL_LSDUN_NIL_TE_B96.01511-1920000
DPREDISPATCHINTERCONNECTOR_SOLN320260901021NSW1-QLD1010-989.09375-991.4083984.4827002026/09/01 04:32:002026/09/01 05:00:00844.6522-1230.40590.83823N::Q_BWMP_TNTQ^^N_NIL_SRAR2204-24780000
DPREDISPATCHINTERCONNECTOR_SOLN320260901021T-V-MNSP1010-402.89844-397.4147.50775002026/09/01 04:32:002026/09/01 05:00:00105.91855-397.411010.94621V>>NIL_SMTX_SMTX_R5F_T++NIL_WF_TG_R60630-4780000
DPREDISPATCHINTERCONNECTOR_SOLN320260901021V-SA010-709.58203-643.8600849.62309002026/09/01 04:32:002026/09/01 05:00:00-55.96902-7000.85957V::N_NIL_V2S:V_700_HY_TEST1050-10500000
...
CEND OF REPORT1003

PREDISPATCHSEQNO,RUNNO,INTERCONNECTORID,PERIODID,INTERVENTION,METEREDMWFLOW,MWFLOW,MWLOSSES,MARGINALVALUE,VIOLATIONDEGREE,LASTCHANGED,DATETIME,EXPORTLIMIT,IMPORTLIMIT,MARGINALLOSS,EXPORTGENCONID,IMPORTGENCONID,FCASEXPORTLIMIT,FCASIMPORTLIMIT,LOCAL_PRICE_ADJUSTMENT_EXPORT,LOCALLY_CONSTRAINED_EXPORT,LOCAL_PRICE_ADJUSTMENT_IMPORT,LOCALLY_CONSTRAINED_IMPORT
2026090101,1,N-Q-MNSP1,01,0,-39.99951,-41,3.06127,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",94.35349,-191,0.86671,N>NIL_LSDU,N_NIL_TE_B,94.35349,-191,0,0,0,0
2026090101,1,NSW1-QLD1,01,0,-899.89063,-935,76.10822,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",851.75839,-1207.62288,0.84764,N::Q_BWMP_TNT,Q^^N_NIL_SRAR,2204,-2478,0,0,0,0
2026090101,1,T-V-MNSP1,01,0,-375.39844,-394.948,7.40234,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",100.78928,-394.94389,0.94613,V>>NIL_SMTX_SMTX_R5,F_T++NIL_CHWF_TG_R6,630,-478,0,0,0,0
2026090101,1,V-S-MNSP1,01,0,-0.3,0,0,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0.96832,VSML_ZERO,SVML_ZERO,0,0,-12.23,1,8352000,2
2026090101,1,V-SA,01,0,-547.46484,-630.49323,46.29338,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",108.03158,-681.57064,0.86496,V::N_NIL_V2,I_6F_SN_150,1050,-1050,0,0,0,0
2026090101,1,VIC1-NSW1,01,0,980.17108,1007.06751,105.35021,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",1007.06751,-119.41779,1.20702,V^^N_NIL_1,N^^V_MLNK_ARWBBA,2399,-2299,-63.68,1,0,0
2026090102,1,V-S-MNSP1,01,0,0.59999,0,0,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",-0.00002,0,0.96832,V^^N_NIL_1,SVML_ZERO,-0.00002,0,-12.89,1,8352000,2
2026090102,1,N-Q-MNSP1,01,0,-48.99951,-49,4.46807,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",96.01511,-192,0.83836,N>NIL_LSDU,N_NIL_TE_B,96.01511,-192,0,0,0,0
2026090102,1,NSW1-QLD1,01,0,-989.09375,-991.40839,84.4827,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",844.6522,-1230.4059,0.83823,N::Q_BWMP_TNT,Q^^N_NIL_SRAR,2204,-2478,0,0,0,0
2026090102,1,T-V-MNSP1,01,0,-402.89844,-397.414,7.50775,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",105.91855,-397.41101,0.94621,V>>NIL_SMTX_SMTX_R5,F_T++NIL_WF_TG_R60,630,-478,0,0,0,0
2026090102,1,V-SA,01,0,-709.58203,-643.86008,49.62309,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",-55.96902,-700,0.85957,V::N_NIL_V2,S:V_700_HY_TEST,1050,-1050,0,0,0,0
...

C,SETP.WORLD,DVD_PREDISPATCHINTERCONNECTORRES,AEMO,PUBLIC,2026/10/09,16:27:01,001791527221486,MONTHLY_ARCHIVE,001791527221486
I,PREDISPATCH,INTERCONNECTOR_SOLN,3,PREDISPATCHSEQNO,RUNNO,INTERCONNECTORID,PERIODID,INTERVENTION,METEREDMWFLOW,MWFLOW,MWLOSSES,MARGINALVALUE,VIOLATIONDEGREE,LASTCHANGED,DATETIME,EXPORTLIMIT,IMPORTLIMIT,MARGINALLOSS,EXPORTGENCONID,IMPORTGENCONID,FCASEXPORTLIMIT,FCASIMPORTLIMIT,LOCAL_PRICE_ADJUSTMENT_EXPORT,LOCALLY_CONSTRAINED_EXPORT,LOCAL_PRICE_ADJUSTMENT_IMPORT,LOCALLY_CONSTRAINED_IMPORT
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090101,1,N-Q-MNSP1,01,0,-39.99951,-41,3.06127,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",94.35349,-191,0.86671,N>NIL_LSDU,N_NIL_TE_B,94.35349,-191,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090101,1,NSW1-QLD1,01,0,-899.89063,-935,76.10822,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",851.75839,-1207.62288,0.84764,N::Q_BWMP_TNT,Q^^N_NIL_SRAR,2204,-2478,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090101,1,T-V-MNSP1,01,0,-375.39844,-394.948,7.40234,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",100.78928,-394.94389,0.94613,V>>NIL_SMTX_SMTX_R5,F_T++NIL_CHWF_TG_R6,630,-478,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090101,1,V-S-MNSP1,01,0,-0.3,0,0,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",0,0,0.96832,VSML_ZERO,SVML_ZERO,0,0,-12.23,1,8352000,2
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090101,1,V-SA,01,0,-547.46484,-630.49323,46.29338,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",108.03158,-681.57064,0.86496,V::N_NIL_V2,I_6F_SN_150,1050,-1050,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090101,1,VIC1-NSW1,01,0,980.17108,1007.06751,105.35021,0,0,"2026/09/01 04:02:00","2026/09/01 04:30:00",1007.06751,-119.41779,1.20702,V^^N_NIL_1,N^^V_MLNK_ARWBBA,2399,-2299,-63.68,1,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090102,1,V-S-MNSP1,01,0,0.59999,0,0,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",-0.00002,0,0.96832,V^^N_NIL_1,SVML_ZERO,-0.00002,0,-12.89,1,8352000,2
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090102,1,N-Q-MNSP1,01,0,-48.99951,-49,4.46807,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",96.01511,-192,0.83836,N>NIL_LSDU,N_NIL_TE_B,96.01511,-192,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090102,1,NSW1-QLD1,01,0,-989.09375,-991.40839,84.4827,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",844.6522,-1230.4059,0.83823,N::Q_BWMP_TNT,Q^^N_NIL_SRAR,2204,-2478,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090102,1,T-V-MNSP1,01,0,-402.89844,-397.414,7.50775,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",105.91855,-397.41101,0.94621,V>>NIL_SMTX_SMTX_R5,F_T++NIL_WF_TG_R60,630,-478,0,0,0,0
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,2026090102,1,V-SA,01,0,-709.58203,-643.86008,49.62309,0,0,"2026/09/01 04:32:00","2026/09/01 05:00:00",-55.96902,-700,0.85957,V::N_NIL_V2,S:V_700_HY_TEST,1050,-1050,0,0,0,0
...
C,"END OF REPORT",1003

Availability

Visibility: Public

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 4 MB when zipped, 39 MB 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 INTERCONNECTOR_SOLN 3

This means that the CSV files start with metadata columns:

I,PREDISPATCH,INTERCONNECTOR_SOLN,3,...
D,PREDISPATCH,INTERCONNECTOR_SOLN,3,...

ROW_FILTER_TYPE is LASTCHANGED

Indexes

There is more than one index.

Index 1:

Index 2:

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

Download a JSON Schema specification for this table.

Official AEMO schema documentation

Other Information

Package: PRE_DISPATCH