Skip to content

PDPASA_INTERCONNECTORSOLN

PDPASA_INTERCONNECTORSOLN shows the results of the capacity evaluation for Interconnectors, including the calculated limits for the interval.

Column Schema

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

INTERVAL_DATETIME

The unique identifier for the interval within this study

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

This column is mandatory, and a primary key.

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

RUN_DATETIME

Unique Timestamp Identifier for this study

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

This column is mandatory, and a primary key.

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

RUNTYPE

Type of run. Values are OUTAGE_LRC and LOR. Note that the PDPASA OUTAGE_LRC Run Type is discontinued from 31 July 2025, with only the LOR Run Type reported.

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

This column is mandatory, and a primary key.

Example: LOR

STUDYREGIONID

Primary Region for LP Solve (or MARKET if none).

SQL Type: VARCHAR2(20) Polars Type: str

This column is mandatory, and a primary key.

Examples:

  • NSW1
  • QLD1
  • SA1
  • TAS1
  • VIC1

CALCULATEDEXPORTLIMIT

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit

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

This column is not mandatory.

Examples: -27.99, 0.59, 0, 1752

CALCULATEDIMPORTLIMIT

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow.

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

This column is not mandatory.

Examples: -24.13, 45.76, 0, -1379

CAPACITYMARGINALVALUE

Capacity adequacy assessment marginal value, 0 if not binding

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

This column is not mandatory.

Example: 0

CAPACITYMWFLOW

Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints

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

This column is not mandatory.

Examples: -14.95, 0.59, 0, -1379

CAPACITYVIOLATIONDEGREE

Capacity adequacy assessment violation degree for interconnector capacity; 0 if not violating

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

This column is not mandatory.

Example: 0

EXPORTLIMITCONSTRAINTID

ID of the constraint that sets the Interconnector Export Limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

  • I_6F_NS_150
  • I_6F_SN_150
  • N::Q_BWMP_LDTW
  • N::Q_BWMP_TNT
  • N>>NIL_39
  • N>>NIL_4
  • N>NIL_LSDU
  • N>Q-NIL_757_758
  • NQ_950_TEST
  • N^^N_NIL_1

IMPORTLIMITCONSTRAINTID

ID of the constraint that sets the Interconnector Import Limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

  • I_6F_NS_150
  • I_6F_SN_150
  • N:V_NIL_BYYS
  • N>>NIL_23_22
  • N>>NIL_39
  • N>>NIL_86_85_S
  • N>>NIL_8U_86_S
  • N>>NIL_964_84_S
  • N^^N_NIL_WGLT
  • N^^V_MLNK_1

LASTCHANGED

Last changed date of this record

For more information, see the dedicated documentation page.

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

This column is not mandatory.

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

New Data Timing

After each PDASA run (half-hourly)

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("INTERVAL_DATETIME", "RUN_DATETIME", "LASTCHANGED").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
    )
    .cast(
        {
            "INTERCONNECTORID": pl.Categorical,
            "RUNTYPE": pl.Categorical,
            "STUDYREGIONID": str,
            "CALCULATEDEXPORTLIMIT": pl.Float64,
            "CALCULATEDIMPORTLIMIT": pl.Float64,
            "CAPACITYMARGINALVALUE": pl.Float64,
            "CAPACITYMWFLOW": pl.Float64,
            "CAPACITYVIOLATIONDEGREE": pl.Float64,
            "EXPORTLIMITCONSTRAINTID": str,
            "IMPORTLIMITCONSTRAINTID": str,
        }
    )
    # Deduplicate
    # We want one row per ['INTERCONNECTORID', 'INTERVAL_DATETIME', 'RUN_DATETIME', 'RUNTYPE', 'STUDYREGIONID']
    # Tie-breaker: greatest value of LASTCHANGED
    .sort(LASTCHANGED, descending=False)
    .unique(
        subset=[
            "INTERCONNECTORID",
            "INTERVAL_DATETIME",
            "RUN_DATETIME",
            "RUNTYPE",
            "STUDYREGIONID",
        ],
        keep="last",
    )
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_PDPASA_INTERCONNECTORSOLN_FILE01_202609010000.zip

