MARKETNOTICETYPE

MARKETNOTICETYPE sets out the different types of market notices (e.g. market systems).

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

Source

MARKETNOTICETYPE updates whenever market notice types change.

Tip

1 second, 6 second, 5 minute, 60 second and regulation refer to types of FCAS markets.

Column Schema

TYPEID

Identifier for market notice type

SQL Type: VARCHAR2(25) Polars Type: str

This column is mandatory, and a primary key.

Examples:

ADMINISTERED PRICE CAP
CONSTRAINTS
FORCED MAJEURE
GENERAL NOTICE
INTER-REGIONAL TRANSFER
LOAD RESTORE
LOAD SHED
MANDATORY RESTRICTIONS
MARKET DIRECTION
MARKET INTERVENTION

DESCRIPTION

Type description

SQL Type: VARCHAR2(64) Polars Type: str

This column is not mandatory.

Examples:

Administered price periods declared.
Declaration/Cancellation; MR Schedule; Offers
Details of Non-conformance/Conformance
Discontinued 24/09/2001- Process Investigation: Scheduling Error
Dispatch Price is VOLL
Emergency events/conditions
Impact of System Reconfiguration
Inter-Regional Transfer limit variation
LRC/LOR1/LOR2/LOR3
MMS, EMS, SCADA, IT, BIDDING

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: 1998/06/30 22:01:21

RAISEDBY

Not used

SQL Type: VARCHAR2(10) Polars Type: str

This column is unused.

Examples:

AEMO
NEMMCO
RSO

New Data Timing

When market notice types change

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("LASTCHANGED").str.strptime(pl.Datetime, dt_s_fmt),
    )
    .cast({"TYPEID": str, "DESCRIPTION": str, "RAISEDBY": str})
    # Drop deprecated/unused columns
    .drop("RAISEDBY")
    # Deduplicate
    # We want one row per ['TYPEID']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["TYPEID"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_MARKETNOTICETYPE_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

TYPEID	DESCRIPTION	RAISEDBY	LASTCHANGED
FORCED MAJEURE	Not applicable from 31/12/2000. (Administered Price Period/Cap)	NEMMCO	2001/09/28 11:28:05
MARKET SUSPENSION	Market suspended in region(s).	NEMMCO	2001/09/28 11:28:05
TRAIN	Training/Testing Notice	RSO	1998/06/30 22:01:21
TEST	Please double click on (Memo) in the reason column	NEMMCO	1998/06/30 22:01:21
VOLL	Dispatch Price is VOLL	NEMMCO	1998/08/17 16:31:53
MARKET SYSTEMS	Status of Market Systems	NEMMCO	1998/08/17 18:00:05
POWER SYSTEM EVENTS	Emergency events/conditions	NEMMCO	1998/08/17 18:02:18
RESERVE NOTICE	LRC/LOR1/LOR2/LOR3	NEMMCO	1998/08/17 18:12:41
GENERAL NOTICE	Subjects not covered in specific notices	NEMMCO	1998/08/17 18:11:01
MARKET INTERVENTION	Reserve Contract / Direction / Instruction	NEMMCO	2003/01/10 07:34:41
NON-CONFORMANCE	Details of Non-conformance/Conformance	NEMMCO	1998/08/17 18:32:02
...

C	SETP.WORLD	DVD_MARKETNOTICETYPE	AEMO	PUBLIC	2026/10/09	15:53:27	001791525207622	MONTHLY_ARCHIVE	001791525207622
I	MARKET_NOTICE	MARKETNOTICETYPE	1	TYPEID	DESCRIPTION	RAISEDBY	LASTCHANGED
D	MARKET_NOTICE	MARKETNOTICETYPE	1	FORCED MAJEURE	Not applicable from 31/12/2000. (Administered Price Period/Cap)	NEMMCO	2001/09/28 11:28:05
D	MARKET_NOTICE	MARKETNOTICETYPE	1	MARKET SUSPENSION	Market suspended in region(s).	NEMMCO	2001/09/28 11:28:05
D	MARKET_NOTICE	MARKETNOTICETYPE	1	TRAIN	Training/Testing Notice	RSO	1998/06/30 22:01:21
D	MARKET_NOTICE	MARKETNOTICETYPE	1	TEST	Please double click on (Memo) in the reason column	NEMMCO	1998/06/30 22:01:21
D	MARKET_NOTICE	MARKETNOTICETYPE	1	VOLL	Dispatch Price is VOLL	NEMMCO	1998/08/17 16:31:53
D	MARKET_NOTICE	MARKETNOTICETYPE	1	MARKET SYSTEMS	Status of Market Systems	NEMMCO	1998/08/17 18:00:05
D	MARKET_NOTICE	MARKETNOTICETYPE	1	POWER SYSTEM EVENTS	Emergency events/conditions	NEMMCO	1998/08/17 18:02:18
D	MARKET_NOTICE	MARKETNOTICETYPE	1	RESERVE NOTICE	LRC/LOR1/LOR2/LOR3	NEMMCO	1998/08/17 18:12:41
D	MARKET_NOTICE	MARKETNOTICETYPE	1	GENERAL NOTICE	Subjects not covered in specific notices	NEMMCO	1998/08/17 18:11:01
D	MARKET_NOTICE	MARKETNOTICETYPE	1	MARKET INTERVENTION	Reserve Contract / Direction / Instruction	NEMMCO	2003/01/10 07:34:41
D	MARKET_NOTICE	MARKETNOTICETYPE	1	NON-CONFORMANCE	Details of Non-conformance/Conformance	NEMMCO	1998/08/17 18:32:02
...
C	END OF REPORT	36

