Skip to content

INTERCONNECTORCONSTRAINT

INTERCONNECTORCONSTRAINT sets out Interconnector limit data used as defaults in dispatch, predispatch and STPASA and used by SPD in calculating flows. INTERCONNECTORCONSTRAINT includes an additional field to restrict an interconnector from support transfer of FCAS.

INTERCONNECTORCONSTRAINT is public data, available to all participants.

Source

INTERCONNECTORCONSTRAINT changes infrequently, typically annually.

Tip

For more information about interconnector conventions, see the guide

Tip

You may want to join this with INTERCONNECTOR joining on key INTERCONNECTORID, to add columns REGIONFROM and REGIONTO.

Column Schema

EFFECTIVEDATE

Date that this limit is effective from

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

This column is mandatory, and a primary key.

Example: 1998/07/01 00:00:00

Note that AEMO represents dates as datetimes with a midnight time component.

INTERCONNECTORID

Unique Id of this interconnector

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

This column is mandatory, and a primary key.

Examples:

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

VERSIONNO

Version for this date

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

This column is mandatory, and a primary key.

Examples: 1, 4

AUTHORISEDBY

User authorising record

SQL Type: VARCHAR2(15) Polars Type: str

This column is not mandatory.

Examples:

  • BATCH
  • CASSA
  • CBROWNLEE
  • CBRUCE
  • DENNISG
  • DGRAHAM
  • GARRYL
  • GAURAVS
  • GLANDERS
  • Huajie

AUTHORISEDDATE

Date record authorised

Warning

Despite what the name suggests, this is a datetime, not a date.

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

This column is not mandatory.

Example: 1999/07/24 23:55:07

EMSMEASURAND

Identifies the EMS entity that represents the interconnector flow

SQL Type: VARCHAR2(40) Polars Type: str

This column is not mandatory.

Examples:

  • BLGC.LINE.BASSLINK
  • BLGC.LINE.GT_GC_MARKET
  • BURONGA.SUMM.BURONGA_BUNDEY
  • DUMARESQ.SUMM.DUMARESQ_BULLI
  • HYTS.SUMM.HYTS_SESS
  • MLNK_B.LINE.MURRAYLINK.MW
  • MULLUMB.LINE.DIRECTLINK
  • NSW1.SUMM.NSW1_SNOWY1
  • SNOWY1.LOAD.VIC1
  • S_EAST.SUMM.HEYWOOD

EXPORTLIMIT

Interconnector export limit

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

This column is not mandatory.

Examples: 200, 3812

FCASSUPPORTUNAVAILABLE

Flag to indicate that the interconnector cannot support FCAS Transfers

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

This column is not mandatory.

Examples: 0, 1

FROMREGIONLOSSSHARE

Loss share attributable to from region

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

This column is not mandatory.

Examples: 0.05, 0, 1, 0.91

ICTYPE

Interconnector type - Currently either "REGULATED" or "MNSP"

The SQL type is VARCHAR2(10). This is actually a factor/enum, with values:

  • REGULATED

  • MNSP

This column is not mandatory.

IMPORTLIMIT

Interconnector import limit

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

This column is not mandatory.

Examples: 0, 200, 2540

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: 2003/11/25 15:41:18

LOSSCONSTANT

Constant Loss factor

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

This column is not mandatory.

Examples: 0.8105, 1.152

LOSSFLOWCOEFFICIENT

Linear coefficient of loss factor calculation

SQL Type: NUMBER(27,17) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.000076672, 1.152

MAXMWIN

Limit of energy flowing into the RegionFrom

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

This column is not mandatory.

Examples: 201, 2541

MAXMWOUT

Limit of energy flowing out of the Region

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

This column is not mandatory.

Examples: 201, 3813

NONPHYSICALLOSSFACTOR

Factor for non-physical losses rerun

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

This column is not mandatory.

Examples: 100, 10000

OUTAGEDERATIONFACTOR

SPD Factor

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

This column is not mandatory.

OVERLOADFACTOR6SEC

Interconnector overload for 6 sec

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

This column is not mandatory.

OVERLOADFACTOR60SEC

Interconnector overload for 60 sec

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

This column is not mandatory.

RESERVEOVERALLLOADFACTOR

SPD Factor

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

This column is not mandatory.

DYNAMICRHS

Not used

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