RUN_DATETIMEINTERVAL_DATETIMEINTERCONNECTORIDCAPACITYMWFLOWCAPACITYMARGINALVALUECAPACITYVIOLATIONDEGREECALCULATEDEXPORTLIMITCALCULATEDIMPORTLIMITLASTCHANGEDRUNTYPEEXPORTLIMITCONSTRAINTIDIMPORTLIMITCONSTRAINTIDSTUDYREGIONID
2026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP1-1980084.43-1982026/09/01 00:04:51LORN>NIL_LSDUN_NIL_TE_BNSW1
2026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP184.430084.43-1982026/09/01 00:04:51LORN::Q_BWMP_LDTWN_NIL_TE_BQLD1
2026/09/01 00:30:002026/09/01 00:30:00NSW1-QLD1-1292.4800950-1292.482026/09/01 00:04:51LORNQ_950_TESTQ^^N_NIL_SRARNSW1
2026/09/01 00:30:002026/09/01 00:30:00NSW1-QLD1803.6500803.65-1063.322026/09/01 00:04:51LORN::Q_BWMP_LDTWQ^^N_NIL_SRARQLD1
2026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1363.700363.7-427.272026/09/01 00:04:51LORT^V_NIL_9V::N_NIL_V2NSW1
2026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1363.700363.7-4412026/09/01 00:04:51LORT^V_NIL_9VTBL_NIL_CONT_441QLD1
2026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1-44100363.7-4412026/09/01 00:04:51LORT^V_NIL_9VTBL_NIL_CONT_441TAS1
2026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP100084.43-1982026/09/01 00:04:51LORN>NIL_LSDUN_NIL_TE_BSA1
2026/09/01 00:30:002026/09/01 00:30:00NSW1-QLD1000880.46-1063.322026/09/01 00:04:51LORN::Q_BWMP_LDTWQ^^N_NIL_SRARSA1
2026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1363.700363.7-4412026/09/01 00:04:51LORT^V_NIL_9VTBL_NIL_CONT_441SA1
2026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP100084.43-1982026/09/01 00:04:51LORN>NIL_LSDUN_NIL_TE_BTAS1
...

CSETP.WORLDDVD_PDPASA_INTERCONNECTORSOLNAEMOPUBLIC2026/10/0916:23:03001791526983326MONTHLY_ARCHIVE001791526983326
IPDPASAINTERCONNECTORSOLN1RUN_DATETIMEINTERVAL_DATETIMEINTERCONNECTORIDCAPACITYMWFLOWCAPACITYMARGINALVALUECAPACITYVIOLATIONDEGREECALCULATEDEXPORTLIMITCALCULATEDIMPORTLIMITLASTCHANGEDRUNTYPEEXPORTLIMITCONSTRAINTIDIMPORTLIMITCONSTRAINTIDSTUDYREGIONID
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP1-1980084.43-1982026/09/01 00:04:51LORN>NIL_LSDUN_NIL_TE_BNSW1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP184.430084.43-1982026/09/01 00:04:51LORN::Q_BWMP_LDTWN_NIL_TE_BQLD1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00NSW1-QLD1-1292.4800950-1292.482026/09/01 00:04:51LORNQ_950_TESTQ^^N_NIL_SRARNSW1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00NSW1-QLD1803.6500803.65-1063.322026/09/01 00:04:51LORN::Q_BWMP_LDTWQ^^N_NIL_SRARQLD1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1363.700363.7-427.272026/09/01 00:04:51LORT^V_NIL_9V::N_NIL_V2NSW1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1363.700363.7-4412026/09/01 00:04:51LORT^V_NIL_9VTBL_NIL_CONT_441QLD1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1-44100363.7-4412026/09/01 00:04:51LORT^V_NIL_9VTBL_NIL_CONT_441TAS1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP100084.43-1982026/09/01 00:04:51LORN>NIL_LSDUN_NIL_TE_BSA1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00NSW1-QLD1000880.46-1063.322026/09/01 00:04:51LORN::Q_BWMP_LDTWQ^^N_NIL_SRARSA1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00T-V-MNSP1363.700363.7-4412026/09/01 00:04:51LORT^V_NIL_9VTBL_NIL_CONT_441SA1
DPDPASAINTERCONNECTORSOLN12026/09/01 00:30:002026/09/01 00:30:00N-Q-MNSP100084.43-1982026/09/01 00:04:51LORN>NIL_LSDUN_NIL_TE_BTAS1
...
CEND OF REPORT1003

