Transcript Data Extracts

ERCOT Billing,
Settlement Disputes
& Data Extracts
Module 5
1
ERCOT Billing
2
ERCOT Billing
Learning Objectives:
 Billing Overview
 Invoice Payment Process
 Example Statement and Invoice
3
Billing Overview
Settlement and Billing in a Nutshell

Settle with each QSE on an hourly basis for
capacity services and 15-minute intervals for
balancing energy and congestion fees

Publish billing determinants, settlement
statements and invoices

Collect all payments and charges via electronic
funds transfer

Manage revenue neutrality
Which is the only charge type that is NOT revenue neutral?
4
Billing Overview
Settlement Timeline
Day 0
 Energy consumed (Operating Day)
Day 10
 Initial Settlement information provided
Day 59
 Final Settlement for day 0 provided
6 Months
 True-Up Settlement
5
Other Useful Settlement Information
6
ERCOT Billing
Learning Objectives:
 Billing Overview
 Invoice Payment Process
 Example Statement and Invoice
7
Invoice Payment Process
How does the money flow?
Generation
How does ERCOT pay Generators?
Load
8
Invoice Payment Process
Invoice Payment Requirements
 Payment in full regardless of dispute status
Electronic Funds Transfer (EFT)
US Dollars
 Weekend or holiday due date deferred to next
business day
9
Invoice Payment Process
The Big Picture
MP payment to
ERCOT due by
COB (1700 CPT)
on due date
ERCOT receives
payment and
verification process
begins.
ERCOT submits
all payments to
MPs by COB the
following day
MP receives and
verifies payment
from ERCOT 10
Invoice Payment Process
Partial Payments
 QSE Short Pay
 ERCOT attempts collection before end of bank
business day
 ERCOT Administrative Fees deducted before
allocation
 ERCOT proportionally reduces payments to QSE’s
owed
 Subsequently collected funds are proportionally
disbursed to shorted QSE’s on the business day
collected
11
ERCOT Billing
Learning Objectives:
 Billing Overview
 Invoice Payment Process
 Example Statement and Invoice
12
Settlement Statement
Trade Date Info
Net Settlement by
Charge Type
Settlement Total for
Operating Day
13
ERCOT
INVOICE
2705 West Lake Drive
Invoice No: 00001
Taylor, TX 76754-2136
Invoice Date: 06/14/01
(512) 248-3000
fax (512) 248-3095
Invoice Recipient
Outstanding Money
Name QSE1 Generation
0 >30 days
Address 111 Capacity Circle
City Cedar Park
Phone
Sample Invoice
>30 days
($2,523,400.00)
State TX
$0.00
Zip 78710
(512) 555-1000
ID QSE1-100
In accordance with ERC OT Protocols, Invoices must be paid in full, regardless of disputes to avoid
jeopardizing your certification to participate in the market.
Category
Transaction Number
Initial Statements
06012001-QSE1G
06022001-QSE1G
06032001-QSE1G
06042001-QSE1G
06052001-QSE1G
06062001-QSE1G
06072001-QSE1G
Description
20010601
20010602
20010603
20010604
20010605
20010606
20010607
Amount
Subtotal
$
(773,400.00)
$
(500,000.00)
$
(250,000.00)
$
(100,000.00)
$
(250,000.00)
$
(500,000.00)
$
(150,000.00)
Initial Settlement Subtotal
Other Charges Subtotal
($2,523,400.00)
$0.00
Net Amount Owed (Due)
($2,523,400.00)
Net amount owed
by the QSE or, in
this case, due to
the QSE
Remittance Information
ISO Account:
Account Name ERCOT ISO
ABA Routing Number 121367893
Account No. 8750356450
Recipient Account:
QSE1 Generation
123456789
1111111111
In the event that your payment is not received by 10:00 am C entral Prevailing Time
20010716
on:
a late fee of 0.066031% per day will be applied to any outstanding balance.
Payments will be made to the Invoice recipient by 2:00 pm C entral Prevailing Time 20010716
on:
14
Questions
15
Settlement Disputes
16
ERCOT Billing
Learning Objectives:
 Dispute Timeline
 Responsibilities
 ERCOT Resolution
17
Dispute Timeline
Day 0
Energy consumed (Operating Day)
Day 10
Initial Settlement information provided for Day 0
Day 20
Timely Disputes for Initial Settlement due
Day 59
Final Settlement information for Day 0 provided
Day 69
Timely Disputes for Final Settlement due
Day 170
All Disputes Due
Day 180
True-Up Settlement
Day 190
Dispute on True-Up Due
18
ERCOT Billing
Learning Objectives:
 Dispute Timeline
 Responsibilities
 ERCOT Resolution