This column is unused.

Example: F

New Data Timing

Usually annually

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"

# Dates are represented as datetimes at midnight

d_fmt = "%Y/%m/%d 00:00:00"

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("AUTHORISEDDATE", "LASTCHANGED").str.strptime(pl.Datetime, dt_s_fmt),
        pl.col("EFFECTIVEDATE").str.strptime(pl.Date, d_fmt),
    )
    # Polars can't cast string straight to bool. Need to go via something else.
    .cast({"FCASSUPPORTUNAVAILABLE": pl.UInt8})
    .cast(
        {
            "EFFECTIVEDATE": pl.Date(),
            "INTERCONNECTORID": pl.Categorical,
            "VERSIONNO": int,  # or pl.UInt16
            "AUTHORISEDBY": str,
            "EMSMEASURAND": str,
            "EXPORTLIMIT": int,  # or pl.Int32
            "FCASSUPPORTUNAVAILABLE": pl.Boolean,
            "FROMREGIONLOSSSHARE": pl.Float64,
            "ICTYPE": pl.Enum(["REGULATED", "MNSP"]),
            "IMPORTLIMIT": int,  # or pl.Int32
            "LOSSCONSTANT": pl.Float64,
            "LOSSFLOWCOEFFICIENT": pl.Float64,
            "MAXMWIN": pl.Float64,
            "MAXMWOUT": pl.Float64,
            "NONPHYSICALLOSSFACTOR": pl.Float64,
            "OUTAGEDERATIONFACTOR": pl.Float64,
            "OVERLOADFACTOR6SEC": pl.Float64,
            "OVERLOADFACTOR60SEC": pl.Float64,
            "RESERVEOVERALLLOADFACTOR": pl.Float64,
            "DYNAMICRHS": pl.Categorical,
        }
    )
    # Drop deprecated/unused columns
    .drop("DYNAMICRHS")
    # Deduplicate
    # We want one row per ['EFFECTIVEDATE', 'INTERCONNECTORID', 'VERSIONNO']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["EFFECTIVEDATE", "INTERCONNECTORID", "VERSIONNO"], keep="last")
)

Nemosis

from nemosis import dynamic_data_compiler

df = dynamic_data_compiler(
    '2024/01/01 00:00:00',
    '2024/01/31 00:00:00',
    "INTERCONNECTORCONSTRAINT",
    "data/"
)

Nemosis only includes a subset of columns by default, as an optimisation. (i.e. the commonly used columns.) To include others:

from nemosis import defaults

defaults.table_columns["INTERCONNECTORCONSTRAINT"] += ["AUTHORISEDBY", "AUTHORISEDDATE", "EMSMEASURAND", "EXPORTLIMIT", "FCASSUPPORTUNAVAILABLE", "IMPORTLIMIT", "LASTCHANGED", "MAXMWIN", "MAXMWOUT", "NONPHYSICALLOSSFACTOR", "OUTAGEDERATIONFACTOR", "OVERLOADFACTOR6SEC", "OVERLOADFACTOR60SEC", "RESERVEOVERALLLOADFACTOR", "DYNAMICRHS"]
df = dynamic_data_compiler(...)

Example File

From PUBLIC_ARCHIVE_INTERCONNECTORCONSTRAINT_FILE01_202609010000.zip

