sd_ftrlt
Long Term FTR Auction Bids

Current Status

Report Name

Change Summary

Effective Date

Description

Template

Sample

sd_ftrlt Modified. New column "Auction Name" will be reported beginning with the approval of Round 1 of the 2013 Annual FTR Auction. 10.09.2012 PDF XLTX CSV
Access Long-Term FTR Auction Historical Bid Data

 

SD_FTRLT – Long Term FTR Bids – Rev 2

SD_FTRLT_customer_date_version.CSV
Customer: xxxxxxxxx (9 digit number) Date: mm/dd/yyyy and Version: mm/dd/yyyy hh:mm:ss GMT
Availability: Annual

Description

Auction bid data received by the ISO from participants for the Long-Term FTR Auction. This report will list the customer’s FTR Annual market bids by location. The source and destination location information will be printed on the reports. This report is meant for distribution to MIS SFTP site. The reports are generated annually on demand per customer, one report for each annual auction.

Delivery Method

SFTP Distribution

Filename

SD_FTRLT_customer_settlement_version.CSV
  Customer is the 9 digit number of customer id,
  settlement is the date of the first day of the month for which the data applies, formatted as YYYYMMDD,
  version is the date/time when the report was generated, formatted as YYYYMMDDHHMSS
Note: The comments will detail the ‘from’ and ‘to’ dates for which the bids apply.

Format

Comma Delimited (CSV)

Size

Up to 50,000 records per auction

Lifetime

N/A

 

Column Name

Type

Description

 

N/A

String

The first position on every record is occupied by the character ‘C’, ‘H’, ‘D’, or ‘T’ which describes what is contained on that record (row.)
C = Comment – provides description such as report name and vintage.
H = Heading – denotes column headings.
D = Data – denotes data contained on the record.
T = Terminate – denotes the end of the file. The total number of ‘D’ lines contained in the file is also noted on this record.

1

FTR ID

Number

FTR identification number.

2

Source Location ID

Number

The location identification number of the bid’s source.

3

Source Location Name

String

The location name of the bid’s source.

4

Sink Location ID

Number

The location identification number of the bid’s sink.

5

Sink Location Name

String

The location name of the bid’s sink.

6

Buy / Sell

String

 ‘BUY’ bid or ‘SELL’ offer.

7

Class Type

String

Whether the bid is for the ‘OFFPEAK’ or ‘ONPEAK’ auction.

8

Bid MW

MW

The MW quantity of the bid.

9

Bid Price

$/MW

The bid price in $/MW

10

Awarded MW

MW

Awarded MW quantity

11

Awarded Price

$/MW

Awarded price in $/MW

12

Auction Dollars

$

Auction dollar amount

13

Bid Status

String

Whether the bid was 'CLEARED' or ‘DENIED.'

14

Auction Name

String

The auction that the FTR was submitted to.

 

Archive Status

Report Name

Change Summary

Effective Date

sd_ftrlt New. Auction bid data received by the ISO from participants for the Long-Term FTR Auction. The first generation of the report will be distributed no earlier than March 25, 2011. 01.01.2011
  Copyright ©2014 ISO New England Inc.