19
Responsibilities
QSE Responsibility






Timely
Contain all required information
One per Operating Day
One per Charge Type
Submitted via TML
Contain “all available evidence
reasonably necessary to support
the claim”.
20
Responsibilities
ERCOT Responsibility
 Research Settlement Disputes
 Make all reasonable attempts
to resolve all Open disputes
within 10 business days of the
dispute submission deadline
 Notify QSE if Settlement
Dispute can not be
completed on time.
21
ERCOT Billing
Learning Objectives:
 Dispute Timeline
 Responsibilities
 ERCOT Resolution
22
Dispute Resolution
Dispute is Granted
 Dispute is correct
 Amount of change is paid on next
settlement statement for a trade day
23
Dispute Resolution
Dispute is Granted with Exceptions
 Dispute is partially correct
 Amount of granted change is paid on next
settlement statement for a trade day
 Reasons for exception stated on dispute
 MP may accept or reject resolution
24
Dispute Resolution
Dispute is Denied
 Settlement Statement is correct
 No change on Settlement
statement
 MP may take dispute to ADR
25
Questions
26
Data Extracts
27
Data Extracts
Learning Objectives:
 What are Data Extracts?
 Where do I find the Data Extracts?
 What’s in the Data Extracts?
28
What are Data Extracts?
Extracts in a Nutshell
 Supplemental data to allow Market Participants a
view into ERCOT’s operational and commercial
systems.
 Files in .csv format that contain either Public
Market data or Market Participant specific data,
delivered in a .zip file.
 DDL files are provided in the TML public folder to
structure a database.
29
What are Data Extracts?
What is this stuff?
Extracts
& .DDLs
MOS
POS
Data Warehouse
Settlements
and Billing
Database
Initial
Scheduled
Extracts
Load
Profiling
Report
Explorer
Meter Data
Customer
Registration
Texas
Market
Link
Daily
Scheduled
Extracts
Market
Participant
30
What are Data Extracts?
How does the process work?
ERCOT TML
Market Participants’
mechanism to pull data
Market Participant’s
Database
Daily Data Extract
Powermonger (QSE)
Data
Warehouse
Initial Data Extract
DDL
31
What are Data Extracts?
How does the process work?
ERCOT TML
Market Participants’
mechanism to pull data
Market Participant’s
Database
Daily Data Extract
DDL
Data
Warehouse
•
Powermonger (QSE)
Defines a
database
structure with
field definitions
and referential
integrity
Initial Data Extract
DDL
DDL
32
What are Data Extracts?
How does the process work?
ERCOT TML
Market Participants’
mechanism to pull data
Market Participant’s
Database
Daily Data Extract
Powermonger (QSE)
Initial Data Extract
Data
Warehouse
•
•
Provides a
complete set of
tables, including
static tables
Typically
provides a month
of data from the
date of request
Initial Data Extract
Initial Data
DDL
DDL 33
What are Data Extracts?
How does the process work?
ERCOT TML
Daily Data Extract
•
•
Typically provides
all data that
changed within a
24 hour period
Needs to be
scheduled only
once.
Market Participants’
mechanism to pull data
Market Participant’s
Database
Daily Data Extract
Powermonger (QSE)
Data
Warehouse
Initial Data Extract
Day 1 Data
Initial Data
DDL
DDL 34
What are Data Extracts?
How does the process work?
ERCOT TML
Daily Data Extract
•
•
Typically provides
all data that
changed within a
24 hour period
Needs to be
scheduled only
once.
Market Participants’
mechanism to pull data
Daily Data Extract
Day 2 Data
Powermonger (QSE)
Data
Warehouse
Market Participant’s
Database
Initial Data Extract
Day 1 Data
Initial Data
DDL
DDL 35
What are Data Extracts?
How does the process work?
ERCOT TML
Daily Data Extract
•
•
Typically provides
all data that
changed within a
24 hour period
Needs to be
scheduled only
once.
Market Participants’
mechanism to pull data
Daily Data Extract
Day ‘n’
.
.
.
Day 3 Data
Day 2 Data
Powermonger (QSE)
Data
Warehouse
Market Participant’s
Database
Initial Data Extract
Day 1 Data
Initial Data
DDL
DDL 36
Data Extracts
Learning Objectives:
 What are Data Extracts?
 Where do I find the Data Extracts?
 What’s in the Data Extracts?