RUN_DATETIME,INTERVAL_DATETIME,INTERCONNECTORID,CAPACITYMWFLOW,CAPACITYMARGINALVALUE,CAPACITYVIOLATIONDEGREE,CALCULATEDEXPORTLIMIT,CALCULATEDIMPORTLIMIT,LASTCHANGED,RUNTYPE,EXPORTLIMITCONSTRAINTID,IMPORTLIMITCONSTRAINTID,STUDYREGIONID
"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,-198,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N>NIL_LSDU,N_NIL_TE_B,NSW1
"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,84.43,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N::Q_BWMP_LDTW,N_NIL_TE_B,QLD1
"2026/09/01 00:30:00","2026/09/01 00:30:00",NSW1-QLD1,-1292.48,0,0,950,-1292.48,"2026/09/01 00:04:51",LOR,NQ_950_TEST,Q^^N_NIL_SRAR,NSW1
"2026/09/01 00:30:00","2026/09/01 00:30:00",NSW1-QLD1,803.65,0,0,803.65,-1063.32,"2026/09/01 00:04:51",LOR,N::Q_BWMP_LDTW,Q^^N_NIL_SRAR,QLD1
"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,363.7,0,0,363.7,-427.27,"2026/09/01 00:04:51",LOR,T^V_NIL_9,V::N_NIL_V2,NSW1
"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,363.7,0,0,363.7,-441,"2026/09/01 00:04:51",LOR,T^V_NIL_9,VTBL_NIL_CONT_441,QLD1
"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,-441,0,0,363.7,-441,"2026/09/01 00:04:51",LOR,T^V_NIL_9,VTBL_NIL_CONT_441,TAS1
"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,0,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N>NIL_LSDU,N_NIL_TE_B,SA1
"2026/09/01 00:30:00","2026/09/01 00:30:00",NSW1-QLD1,0,0,0,880.46,-1063.32,"2026/09/01 00:04:51",LOR,N::Q_BWMP_LDTW,Q^^N_NIL_SRAR,SA1
"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,363.7,0,0,363.7,-441,"2026/09/01 00:04:51",LOR,T^V_NIL_9,VTBL_NIL_CONT_441,SA1
"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,0,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N>NIL_LSDU,N_NIL_TE_B,TAS1
...

C,SETP.WORLD,DVD_PDPASA_INTERCONNECTORSOLN,AEMO,PUBLIC,2026/10/09,16:23:03,001791526983326,MONTHLY_ARCHIVE,001791526983326
I,PDPASA,INTERCONNECTORSOLN,1,RUN_DATETIME,INTERVAL_DATETIME,INTERCONNECTORID,CAPACITYMWFLOW,CAPACITYMARGINALVALUE,CAPACITYVIOLATIONDEGREE,CALCULATEDEXPORTLIMIT,CALCULATEDIMPORTLIMIT,LASTCHANGED,RUNTYPE,EXPORTLIMITCONSTRAINTID,IMPORTLIMITCONSTRAINTID,STUDYREGIONID
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,-198,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N>NIL_LSDU,N_NIL_TE_B,NSW1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,84.43,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N::Q_BWMP_LDTW,N_NIL_TE_B,QLD1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",NSW1-QLD1,-1292.48,0,0,950,-1292.48,"2026/09/01 00:04:51",LOR,NQ_950_TEST,Q^^N_NIL_SRAR,NSW1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",NSW1-QLD1,803.65,0,0,803.65,-1063.32,"2026/09/01 00:04:51",LOR,N::Q_BWMP_LDTW,Q^^N_NIL_SRAR,QLD1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,363.7,0,0,363.7,-427.27,"2026/09/01 00:04:51",LOR,T^V_NIL_9,V::N_NIL_V2,NSW1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,363.7,0,0,363.7,-441,"2026/09/01 00:04:51",LOR,T^V_NIL_9,VTBL_NIL_CONT_441,QLD1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,-441,0,0,363.7,-441,"2026/09/01 00:04:51",LOR,T^V_NIL_9,VTBL_NIL_CONT_441,TAS1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,0,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N>NIL_LSDU,N_NIL_TE_B,SA1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",NSW1-QLD1,0,0,0,880.46,-1063.32,"2026/09/01 00:04:51",LOR,N::Q_BWMP_LDTW,Q^^N_NIL_SRAR,SA1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",T-V-MNSP1,363.7,0,0,363.7,-441,"2026/09/01 00:04:51",LOR,T^V_NIL_9,VTBL_NIL_CONT_441,SA1
D,PDPASA,INTERCONNECTORSOLN,1,"2026/09/01 00:30:00","2026/09/01 00:30:00",N-Q-MNSP1,0,0,0,84.43,-198,"2026/09/01 00:04:51",LOR,N>NIL_LSDU,N_NIL_TE_B,TAS1
...
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 2 of 2021. 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 308 MB when zipped, 3 GB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

The transaction type is "insert", which means that you will usually not see duplicate data. If you do, you can deduplicate based on the primary keys, without sorting first. Rows from different files with the same primary keys should have the same values.

PDR Loader configuration is:

Report Name Report Subtype Version
PDPASA INTERCONNECTORSOLN 1

This means that the CSV files start with metadata columns:

I,PDPASA,INTERCONNECTORSOLN,1,...
D,PDPASA,INTERCONNECTORSOLN,1,...

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