MTPASA_INTERCONNECTORRESULT

Interconnector results for interval of max demand per day

MTPASA_INTERCONNECTORRESULT is public data.

Column Schema

DAY

Day this result is for

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

This column is mandatory, and a primary key.

Example: 2026/09/13 00:00:00

DEMAND_POE_TYPE

Demand POE type used. Value is POE10

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

This column is mandatory, and a primary key.

Example: POE10

INTERCONNECTORID

The unique identifier for the interconnector

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

This column is mandatory, and a primary key.

Examples:

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

RUN_DATETIME

Date processing of the run begins.

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

This column is mandatory, and a primary key.

Example: 2026/09/07 01:00:00

RUN_NO

Unique run id.

SQL Type: NUMBER(4) Polars Type: pl.Int16

This column is mandatory, and a primary key.

Example: 1177

RUNTYPE

Type of run. Always RELIABILITY

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

This column is mandatory, and a primary key.

Example: RELIABILITY

CALCULATEDEXPORTLIMIT

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit, averaged across iterations and reference years

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

This column is not mandatory.

Examples: -0.19, 1.51, 0, 710

CALCULATEDIMPORTLIMIT

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit, averaged across iterations and reference years

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

This column is not mandatory.

Examples: -40.97, 0, -150, -928

FLOW10

The 10th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW)

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

This column is not mandatory.

Examples: -1.93, 7.55, 0, -1078

FLOW50

The 50th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW)

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

This column is not mandatory.

Examples: -0.09, 1.66, 0, 350

FLOW90

The 90th percentile for flows, across iterations and reference years. Positive values indicate exporting, negative values indicate importing (MW)

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

This column is not mandatory.

Examples: -6.39, 5.49, 0, 833

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/08 12:29:02

PERIODID

Half hourly period reported, selected as period of maximum NEM scheduled demand (calculated as maximum of scheduled demands, averaged across iterations and reference years)

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

This column is not mandatory.

Examples: 37, 40

PROBABILITYOFBINDINGEXPORT

Proportion of iterations and reference years with interconnector constrained when exporting

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

This column is not mandatory.

Examples: 0.16667, 0, 1, 100

PROBABILITYOFBINDINGIMPORT

Proportion of iterations and reference years with interconnector constrained when importing

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

This column is not mandatory.

Examples: 0.16667, 0, 1, 100

New Data Timing

On MTPASA solution published to the market (usually weekly)

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("DAY", "RUN_DATETIME", "LASTCHANGED").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
    )
    .cast(
        {
            "DEMAND_POE_TYPE": pl.Categorical,
            "INTERCONNECTORID": pl.Categorical,
            "RUN_NO": int,  # or pl.Int16
            "RUNTYPE": pl.Categorical,
            "CALCULATEDEXPORTLIMIT": pl.Float64,
            "CALCULATEDIMPORTLIMIT": pl.Float64,
            "FLOW10": pl.Float64,
            "FLOW50": pl.Float64,
            "FLOW90": pl.Float64,
            "PERIODID": int,  # or pl.Int16
            "PROBABILITYOFBINDINGEXPORT": pl.Float64,
            "PROBABILITYOFBINDINGIMPORT": pl.Float64,
        }
    )
    # Deduplicate
    # We want one row per ['DAY', 'DEMAND_POE_TYPE', 'INTERCONNECTORID', 'RUN_DATETIME', 'RUN_NO', 'RUNTYPE']
    # Tie-breaker: greatest value of LASTCHANGED
    .sort(LASTCHANGED, descending=False)
    .unique(
        subset=[
            "DAY",
            "DEMAND_POE_TYPE",
            "INTERCONNECTORID",
            "RUN_DATETIME",
            "RUN_NO",
            "RUNTYPE",
        ],
        keep="last",
    )
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_MTPASA_INTERCONNECTORRESULT_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

