INT339 – CC Auction Bid Stack

Trigger type	Event triggered
Published	Approval of CC Auction
Audience	Public
Output file name	int339_v[n]_ccauction_bid_stack_[p]~yyyymmddhhmmss.csv

Report purpose

This report provides the entire bid stack information without participant data identifying data for the current (latest) CC Capacity Certificate auction as denoted by the auction ID number.

Audience notes

This report provides the final capacity certificate bid stack data for the current (latest) auction published.

Content notes

Each report contains the:

• auction id

• auction run date

• bid identifier

• identifier of CC zone

• name of CC zone

• starting CC product period

• ending CC product period

• bid step number

• CC auction bid step price

• CC auction bid step quantity

• report generation date

Data content

Name	Data Type	No Nulls	Primary Key	CQ	Comments
auction_id	INT	True	False	N	Identifier number of the CC auction
auction_date	VARCHAR(12)	False	False	N	Auction run date. dd mmm yyyy.
bid_id	INT	True	True	N	bid identifier
zone_id	INT	True	True	N	Identifier number of CC zone
zone_name	NVARCHAR(50)	True	False	N	Name of CC zone
start_period	NVARCHAR(50)	True	False	N	Starting CC product period representing date range period for the capacity.
end_period	NVARCHAR(50)	True	False	N	Ending CC product period representing date range period for the capacity
step	INT	True	True	N	Bid step number
bid_price	NUMERIC(15,4)	True	False	N	CC auction bid step price
bid_quantity_gj	NUMERIC(18,9)	True	False	N	CC auction bid step quantity
current_date	VARCHAR(21)	True	False	N	Report generation date. dd mmm yyyy hh:mm:ss