RESERVEOVERALLLOADFACTORFROMREGIONLOSSSHAREEFFECTIVEDATEVERSIONNOINTERCONNECTORIDMAXMWINMAXMWOUTLOSSCONSTANTLOSSFLOWCOEFFICIENTEMSMEASURANDAUTHORISEDBYAUTHORISEDDATEDYNAMICRHSIMPORTLIMITEXPORTLIMITOUTAGEDERATIONFACTORNONPHYSICALLOSSFACTOROVERLOADFACTOR60SECOVERLOADFACTOR6SECLASTCHANGEDFCASSUPPORTUNAVAILABLEICTYPE
0.91998/08/28 00:00:001V-SN212517251.00780.00009876SNOWY1.LOAD.VIC1PJH1998/01/01 00:00:00212417241002003/11/25 15:41:180REGULATED
0.051998/08/28 00:00:001SNOWY1144338131.01260.00008716NSW1.SUMM.NSW1_SNOWY1PJH1998/01/01 00:00:00144238121002003/11/25 15:41:180REGULATED
0.41998/08/28 00:00:001V-SA4018011.005720.00043609HYTS.SUMM.HYTS_SESSPJH1998/01/01 00:00:004008001002003/11/25 15:41:180REGULATED
0.91998/07/01 00:00:002V-SN150111011.00780.00009876SNOWY1.LOAD.VIC1DGRAHAM1998/08/18 00:00:00F150011001002003/11/25 15:41:180REGULATED
0.051998/07/01 00:00:002SNOWY185128511.01260.00008716NSW1.SUMM.NSW1_SNOWY1DGRAHAM1998/08/18 00:00:00F85028501002003/11/25 15:41:180REGULATED
0.41998/07/01 00:00:002V-SA2515011.005720.00043609HYTS.SUMM.HYTS_SESSDGRAHAM1998/08/18 00:00:00F2505001002003/11/25 15:41:180REGULATED
0.91998/11/02 00:00:001V-SN212517251.00780.00009876SNOWY1.LOAD.VIC1RGILLETT1998/11/02 00:00:00F212417242502003/11/25 15:41:180REGULATED
0.051998/11/02 00:00:001SNOWY1144338131.01260.00008716NSW1.SUMM.NSW1_SNOWY1RGILLETT1998/11/02 00:00:00F144238122502003/11/25 15:41:180REGULATED
0.61998/11/02 00:00:001V-SA4018011.005720.00043609HYTS.SUMM.HYTS_SESSRGILLETT1998/11/02 00:00:00F4008002502003/11/25 15:41:180REGULATED
0.051999/07/23 00:00:001SNOWY1144338131.01830.000078086NSW1.SUMM.NSW1_SNOWY1TOM1999/07/24 23:55:07F144238122502003/11/25 15:41:180REGULATED
0.91999/07/23 00:00:001V-SN212517251.01670.00010238SNOWY1.LOAD.VIC1TOM1999/07/24 23:55:07F212417242502003/11/25 15:41:180REGULATED
...

CSETP.WORLDDVD_INTERCONNECTORCONSTRAINTAEMOPUBLIC2026/10/0915:37:03001791524223609MONTHLY_ARCHIVE001791524223609
IMARKET_CONFIGINTERCONNECTORCONSTRAINT1RESERVEOVERALLLOADFACTORFROMREGIONLOSSSHAREEFFECTIVEDATEVERSIONNOINTERCONNECTORIDMAXMWINMAXMWOUTLOSSCONSTANTLOSSFLOWCOEFFICIENTEMSMEASURANDAUTHORISEDBYAUTHORISEDDATEDYNAMICRHSIMPORTLIMITEXPORTLIMITOUTAGEDERATIONFACTORNONPHYSICALLOSSFACTOROVERLOADFACTOR60SECOVERLOADFACTOR6SECLASTCHANGEDFCASSUPPORTUNAVAILABLEICTYPE
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.91998/08/28 00:00:001V-SN212517251.00780.00009876SNOWY1.LOAD.VIC1PJH1998/01/01 00:00:00212417241002003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.051998/08/28 00:00:001SNOWY1144338131.01260.00008716NSW1.SUMM.NSW1_SNOWY1PJH1998/01/01 00:00:00144238121002003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.41998/08/28 00:00:001V-SA4018011.005720.00043609HYTS.SUMM.HYTS_SESSPJH1998/01/01 00:00:004008001002003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.91998/07/01 00:00:002V-SN150111011.00780.00009876SNOWY1.LOAD.VIC1DGRAHAM1998/08/18 00:00:00F150011001002003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.051998/07/01 00:00:002SNOWY185128511.01260.00008716NSW1.SUMM.NSW1_SNOWY1DGRAHAM1998/08/18 00:00:00F85028501002003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.41998/07/01 00:00:002V-SA2515011.005720.00043609HYTS.SUMM.HYTS_SESSDGRAHAM1998/08/18 00:00:00F2505001002003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.91998/11/02 00:00:001V-SN212517251.00780.00009876SNOWY1.LOAD.VIC1RGILLETT1998/11/02 00:00:00F212417242502003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.051998/11/02 00:00:001SNOWY1144338131.01260.00008716NSW1.SUMM.NSW1_SNOWY1RGILLETT1998/11/02 00:00:00F144238122502003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.61998/11/02 00:00:001V-SA4018011.005720.00043609HYTS.SUMM.HYTS_SESSRGILLETT1998/11/02 00:00:00F4008002502003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.051999/07/23 00:00:001SNOWY1144338131.01830.000078086NSW1.SUMM.NSW1_SNOWY1TOM1999/07/24 23:55:07F144238122502003/11/25 15:41:180REGULATED
DMARKET_CONFIGINTERCONNECTORCONSTRAINT10.91999/07/23 00:00:001V-SN212517251.01670.00010238SNOWY1.LOAD.VIC1TOM1999/07/24 23:55:07F212417242502003/11/25 15:41:180REGULATED
...
CEND OF REPORT245

