REGIONSTANDINGDATA

REGIONSTANDINGDATA sets out standing region data including the region reference node.

REGIONSTANDINGDATA data is public, so is available to all participants.

Source

REGIONSTANDINGDATA only changes when a change is made to a region. This table changes infrequently.

Column Schema

EFFECTIVEDATE

Effective date of this record, only the latest date applies

Warning

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

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

This column is mandatory, and a primary key.

Example: 2026/04/27 12:00:00

REGIONID

Differentiates this region from all other regions

For more information, see the dedicated documentation page.

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

QLD1
VIC1
TAS1
NSW1
SA1
SNOWY1

This column is mandatory, and a primary key.

VERSIONNO

Version No of the standing data that should be effective on this date

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

This column is mandatory, and a primary key.

Example: 1

AUTHORISEDBY

User authorising record

SQL Type: VARCHAR2(15) Polars Type: str

This column is not mandatory.

Examples:

BATCH
LUKEB
MIBRAHIM
NORRIS
TOM

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: 1997/11/04 11:16:11

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: 2006/06/01 00:00:58

PEAKTRADINGPERIOD

Period identifier of the peak trading period of this connection point

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

This column is not mandatory.

REGIONALREFERENCEPOINTID

unique id of a connection point, being the reference point for this region

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

This column is not mandatory.

Examples:

NREF1
QREF1
SAREF1
SNREF1
TREF1
VREF1

RSOID

the unique identifier of the participant with responsibility for the region.

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

This column is not mandatory.

Examples:

NRSO
QLDRSO

SCALINGFACTOR

Scaling factor for regional FCAS requirement

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

This column is not mandatory.

Example: 1

New Data Timing

When there is change to a region

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("EFFECTIVEDATE", "AUTHORISEDDATE", "LASTCHANGED").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
    )
    .cast(
        {
            "REGIONID": pl.Enum(["QLD1", "VIC1", "TAS1", "NSW1", "SA1", "SNOWY1"]),
            "VERSIONNO": int,  # or pl.UInt16
            "AUTHORISEDBY": str,
            "PEAKTRADINGPERIOD": int,  # or pl.UInt16
            "REGIONALREFERENCEPOINTID": pl.Categorical,
            "RSOID": pl.Categorical,
            "SCALINGFACTOR": pl.Float64,
        }
    )
    # Deduplicate
    # We want one row per ['EFFECTIVEDATE', 'REGIONID', 'VERSIONNO']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["EFFECTIVEDATE", "REGIONID", "VERSIONNO"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_REGIONSTANDINGDATA_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

EFFECTIVEDATE	VERSIONNO	REGIONID	RSOID	REGIONALREFERENCEPOINTID	PEAKTRADINGPERIOD	AUTHORISEDDATE	AUTHORISEDBY	SCALINGFACTOR	LASTCHANGED
1997/10/30 00:00:00	1	QLD1	QLDRSO	QREF1		1997/11/04 11:16:11	NORRIS	1	2023/12/12 16:49:50
1997/11/01 00:00:00	1	NSW1	NRSO	NREF1		1997/11/04 11:16:11	NORRIS	1	2023/12/12 16:49:50
1997/11/01 00:00:00	1	SA1	NRSO	SAREF1		1997/11/04 11:16:11	NORRIS	1	2023/12/12 16:49:50
1997/11/01 00:00:00	1	SNOWY1	NRSO	SNREF1		1997/11/04 11:16:11	NORRIS	1	2006/06/01 00:00:58
1997/10/30 00:00:00	1	VIC1	NRSO	VREF1		1997/11/04 11:16:11	NORRIS	1	2023/12/12 16:49:50
2005/05/16 00:00:00	1	TAS1	NRSO	TREF1		2005/05/16 00:00:00	BATCH	1	2023/12/12 16:49:50
2006/08/21 00:00:00	1	QLD1	QLDRSO	QREF1		2006/08/14 09:00:00	LUKEB	1	2023/12/12 16:49:50
2010/12/15 00:00:00	1	TAS1	NRSO	TREF1		2010/12/15 00:00:00	TOM	1	2023/12/12 16:49:50
2026/04/27 12:00:00	1	QLD1	QLDRSO	QREF1		2026/04/27 11:07:49	MIBRAHIM	1	2026/04/27 11:07:49
2026/04/27 12:00:00	1	NSW1	NRSO	NREF1		2026/04/27 11:07:49	MIBRAHIM	1	2026/04/27 11:07:49
2026/04/27 12:00:00	1	VIC1	NRSO	VREF1		2026/04/27 11:07:49	MIBRAHIM	1	2026/04/27 11:07:49
...

C

SETP.WORLD

DVD_REGIONSTANDINGDATA

AEMO

PUBLIC

2026/10/09

16:28:02

001791527282575

MONTHLY_ARCHIVE

001791527282575

I

MARKET_CONFIG

REGIONSTANDINGDATA

1

EFFECTIVEDATE

VERSIONNO

REGIONID

RSOID

REGIONALREFERENCEPOINTID

PEAKTRADINGPERIOD

AUTHORISEDDATE

AUTHORISEDBY

SCALINGFACTOR

LASTCHANGED

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

1997/10/30 00:00:00

1

QLD1

QLDRSO

QREF1

1997/11/04 11:16:11

NORRIS

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

1997/11/01 00:00:00

1

NSW1

NRSO

NREF1

1997/11/04 11:16:11

NORRIS

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

1997/11/01 00:00:00

1

SA1

NRSO

SAREF1

1997/11/04 11:16:11

NORRIS

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

1997/11/01 00:00:00

1

SNOWY1

NRSO

SNREF1

