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 |