RESERVEOVERALLLOADFACTOR,FROMREGIONLOSSSHARE,EFFECTIVEDATE,VERSIONNO,INTERCONNECTORID,MAXMWIN,MAXMWOUT,LOSSCONSTANT,LOSSFLOWCOEFFICIENT,EMSMEASURAND,AUTHORISEDBY,AUTHORISEDDATE,DYNAMICRHS,IMPORTLIMIT,EXPORTLIMIT,OUTAGEDERATIONFACTOR,NONPHYSICALLOSSFACTOR,OVERLOADFACTOR60SEC,OVERLOADFACTOR6SEC,LASTCHANGED,FCASSUPPORTUNAVAILABLE,ICTYPE
,0.9,"1998/08/28 00:00:00",1,V-SN,2125,1725,1.0078,0.00009876,SNOWY1.LOAD.VIC1,PJH,"1998/01/01 00:00:00",,2124,1724,,100,,,"2003/11/25 15:41:18",0,REGULATED
,0.05,"1998/08/28 00:00:00",1,SNOWY1,1443,3813,1.0126,0.00008716,NSW1.SUMM.NSW1_SNOWY1,PJH,"1998/01/01 00:00:00",,1442,3812,,100,,,"2003/11/25 15:41:18",0,REGULATED
,0.4,"1998/08/28 00:00:00",1,V-SA,401,801,1.00572,0.00043609,HYTS.SUMM.HYTS_SESS,PJH,"1998/01/01 00:00:00",,400,800,,100,,,"2003/11/25 15:41:18",0,REGULATED
,0.9,"1998/07/01 00:00:00",2,V-SN,1501,1101,1.0078,0.00009876,SNOWY1.LOAD.VIC1,DGRAHAM,"1998/08/18 00:00:00",F,1500,1100,,100,,,"2003/11/25 15:41:18",0,REGULATED
,0.05,"1998/07/01 00:00:00",2,SNOWY1,851,2851,1.0126,0.00008716,NSW1.SUMM.NSW1_SNOWY1,DGRAHAM,"1998/08/18 00:00:00",F,850,2850,,100,,,"2003/11/25 15:41:18",0,REGULATED
,0.4,"1998/07/01 00:00:00",2,V-SA,251,501,1.00572,0.00043609,HYTS.SUMM.HYTS_SESS,DGRAHAM,"1998/08/18 00:00:00",F,250,500,,100,,,"2003/11/25 15:41:18",0,REGULATED
,0.9,"1998/11/02 00:00:00",1,V-SN,2125,1725,1.0078,0.00009876,SNOWY1.LOAD.VIC1,RGILLETT,"1998/11/02 00:00:00",F,2124,1724,,250,,,"2003/11/25 15:41:18",0,REGULATED
,0.05,"1998/11/02 00:00:00",1,SNOWY1,1443,3813,1.0126,0.00008716,NSW1.SUMM.NSW1_SNOWY1,RGILLETT,"1998/11/02 00:00:00",F,1442,3812,,250,,,"2003/11/25 15:41:18",0,REGULATED
,0.6,"1998/11/02 00:00:00",1,V-SA,401,801,1.00572,0.00043609,HYTS.SUMM.HYTS_SESS,RGILLETT,"1998/11/02 00:00:00",F,400,800,,250,,,"2003/11/25 15:41:18",0,REGULATED
,0.05,"1999/07/23 00:00:00",1,SNOWY1,1443,3813,1.0183,0.000078086,NSW1.SUMM.NSW1_SNOWY1,TOM,"1999/07/24 23:55:07",F,1442,3812,,250,,,"2003/11/25 15:41:18",0,REGULATED
,0.9,"1999/07/23 00:00:00",1,V-SN,2125,1725,1.0167,0.00010238,SNOWY1.LOAD.VIC1,TOM,"1999/07/24 23:55:07",F,2124,1724,,250,,,"2003/11/25 15:41:18",0,REGULATED
...

