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 |