PD7DAY_INTERCONNECTORSOLUTION

PD7DAY intereconnector solution

Column Schema

INTERCONNECTORID

Interconnector identifier

SQL Type: VARCHAR2(20) 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 07:30:00

INTERVENTION

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

For more information, see the dedicated documentation page.

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

This column is mandatory, and a primary key.

Example: 0

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 07:30:00

EXPORTCONSTRAINTID

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_LSDU
N>Q-NIL_757_758
NQ_950_TEST
N^^N_NIL_WGLT
S>>NIL_RBTU_RBTU
S>>NIL_RBTU_WEWT

EXPORTLIMIT

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

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

This column is not mandatory.

Examples: -0.00001, 0.50135, 0, 950

FCASEXPORTLIMIT

Calculated export limit applying to energy + Frequency Controlled Ancillary Services.

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

This column is not mandatory.

Examples: -0.00001, 44.98731, 0, 2399

FCASIMPORTLIMIT

Calculated import limit applying to energy + Frequency Controlled Ancillary Services.

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

This column is not mandatory.

Examples: -21.05416, 0.00001, 0, -2478

IMPORTCONSTRAINTID

Generic Constraint setting the import limit

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Examples:

F_MAIN++APD_TL_L5
F_MAIN++APD_TL_L60
F_Q++NIL_R1
F_Q++NIL_R5
F_Q++NIL_R6
F_Q++NIL_R60
F_T++NIL_CHWF_TG_R6
F_T++NIL_MRWF_TG_R6
F_T++NIL_WF_TG_R60
I_6F_NS_150

IMPORTLIMIT

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(15,5) Polars Type: pl.Float64

This column is not mandatory.

Examples: -21.05416, 0.00001, 0, -1247

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 07:12:38

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.32, 0, -6, -26

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.33, 0, 23, 8352000

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 at the cleared flow

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

This column is not mandatory.

Examples: 0.42673, 1.59769

MARGINALVALUE

Marginal cost of Interconnector standing data limits (if binding)

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

This column is not mandatory.

Example: 0

METEREDMWFLOW

SCADA MW Flow measured at Run start. For periods subsequent to the first period of a PD7DAY run, this value represents the cleared target for the previous period of that PD7DAY run.

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

This column is not mandatory.

Examples: -2.991, 0.50134, 0, 391

MWFLOW

Cleared Interconnector loading level (MW)

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

This column is not mandatory.

Examples: -2.991, 0.50134, 0, 391

MWLOSSES

Interconnector Losses at cleared flow

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

This column is not mandatory.

Examples: -0.0055, 0.01123, 0, 132.15037

VIOLATIONDEGREE

Violation of Interconnector standing data limits

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

This column is not mandatory.

Example: 0

New Data Timing

Publishes few times per day

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
        ),
    )
    # Polars can't cast string straight to bool. Need to go via something else.
    .cast({"INTERVENTION": pl.UInt8})
    .cast(
        {
            "INTERCONNECTORID": pl.Categorical,
            "INTERVENTION": pl.Boolean,
            "EXPORTCONSTRAINTID": str,
            "EXPORTLIMIT": pl.Float64,
            "FCASEXPORTLIMIT": pl.Float64,
            "FCASIMPORTLIMIT": pl.Float64,
            "IMPORTCONSTRAINTID": str,
            "IMPORTLIMIT": pl.Float64,
            "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,
            "VIOLATIONDEGREE": pl.Float64,
        }
    )
    # Deduplicate
    # We want one row per ['INTERCONNECTORID', 'INTERVAL_DATETIME', 'INTERVENTION', 'RUN_DATETIME']
    # Tie-breaker: greatest value of LASTCHANGED
    .sort(LASTCHANGED, descending=False)
    .unique(
        subset=[
            "INTERCONNECTORID",
            "INTERVAL_DATETIME",
            "INTERVENTION",
            "RUN_DATETIME",
        ],
        keep="last",
    )
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_PD7DAY_INTERCONNECTORSOLUTION_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

