INT351 – CC Public Registry Summary

Trigger type

Time triggered

Published

Daily 00:00

Audience

Public

Output file name

int351_v[n]_ccregistry_summary_1~yyyymmddhhmmss.csv

Report purpose

This report provides a registry of the capacity certificates allocated to each auction product.

Audience notes

This report will provide the total capacity certificates that is allocated at each CC Capacity Certificate zone and period. The report aggregates the CC quantities won and paid for by all Market participants in a CC Auction for a CC zone and period. The report also provides quantities allocated by the DTS Declared Transmission System (Victoria). Victoria’s gas transmission system, operated by AEMO. SP Service Provider (could be different to meter data providers). They provide the telemetry data i.e. behind the NMI data from Batteries..

This report is published daily at midnight.

Content notes

Each report contains the:

  • total capacity certificates allocated to a given CC zone for a given period

  • whether the capacity certificates allocated is won at auction or allocated by the DTS SP

  • date and time when the report was produced

Data content

Name

Data Type

No Nulls

Primary Key

CQ

Comments

zone_id

INT

True

True

N

Identifier number of CC zone.

zone_name

NVARCHAR(50)

True

False

N

Name of CC zone.

zone_type

NVARCHAR(20)

True

False

N

Type of CC zone. Entry/Exit.

start_date

NVARCHAR(12)

True

True

N

Starting CC product period start date. Dd mmm yyyy.

end_date

NVARCHAR(12)

True

True

N

Ending CC product period end date. Dd mmm yyyy.

total_holding_gj

NUMERIC(18,9)

False

False

Y

source

NVARCHAR(20)

True

True

N

Acquired source of the holding.

Eg:

AUCTION

DTSSP14

current_date

VARCHAR(12)

True

False

N

Report generation date. dd mmm yyyy hh:mm:ss