37
Where Do I Find the Data Extracts?
How to Schedule Extracts
1
2
3
4
38
Where Do I Find the Data Extracts?
How to Schedule Extracts





Go to Archive tab of TML
Select “Schedule/Unschedule an Extract”
Select Extract to schedule or unschedule
Extracts available depend on market participant user role
Also “Schedule Extract Audit” displays an audit list of
extracts scheduled and produced for the market
participant as well as the capability to unschedule
extracts
39
Where Do I Find the Data Extracts?
Public Extracts
Public extracts are
posted in the Public
TML folder. They are
not scheduled but
are posted
automatically by
ERCOT
DDLs found
here!
40
Where Do I Find the Data Extracts?
Public Extracts
41
Where Do I Find the Data Extracts?
DDL Files
Public Market Data
Extract Data Definitions
42
Where Do I Find the Data Extracts?
DDL Files
ext.(02-26-2007 17:35:21).Resource_IDv1.sql
43
Data Extracts
Learning Objectives:
 What are Data Extracts?
 Where do I find the Data Extracts?
 What’s in the Data Extracts?
44
What’s in the Data Extracts?
Extract User Guides
http://www.ercot.com/services/userguides/index.html
45
What’s in the Data Extracts?
Types of Information Available
Market and Operations data is available immediately following the
Operating Day
 Bids and Schedules
 Instructions and Deployments
 Clearing Prices
 Resource Plans
Remainder of data is available after settlement of the Operating Day
 Aggregated data (Load, Generation)
 Settlement data
 Billing Determinants
 Charge Types
46
Data Extracts
Scheduled Extracts
Settlement & Billing (QSE)
 Provides the QSE with all settlement billing determinants
used for calculating the charge types that appear on their
settlement statement.
 Provides public settlement information such as market
clearing prices and factor values (i.e. Fuel Index,
Uninstructed Factor, etc.).
 Data is packaged by Settlement Batch run after all Operating
Days in the Batch are approved.
47
Data Extracts
Scheduled Extracts
Load (QSE, LSE)
 Provides aggregated load totals at various stages of loss
compensation.
 Provides public load data such as premise information and
factor values (i.e. UFE allocation factors, average daily
usage by profile class, etc.).
 Data is packaged by Settlement Batch run after all Operating
Days in the Batch are approved.
48
Data Extracts
Scheduled Extracts
Generation (QSE, RES)
 Provides aggregated generator site totals, generator splitting
percentages and DC Tie import data.
 Provides public generation data such as premise information
and factor values (i.e. Fuel Index, Resource Category
Generic Costs).
 Data is packaged by Settlement Batch run after all Operating
Days in the Batch are approved.
49
Data Extracts
Scheduled Extracts
Settlement Input Data Extract (QSE)
 Contains data formerly distributed in the Settlements &
Billing and Load Extracts since 2002
 Lodestar Batch Extracts moved to a batch focused
distribution
 Input data for the batch process is sent to the market in a 24
hour load window through this extract
50
Data Extracts
Scheduled Extracts
Bids and Schedules (QSE)
 Reflects back to the QSE the energy schedules and
resource plans they have submitted.
 Contains data that was entered or changed the previous day.
Ancillary Services (QSE)
 Reflects back to the QSE the schedules and bids they have
submitted to ERCOT for all Ancillary Service Markets
 Provides general market information such as capacity
market schedules, quantities required for each capacity
service and Market Clearing Prices for Capacity.
 Contains data that was entered or changed the previous day.
51
Data Extracts
Other Scheduled Extracts
Resource ID Extract (QSE, RES)
ESIID Usage and Service History (scheduling not yet available)
 Provides usage (MWh) data for both IDR and Non-IDR
customers.
 Provides time windows of service history for ESIIDs.
Siebel Service Order Extract (scheduling available June 2007)
52
Data Extracts
Public Extracts
Market Information
 Provides all participants with general information about
market processes. This information includes market
schedules, timing of market studies, and the market
solutions determined by these studies.
 Contains data that was created the previous day.
Forecast Data
 Provides all participants with ERCOT's load forecast data
and the weather forecast data used to produce it.
 Contains data that was created the previous day.
53
Data Extracts
Public Extracts
Some Other Public Extracts
 Forecasted and Actual Distribution Loss Factors
 Forecasted and Actual Transmission Loss Factors
 Forecasted and Backcasted Load Profiles
 Public Reference Data Extracts
 Various extracts of 6-month old data
54
Data Extracts
Zip file
with .csv
files
Packaging of Extracts
55
Questions
56