RUN_DATETIME	INTERVENTION	INTERVAL_DATETIME	INTERCONNECTORID	METEREDMWFLOW	MWFLOW	MWLOSSES	MARGINALVALUE	VIOLATIONDEGREE	EXPORTLIMIT	IMPORTLIMIT	MARGINALLOSS	EXPORTCONSTRAINTID	IMPORTCONSTRAINTID	FCASEXPORTLIMIT	FCASIMPORTLIMIT	LOCAL_PRICE_ADJUSTMENT_EXPORT	LOCALLY_CONSTRAINED_EXPORT	LOCAL_PRICE_ADJUSTMENT_IMPORT	LOCALLY_CONSTRAINED_IMPORT	LASTCHANGED
2026/09/01 07:30:00	0	2026/09/01 07:30:00	N-Q-MNSP1	-57.29932	-41	3.06127	0	0	81.2374	-200	0.86671	N>NIL_LSDU	N_NIL_TE_B	81.2374	-200	0	0	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 07:30:00	NSW1-QLD1	-1214.1875	-1003	75.72373	0	0	750.29309	-1179	0.8472	N::Q_BWMP_LDTW	F_Q++NIL_R60	2204	-2478	0	0	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 07:30:00	T-V-MNSP1	-435.79688	-408.53132	7.37003	0	0	-408.53132	-408.53281	0.945	V>>SMF1_SMF2_NIL_R5	F_T++NIL_CHWF_TG_R6	630	-478	-32.34	2	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 07:30:00	V-S-MNSP1	0.89999	0	0	0	0	0	0	0.96832	VSML_ZERO	SVML_ZERO	0	0	-4.38	1	8352000	2	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 07:30:00	V-SA	-170.92871	-228.88598	7.93253	0	0	551.59623	-228.88597	0.94087	I_6F_NS_150	V>>SMF1_SMF2_NIL_R5	1050	-1050	0	0	22.29	2	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 07:30:00	VIC1-NSW1	355.22128	453.32978	20.83125	0	0	453.32978	-344.00304	1.08691	V>>SMF1_SMF2_NIL_R5	N^^V_MLNK_ARWBBA	2399	-2299	-41.24	2	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 08:00:00	N-Q-MNSP1	-41	-17	0.42679	0	0	86.74423	-194	0.95724	N>NIL_LSDU	N_NIL_TE_B	86.74423	-194	0	0	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 08:00:00	NSW1-QLD1	-1003	-457.55306	12.9879	0	0	595.44228	-1129.84184	0.93381	N::Q_BWMP_LDTW	N>>NIL_964_84_S	2204	-2478	0	0	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 08:00:00	T-V-MNSP1	-408.53132	-369.31	5.3111	0	0	331.3047	-380.84481	0.95373	T_V_NIL_FCSPS	F_T++NIL_CHWF_TG_R6	630	-478	0	0	0	0	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 08:00:00	V-S-MNSP1	0	0	0	0	0	0	0	0.96832	VSML_ZERO	SVML_ZERO	0	0	-2.75	1	8352020.21	2	2026/09/01 07:12:38
2026/09/01 07:30:00	0	2026/09/01 08:00:00	V-SA	-228.88598	-286.40354	11.48015	0	0	488.51717	-286.40355	0.93101	I_6F_NS_150	V>>BELML_BAML1_BAML2	1050	-1050	0	0	0.58	2	2026/09/01 07:12:38
...