TYPEID,DESCRIPTION,RAISEDBY,LASTCHANGED
"FORCED MAJEURE","Not applicable from 31/12/2000. (Administered Price Period/Cap)",NEMMCO,"2001/09/28 11:28:05"
"MARKET SUSPENSION","Market suspended in region(s).",NEMMCO,"2001/09/28 11:28:05"
TRAIN,"Training/Testing Notice",RSO,"1998/06/30 22:01:21"
TEST,"Please double click on (Memo) in the reason column",NEMMCO,"1998/06/30 22:01:21"
VOLL,"Dispatch Price is VOLL",NEMMCO,"1998/08/17 16:31:53"
"MARKET SYSTEMS","Status of Market Systems",NEMMCO,"1998/08/17 18:00:05"
"POWER SYSTEM EVENTS","Emergency events/conditions",NEMMCO,"1998/08/17 18:02:18"
"RESERVE NOTICE",LRC/LOR1/LOR2/LOR3,NEMMCO,"1998/08/17 18:12:41"
"GENERAL NOTICE","Subjects not covered in specific notices",NEMMCO,"1998/08/17 18:11:01"
"MARKET INTERVENTION","Reserve Contract / Direction / Instruction",NEMMCO,"2003/01/10 07:34:41"
NON-CONFORMANCE,"Details of Non-conformance/Conformance",NEMMCO,"1998/08/17 18:32:02"
...

Raw Text with Metadata

C,SETP.WORLD,DVD_MARKETNOTICETYPE,AEMO,PUBLIC,2026/10/09,15:53:27,001791525207622,MONTHLY_ARCHIVE,001791525207622
I,MARKET_NOTICE,MARKETNOTICETYPE,1,TYPEID,DESCRIPTION,RAISEDBY,LASTCHANGED
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"FORCED MAJEURE","Not applicable from 31/12/2000. (Administered Price Period/Cap)",NEMMCO,"2001/09/28 11:28:05"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"MARKET SUSPENSION","Market suspended in region(s).",NEMMCO,"2001/09/28 11:28:05"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,TRAIN,"Training/Testing Notice",RSO,"1998/06/30 22:01:21"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,TEST,"Please double click on (Memo) in the reason column",NEMMCO,"1998/06/30 22:01:21"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,VOLL,"Dispatch Price is VOLL",NEMMCO,"1998/08/17 16:31:53"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"MARKET SYSTEMS","Status of Market Systems",NEMMCO,"1998/08/17 18:00:05"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"POWER SYSTEM EVENTS","Emergency events/conditions",NEMMCO,"1998/08/17 18:02:18"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"RESERVE NOTICE",LRC/LOR1/LOR2/LOR3,NEMMCO,"1998/08/17 18:12:41"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"GENERAL NOTICE","Subjects not covered in specific notices",NEMMCO,"1998/08/17 18:11:01"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,"MARKET INTERVENTION","Reserve Contract / Direction / Instruction",NEMMCO,"2003/01/10 07:34:41"
D,MARKET_NOTICE,MARKETNOTICETYPE,1,NON-CONFORMANCE,"Details of Non-conformance/Conformance",NEMMCO,"1998/08/17 18:32:02"
...
C,"END OF REPORT",36

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

Deduplication and PDR Loader Configuration

The primary keys are:

TYPEID

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_NOTICE	MARKETNOTICETYPE	1

This means that the CSV files start with metadata columns:

I,MARKET_NOTICE,MARKETNOTICETYPE,1,...
D,MARKET_NOTICE,MARKETNOTICETYPE,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_NOTICE