C,SETP.WORLD,DVD_INTERCONNECTORCONSTRAINT,AEMO,PUBLIC,2026/10/09,15:37:03,001791524223609,MONTHLY_ARCHIVE,001791524223609
I,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,RESERVEOVERALLLOADFACTOR,FROMREGIONLOSSSHARE,EFFECTIVEDATE,VERSIONNO,INTERCONNECTORID,MAXMWIN,MAXMWOUT,LOSSCONSTANT,LOSSFLOWCOEFFICIENT,EMSMEASURAND,AUTHORISEDBY,AUTHORISEDDATE,DYNAMICRHS,IMPORTLIMIT,EXPORTLIMIT,OUTAGEDERATIONFACTOR,NONPHYSICALLOSSFACTOR,OVERLOADFACTOR60SEC,OVERLOADFACTOR6SEC,LASTCHANGED,FCASSUPPORTUNAVAILABLE,ICTYPE
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.9,"1998/08/28 00:00:00",1,V-SN,2125,1725,1.0078,0.00009876,SNOWY1.LOAD.VIC1,PJH,"1998/01/01 00:00:00",,2124,1724,,100,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.05,"1998/08/28 00:00:00",1,SNOWY1,1443,3813,1.0126,0.00008716,NSW1.SUMM.NSW1_SNOWY1,PJH,"1998/01/01 00:00:00",,1442,3812,,100,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.4,"1998/08/28 00:00:00",1,V-SA,401,801,1.00572,0.00043609,HYTS.SUMM.HYTS_SESS,PJH,"1998/01/01 00:00:00",,400,800,,100,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.9,"1998/07/01 00:00:00",2,V-SN,1501,1101,1.0078,0.00009876,SNOWY1.LOAD.VIC1,DGRAHAM,"1998/08/18 00:00:00",F,1500,1100,,100,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.05,"1998/07/01 00:00:00",2,SNOWY1,851,2851,1.0126,0.00008716,NSW1.SUMM.NSW1_SNOWY1,DGRAHAM,"1998/08/18 00:00:00",F,850,2850,,100,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.4,"1998/07/01 00:00:00",2,V-SA,251,501,1.00572,0.00043609,HYTS.SUMM.HYTS_SESS,DGRAHAM,"1998/08/18 00:00:00",F,250,500,,100,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.9,"1998/11/02 00:00:00",1,V-SN,2125,1725,1.0078,0.00009876,SNOWY1.LOAD.VIC1,RGILLETT,"1998/11/02 00:00:00",F,2124,1724,,250,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.05,"1998/11/02 00:00:00",1,SNOWY1,1443,3813,1.0126,0.00008716,NSW1.SUMM.NSW1_SNOWY1,RGILLETT,"1998/11/02 00:00:00",F,1442,3812,,250,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.6,"1998/11/02 00:00:00",1,V-SA,401,801,1.00572,0.00043609,HYTS.SUMM.HYTS_SESS,RGILLETT,"1998/11/02 00:00:00",F,400,800,,250,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.05,"1999/07/23 00:00:00",1,SNOWY1,1443,3813,1.0183,0.000078086,NSW1.SUMM.NSW1_SNOWY1,TOM,"1999/07/24 23:55:07",F,1442,3812,,250,,,"2003/11/25 15:41:18",0,REGULATED
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,,0.9,"1999/07/23 00:00:00",1,V-SN,2125,1725,1.0167,0.00010238,SNOWY1.LOAD.VIC1,TOM,"1999/07/24 23:55:07",F,2124,1724,,250,,,"2003/11/25 15:41:18",0,REGULATED
...
C,"END OF REPORT",245

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 75 KB when zipped, 753 KB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

The transaction type is "INSERT-UPDATE", 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
MARKET_CONFIG INTERCONNECTORCONSTRAINT 1

This means that the CSV files start with metadata columns:

I,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,...
D,MARKET_CONFIG,INTERCONNECTORCONSTRAINT,1,...

ROW_FILTER_TYPE is LASTCHANGED

Indexes

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