C	SETP.WORLD	DVD_PD7DAY_INTERCONNECTORSOLUTION	AEMO	PUBLIC	2026/10/09	16:51:56	001791528716093	MONTHLY_ARCHIVE	001791528716093
I	PD7DAY	INTERCONNECTORSOLUTION	1	RUN_DATETIME	INTERVENTION	INTERVAL_DATETIME	INTERCONNECTORID	METEREDMWFLOW	MWFLOW	MWLOSSES	MARGINALVALUE	VIOLATIONDEGREE	EXPORTLIMIT	IMPORTLIMIT	MARGINALLOSS	EXPORTCONSTRAINTID	IMPORTCONSTRAINTID	FCASEXPORTLIMIT	FCASIMPORTLIMIT	LOCAL_PRICE_ADJUSTMENT_EXPORT	LOCALLY_CONSTRAINED_EXPORT	LOCAL_PRICE_ADJUSTMENT_IMPORT	LOCALLY_CONSTRAINED_IMPORT	LASTCHANGED
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 07:30:00	N-Q-MNSP1	-57.29932	-41	3.06127	0	0	81.2374	-200	0.86671	N>NIL_LSDU	N_NIL_TE_B	81.2374	-200	0	0	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 07:30:00	NSW1-QLD1	-1214.1875	-1003	75.72373	0	0	750.29309	-1179	0.8472	N::Q_BWMP_LDTW	F_Q++NIL_R60	2204	-2478	0	0	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 07:30:00	T-V-MNSP1	-435.79688	-408.53132	7.37003	0	0	-408.53132	-408.53281	0.945	V>>SMF1_SMF2_NIL_R5	F_T++NIL_CHWF_TG_R6	630	-478	-32.34	2	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 07:30:00	V-S-MNSP1	0.89999	0	0	0	0	0	0	0.96832	VSML_ZERO	SVML_ZERO	0	0	-4.38	1	8352000	2	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 07:30:00	V-SA	-170.92871	-228.88598	7.93253	0	0	551.59623	-228.88597	0.94087	I_6F_NS_150	V>>SMF1_SMF2_NIL_R5	1050	-1050	0	0	22.29	2	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 07:30:00	VIC1-NSW1	355.22128	453.32978	20.83125	0	0	453.32978	-344.00304	1.08691	V>>SMF1_SMF2_NIL_R5	N^^V_MLNK_ARWBBA	2399	-2299	-41.24	2	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 08:00:00	N-Q-MNSP1	-41	-17	0.42679	0	0	86.74423	-194	0.95724	N>NIL_LSDU	N_NIL_TE_B	86.74423	-194	0	0	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 08:00:00	NSW1-QLD1	-1003	-457.55306	12.9879	0	0	595.44228	-1129.84184	0.93381	N::Q_BWMP_LDTW	N>>NIL_964_84_S	2204	-2478	0	0	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 08:00:00	T-V-MNSP1	-408.53132	-369.31	5.3111	0	0	331.3047	-380.84481	0.95373	T_V_NIL_FCSPS	F_T++NIL_CHWF_TG_R6	630	-478	0	0	0	0	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 08:00:00	V-S-MNSP1	0	0	0	0	0	0	0	0.96832	VSML_ZERO	SVML_ZERO	0	0	-2.75	1	8352020.21	2	2026/09/01 07:12:38
D	PD7DAY	INTERCONNECTORSOLUTION	1	2026/09/01 07:30:00	0	2026/09/01 08:00:00	V-SA	-228.88598	-286.40354	11.48015	0	0	488.51717	-286.40355	0.93101	I_6F_NS_150	V>>BELML_BAML1_BAML2	1050	-1050	0	0	0.58	2	2026/09/01 07:12:38
...
C	END OF REPORT	1003

RUN_DATETIME,INTERVENTION,INTERVAL_DATETIME,INTERCONNECTORID,METEREDMWFLOW,MWFLOW,MWLOSSES,MARGINALVALUE,VIOLATIONDEGREE,EXPORTLIMIT,IMPORTLIMIT,MARGINALLOSS,EXPORTCONSTRAINTID,IMPORTCONSTRAINTID,FCASEXPORTLIMIT,FCASIMPORTLIMIT,LOCAL_PRICE_ADJUSTMENT_EXPORT,LOCALLY_CONSTRAINED_EXPORT,LOCAL_PRICE_ADJUSTMENT_IMPORT,LOCALLY_CONSTRAINED_IMPORT,LASTCHANGED
"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",N-Q-MNSP1,-57.29932,-41,3.06127,0,0,81.2374,-200,0.86671,N>NIL_LSDU,N_NIL_TE_B,81.2374,-200,0,0,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",NSW1-QLD1,-1214.1875,-1003,75.72373,0,0,750.29309,-1179,0.8472,N::Q_BWMP_LDTW,F_Q++NIL_R60,2204,-2478,0,0,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",T-V-MNSP1,-435.79688,-408.53132,7.37003,0,0,-408.53132,-408.53281,0.945,V>>SMF1_SMF2_NIL_R5,F_T++NIL_CHWF_TG_R6,630,-478,-32.34,2,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",V-S-MNSP1,0.89999,0,0,0,0,0,0,0.96832,VSML_ZERO,SVML_ZERO,0,0,-4.38,1,8352000,2,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",V-SA,-170.92871,-228.88598,7.93253,0,0,551.59623,-228.88597,0.94087,I_6F_NS_150,V>>SMF1_SMF2_NIL_R5,1050,-1050,0,0,22.29,2,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",VIC1-NSW1,355.22128,453.32978,20.83125,0,0,453.32978,-344.00304,1.08691,V>>SMF1_SMF2_NIL_R5,N^^V_MLNK_ARWBBA,2399,-2299,-41.24,2,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",N-Q-MNSP1,-41,-17,0.42679,0,0,86.74423,-194,0.95724,N>NIL_LSDU,N_NIL_TE_B,86.74423,-194,0,0,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",NSW1-QLD1,-1003,-457.55306,12.9879,0,0,595.44228,-1129.84184,0.93381,N::Q_BWMP_LDTW,N>>NIL_964_84_S,2204,-2478,0,0,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",T-V-MNSP1,-408.53132,-369.31,5.3111,0,0,331.3047,-380.84481,0.95373,T_V_NIL_FCSPS,F_T++NIL_CHWF_TG_R6,630,-478,0,0,0,0,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",V-S-MNSP1,0,0,0,0,0,0,0,0.96832,VSML_ZERO,SVML_ZERO,0,0,-2.75,1,8352020.21,2,"2026/09/01 07:12:38"
"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",V-SA,-228.88598,-286.40354,11.48015,0,0,488.51717,-286.40355,0.93101,I_6F_NS_150,V>>BELML_BAML1_BAML2,1050,-1050,0,0,0.58,2,"2026/09/01 07:12:38"
...