RUN_DATETIME	RUN_NO	RUNTYPE	DEMAND_POE_TYPE	DAY	INTERCONNECTORID	PERIODID	FLOW90	FLOW50	FLOW10	PROBABILITYOFBINDINGEXPORT	PROBABILITYOFBINDINGIMPORT	CALCULATEDEXPORTLIMIT	CALCULATEDIMPORTLIMIT	LASTCHANGED
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	N-Q-MNSP1	37	-17.6	-17.6	-52.8	12.83333	11.5	46.32	-176.55	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	NSW1-QLD1	37	19.07	-605.2	-1096.51	0	11.5	551.59	-1210.64	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	NSW1-SA1	37	0	0	0	0	0	0	0	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	T-V-MNSP1	37	456	216.96	-122.17	18.5	41	455.59	-247.44	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	V-S-MNSP1	37	165	18	-124.35	55	13.83333	84.94	-121.37	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	V-SA	37	619.79	189.31	-367.96	56.16667	3	311.58	-620.87	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	VIC1-NSW1	37	519.8	146.87	-587.69	45.5	9	293.2	-654.73	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	N-Q-MNSP1	37	-17.6	-17.6	-52.8	14.5	5.66667	41.79	-183.72	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	NSW1-QLD1	37	-293.07	-917.33	-1078	0	24.5	735.87	-1061.33	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	NSW1-SA1	37	0	0	0	0	0	0	0	2026/09/08 12:29:02
2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	T-V-MNSP1	37	456	168.07	-239.65	17.66667	52.16667	441.53	-217.45	2026/09/08 12:29:02
...

C	SETP.WORLD	DVD_MTPASA_INTERCONNECTORRESULT	AEMO	PUBLIC	2026/10/09	15:55:12	001791525312929	MONTHLY_ARCHIVE	001791525312929
I	MTPASA	INTERCONNECTORRESULT	1	RUN_DATETIME	RUN_NO	RUNTYPE	DEMAND_POE_TYPE	DAY	INTERCONNECTORID	PERIODID	FLOW90	FLOW50	FLOW10	PROBABILITYOFBINDINGEXPORT	PROBABILITYOFBINDINGIMPORT	CALCULATEDEXPORTLIMIT	CALCULATEDIMPORTLIMIT	LASTCHANGED
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	N-Q-MNSP1	37	-17.6	-17.6	-52.8	12.83333	11.5	46.32	-176.55	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	NSW1-QLD1	37	19.07	-605.2	-1096.51	0	11.5	551.59	-1210.64	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	NSW1-SA1	37	0	0	0	0	0	0	0	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	T-V-MNSP1	37	456	216.96	-122.17	18.5	41	455.59	-247.44	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	V-S-MNSP1	37	165	18	-124.35	55	13.83333	84.94	-121.37	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	V-SA	37	619.79	189.31	-367.96	56.16667	3	311.58	-620.87	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/13 00:00:00	VIC1-NSW1	37	519.8	146.87	-587.69	45.5	9	293.2	-654.73	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	N-Q-MNSP1	37	-17.6	-17.6	-52.8	14.5	5.66667	41.79	-183.72	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	NSW1-QLD1	37	-293.07	-917.33	-1078	0	24.5	735.87	-1061.33	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	NSW1-SA1	37	0	0	0	0	0	0	0	2026/09/08 12:29:02
D	MTPASA	INTERCONNECTORRESULT	1	2026/09/07 01:00:00	1177	RELIABILITY	POE10	2026/09/14 00:00:00	T-V-MNSP1	37	456	168.07	-239.65	17.66667	52.16667	441.53	-217.45	2026/09/08 12:29:02
...
C	END OF REPORT	1003