1997/11/04 11:16:11

NORRIS

1

2006/06/01 00:00:58

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

1997/10/30 00:00:00

1

VIC1

NRSO

VREF1

1997/11/04 11:16:11

NORRIS

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

2005/05/16 00:00:00

1

TAS1

NRSO

TREF1

2005/05/16 00:00:00

BATCH

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

2006/08/21 00:00:00

1

QLD1

QLDRSO

QREF1

2006/08/14 09:00:00

LUKEB

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

2010/12/15 00:00:00

1

TAS1

NRSO

TREF1

2010/12/15 00:00:00

TOM

1

2023/12/12 16:49:50

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

2026/04/27 12:00:00

1

QLD1

QLDRSO

QREF1

2026/04/27 11:07:49

MIBRAHIM

1

2026/04/27 11:07:49

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

2026/04/27 12:00:00

1

NSW1

NRSO

NREF1

2026/04/27 11:07:49

MIBRAHIM

1

2026/04/27 11:07:49

D

MARKET_CONFIG

REGIONSTANDINGDATA

1

2026/04/27 12:00:00

1

VIC1

NRSO

VREF1

2026/04/27 11:07:49

MIBRAHIM

1

2026/04/27 11:07:49

...

C

END OF REPORT

16

EFFECTIVEDATE,VERSIONNO,REGIONID,RSOID,REGIONALREFERENCEPOINTID,PEAKTRADINGPERIOD,AUTHORISEDDATE,AUTHORISEDBY,SCALINGFACTOR,LASTCHANGED
"1997/10/30 00:00:00",1,QLD1,QLDRSO,QREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
"1997/11/01 00:00:00",1,NSW1,NRSO,NREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
"1997/11/01 00:00:00",1,SA1,NRSO,SAREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
"1997/11/01 00:00:00",1,SNOWY1,NRSO,SNREF1,,"1997/11/04 11:16:11",NORRIS,1,"2006/06/01 00:00:58"
"1997/10/30 00:00:00",1,VIC1,NRSO,VREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
"2005/05/16 00:00:00",1,TAS1,NRSO,TREF1,,"2005/05/16 00:00:00",BATCH,1,"2023/12/12 16:49:50"
"2006/08/21 00:00:00",1,QLD1,QLDRSO,QREF1,,"2006/08/14 09:00:00",LUKEB,1,"2023/12/12 16:49:50"
"2010/12/15 00:00:00",1,TAS1,NRSO,TREF1,,"2010/12/15 00:00:00",TOM,1,"2023/12/12 16:49:50"
"2026/04/27 12:00:00",1,QLD1,QLDRSO,QREF1,,"2026/04/27 11:07:49",MIBRAHIM,1,"2026/04/27 11:07:49"
"2026/04/27 12:00:00",1,NSW1,NRSO,NREF1,,"2026/04/27 11:07:49",MIBRAHIM,1,"2026/04/27 11:07:49"
"2026/04/27 12:00:00",1,VIC1,NRSO,VREF1,,"2026/04/27 11:07:49",MIBRAHIM,1,"2026/04/27 11:07:49"
...

Raw Text with Metadata

C,SETP.WORLD,DVD_REGIONSTANDINGDATA,AEMO,PUBLIC,2026/10/09,16:28:02,001791527282575,MONTHLY_ARCHIVE,001791527282575
I,MARKET_CONFIG,REGIONSTANDINGDATA,1,EFFECTIVEDATE,VERSIONNO,REGIONID,RSOID,REGIONALREFERENCEPOINTID,PEAKTRADINGPERIOD,AUTHORISEDDATE,AUTHORISEDBY,SCALINGFACTOR,LASTCHANGED
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"1997/10/30 00:00:00",1,QLD1,QLDRSO,QREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"1997/11/01 00:00:00",1,NSW1,NRSO,NREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"1997/11/01 00:00:00",1,SA1,NRSO,SAREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"1997/11/01 00:00:00",1,SNOWY1,NRSO,SNREF1,,"1997/11/04 11:16:11",NORRIS,1,"2006/06/01 00:00:58"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"1997/10/30 00:00:00",1,VIC1,NRSO,VREF1,,"1997/11/04 11:16:11",NORRIS,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"2005/05/16 00:00:00",1,TAS1,NRSO,TREF1,,"2005/05/16 00:00:00",BATCH,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"2006/08/21 00:00:00",1,QLD1,QLDRSO,QREF1,,"2006/08/14 09:00:00",LUKEB,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"2010/12/15 00:00:00",1,TAS1,NRSO,TREF1,,"2010/12/15 00:00:00",TOM,1,"2023/12/12 16:49:50"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"2026/04/27 12:00:00",1,QLD1,QLDRSO,QREF1,,"2026/04/27 11:07:49",MIBRAHIM,1,"2026/04/27 11:07:49"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"2026/04/27 12:00:00",1,NSW1,NRSO,NREF1,,"2026/04/27 11:07:49",MIBRAHIM,1,"2026/04/27 11:07:49"
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,"2026/04/27 12:00:00",1,VIC1,NRSO,VREF1,,"2026/04/27 11:07:49",MIBRAHIM,1,"2026/04/27 11:07:49"
...
C,"END OF REPORT",16

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

Deduplication and PDR Loader Configuration

The primary keys are:

EFFECTIVEDATE
REGIONID
VERSIONNO

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

This means that the CSV files start with metadata columns:

I,MARKET_CONFIG,REGIONSTANDINGDATA,1,...
D,MARKET_CONFIG,REGIONSTANDINGDATA,1,...

ROW_FILTER_TYPE is LASTCHANGED

Indexes

LASTCHANGED

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