Raw Text with Metadata

C,SETP.WORLD,DVD_PD7DAY_INTERCONNECTORSOLUTION,AEMO,PUBLIC,2026/10/09,16:51:56,001791528716093,MONTHLY_ARCHIVE,001791528716093
I,PD7DAY,INTERCONNECTORSOLUTION,1,RUN_DATETIME,INTERVENTION,INTERVAL_DATETIME,INTERCONNECTORID,METEREDMWFLOW,MWFLOW,MWLOSSES,MARGINALVALUE,VIOLATIONDEGREE,EXPORTLIMIT,IMPORTLIMIT,MARGINALLOSS,EXPORTCONSTRAINTID,IMPORTCONSTRAINTID,FCASEXPORTLIMIT,FCASIMPORTLIMIT,LOCAL_PRICE_ADJUSTMENT_EXPORT,LOCALLY_CONSTRAINED_EXPORT,LOCAL_PRICE_ADJUSTMENT_IMPORT,LOCALLY_CONSTRAINED_IMPORT,LASTCHANGED
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",N-Q-MNSP1,-57.29932,-41,3.06127,0,0,81.2374,-200,0.86671,N>NIL_LSDU,N_NIL_TE_B,81.2374,-200,0,0,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",NSW1-QLD1,-1214.1875,-1003,75.72373,0,0,750.29309,-1179,0.8472,N::Q_BWMP_LDTW,F_Q++NIL_R60,2204,-2478,0,0,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",T-V-MNSP1,-435.79688,-408.53132,7.37003,0,0,-408.53132,-408.53281,0.945,V>>SMF1_SMF2_NIL_R5,F_T++NIL_CHWF_TG_R6,630,-478,-32.34,2,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",V-S-MNSP1,0.89999,0,0,0,0,0,0,0.96832,VSML_ZERO,SVML_ZERO,0,0,-4.38,1,8352000,2,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",V-SA,-170.92871,-228.88598,7.93253,0,0,551.59623,-228.88597,0.94087,I_6F_NS_150,V>>SMF1_SMF2_NIL_R5,1050,-1050,0,0,22.29,2,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 07:30:00",VIC1-NSW1,355.22128,453.32978,20.83125,0,0,453.32978,-344.00304,1.08691,V>>SMF1_SMF2_NIL_R5,N^^V_MLNK_ARWBBA,2399,-2299,-41.24,2,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",N-Q-MNSP1,-41,-17,0.42679,0,0,86.74423,-194,0.95724,N>NIL_LSDU,N_NIL_TE_B,86.74423,-194,0,0,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",NSW1-QLD1,-1003,-457.55306,12.9879,0,0,595.44228,-1129.84184,0.93381,N::Q_BWMP_LDTW,N>>NIL_964_84_S,2204,-2478,0,0,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",T-V-MNSP1,-408.53132,-369.31,5.3111,0,0,331.3047,-380.84481,0.95373,T_V_NIL_FCSPS,F_T++NIL_CHWF_TG_R6,630,-478,0,0,0,0,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",V-S-MNSP1,0,0,0,0,0,0,0,0.96832,VSML_ZERO,SVML_ZERO,0,0,-2.75,1,8352020.21,2,"2026/09/01 07:12:38"
D,PD7DAY,INTERCONNECTORSOLUTION,1,"2026/09/01 07:30:00",0,"2026/09/01 08:00:00",V-SA,-228.88598,-286.40354,11.48015,0,0,488.51717,-286.40355,0.93101,I_6F_NS_150,V>>BELML_BAML1_BAML2,1050,-1050,0,0,0.58,2,"2026/09/01 07:12:38"
...
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 8 of 2024. 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 74 MB when zipped, 744 MB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

INTERCONNECTORID
INTERVAL_DATETIME
INTERVENTION
RUN_DATETIME

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
PD7DAY	INTERCONNECTORSOLUTION	1

This means that the CSV files start with metadata columns:

I,PD7DAY,INTERCONNECTORSOLUTION,1,...
D,PD7DAY,INTERCONNECTORSOLUTION,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: PD7DAY