RUN_DATETIME,RUN_NO,RUNTYPE,DEMAND_POE_TYPE,DAY,INTERCONNECTORID,PERIODID,FLOW90,FLOW50,FLOW10,PROBABILITYOFBINDINGEXPORT,PROBABILITYOFBINDINGIMPORT,CALCULATEDEXPORTLIMIT,CALCULATEDIMPORTLIMIT,LASTCHANGED
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",N-Q-MNSP1,37,-17.6,-17.6,-52.8,12.83333,11.5,46.32,-176.55,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",NSW1-QLD1,37,19.07,-605.2,-1096.51,0,11.5,551.59,-1210.64,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",NSW1-SA1,37,0,0,0,0,0,0,0,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",T-V-MNSP1,37,456,216.96,-122.17,18.5,41,455.59,-247.44,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",V-S-MNSP1,37,165,18,-124.35,55,13.83333,84.94,-121.37,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",V-SA,37,619.79,189.31,-367.96,56.16667,3,311.58,-620.87,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",VIC1-NSW1,37,519.8,146.87,-587.69,45.5,9,293.2,-654.73,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",N-Q-MNSP1,37,-17.6,-17.6,-52.8,14.5,5.66667,41.79,-183.72,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",NSW1-QLD1,37,-293.07,-917.33,-1078,0,24.5,735.87,-1061.33,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",NSW1-SA1,37,0,0,0,0,0,0,0,"2026/09/08 12:29:02"
"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",T-V-MNSP1,37,456,168.07,-239.65,17.66667,52.16667,441.53,-217.45,"2026/09/08 12:29:02"
...

Raw Text with Metadata

C,SETP.WORLD,DVD_MTPASA_INTERCONNECTORRESULT,AEMO,PUBLIC,2026/10/09,15:55:12,001791525312929,MONTHLY_ARCHIVE,001791525312929
I,MTPASA,INTERCONNECTORRESULT,1,RUN_DATETIME,RUN_NO,RUNTYPE,DEMAND_POE_TYPE,DAY,INTERCONNECTORID,PERIODID,FLOW90,FLOW50,FLOW10,PROBABILITYOFBINDINGEXPORT,PROBABILITYOFBINDINGIMPORT,CALCULATEDEXPORTLIMIT,CALCULATEDIMPORTLIMIT,LASTCHANGED
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",N-Q-MNSP1,37,-17.6,-17.6,-52.8,12.83333,11.5,46.32,-176.55,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",NSW1-QLD1,37,19.07,-605.2,-1096.51,0,11.5,551.59,-1210.64,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",NSW1-SA1,37,0,0,0,0,0,0,0,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",T-V-MNSP1,37,456,216.96,-122.17,18.5,41,455.59,-247.44,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",V-S-MNSP1,37,165,18,-124.35,55,13.83333,84.94,-121.37,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",V-SA,37,619.79,189.31,-367.96,56.16667,3,311.58,-620.87,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/13 00:00:00",VIC1-NSW1,37,519.8,146.87,-587.69,45.5,9,293.2,-654.73,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",N-Q-MNSP1,37,-17.6,-17.6,-52.8,14.5,5.66667,41.79,-183.72,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",NSW1-QLD1,37,-293.07,-917.33,-1078,0,24.5,735.87,-1061.33,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",NSW1-SA1,37,0,0,0,0,0,0,0,"2026/09/08 12:29:02"
D,MTPASA,INTERCONNECTORRESULT,1,"2026/09/07 01:00:00",1177,RELIABILITY,POE10,"2026/09/14 00:00:00",T-V-MNSP1,37,456,168.07,-239.65,17.66667,52.16667,441.53,-217.45,"2026/09/08 12:29:02"
...
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 5 of 2018. 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 5 MB when zipped, 47 MB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

DAY
DEMAND_POE_TYPE
INTERCONNECTORID
RUN_DATETIME
RUN_NO
RUNTYPE

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
MTPASA	INTERCONNECTORRESULT	1

This means that the CSV files start with metadata columns:

I,MTPASA,INTERCONNECTORRESULT,1,...
D,MTPASA,INTERCONNECTORRESULT,1,...

Links

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