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