1 ercot billing, settlement disputes & data extracts module 5
TRANSCRIPT
1
ERCOT Billing,ERCOT Billing,Settlement Disputes Settlement Disputes
& Data Extracts & Data Extracts
Module 5
2
ERCOT Billing
3
Learning Objectives:Learning Objectives:
Billing OverviewBilling Overview
Invoice Payment ProcessInvoice Payment Process
Example Statement and InvoiceExample Statement and Invoice
ERCOT Billing
4
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?
Settlement and Billing in a NutshellSettlement and Billing in a Nutshell
Billing Overview
5
Energy consumed (Operating Day)Day 0
Day 10
Day 59
6 Months
Initial Settlement information provided
Final Settlement for day 0 provided
True-Up Settlement
Billing Overview
Settlement TimelineSettlement Timeline
6
Other Useful Settlement InformationOther Useful Settlement Information
7
Learning Objectives:Learning Objectives:
Billing OverviewBilling Overview
Invoice Payment ProcessInvoice Payment Process
Example Statement and InvoiceExample Statement and Invoice
ERCOT Billing
8
Generation Load
How does ERCOT pay Generators?
How does the money flow?How does the money flow?
Invoice Payment Process
9
Invoice Payment RequirementsInvoice 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
Invoice Payment Process
10
MP payment to ERCOT due by
COB (1700 CPT) on due date
ERCOT receives payment and
verification processbegins.
MP receives and verifies payment
from ERCOT
ERCOT submits all payments to
MPs by COB the following day
The Big Picture
Invoice Payment Process
11
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
Partial PaymentsPartial Payments
Invoice Payment Process
12
Learning Objectives:Learning Objectives:
Billing OverviewBilling Overview
Invoice Payment ProcessInvoice Payment Process
Example Statement and InvoiceExample Statement and Invoice
ERCOT Billing
13
Net Settlement by Charge Type
Settlement Total for Operating Day
Trade Date Info
Settlement Statement
14
ERCOT INVOICE
2705 West Lake Drive Invoice No: 00001
Taylor, TX 76754-2136 Invoice Date: 06/14/01
fax (512) 248-3095
Invoice Recipient
Name 0 >30 days >30 days
Address ($2,523,400.00) $0.00
City Cedar Park State TX 78710
Phone (512) 555- 1000
ID
I n accordance with ERCOT Protocols, I nvoices must be paid in full, regardless of disputes to avoid
jeopardizing your certification to participate in the market.
Category Amount Subtotal
Initial Statements(773,400.00)$ (500,000.00)$ (250,000.00)$ (100,000.00)$ (250,000.00)$ (500,000.00)$ (150,000.00)$
($2,523,400.00)
20010603
Outstanding Money
Description
2001060120010602
Zip
QSE1 Generation
111 Capacity Circle
06072001- QSE1G
(512) 248-3000
06012001- QSE1G06022001- QSE1G06032001- QSE1G
Transaction Number
06042001- QSE1G06052001- QSE1G06062001- QSE1G
20010604200106052001060620010607
Initial Settlement Subtotal
QSE1- 100
$0.00
($2,523,400.00)
Remittance Information
ISO Account: Recipient Account:
I n the event that your payment is not received by 10:00 am Central Prevailing Time on: 20010716
a late fee of 0.066031% per day will be applied to any outstanding balance.
Payments will be made to the I nvoice recipient by 2:00 pm Central Prevailing Time on:20010716
Account Name QSE1 Generation
123456789
1111111111
ABA Routing Number
Account No.
ERCOT ISO
121367893
8750356450
Other Charges Subtotal
Net Amount Owed (Due)
Net amount owed by the QSE or, in this case, due to the QSE
Sample Invoice
15
Questions
16
Settlement Disputes
17
Learning Objectives:Learning Objectives:
Dispute TimelineDispute Timeline
ResponsibilitiesResponsibilities
ERCOT ResolutionERCOT Resolution
ERCOT Billing
18
Day 0
Day 10
Day 20
Day 59
Day 69
Day 170
Day 180
Day 190
Energy consumed (Operating Day)
Initial Settlement information provided for Day 0
Timely Disputes for Initial Settlement due
Final Settlement information for Day 0 provided
Timely Disputes for Final Settlement due
All Disputes Due
True-Up Settlement
Dispute on True-Up Due
Dispute Timeline
19
Learning Objectives:Learning Objectives:
Dispute TimelineDispute Timeline
ResponsibilitiesResponsibilities
ERCOT ResolutionERCOT Resolution
ERCOT Billing
20
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”.
QSE Responsibility
Responsibilities
21
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.
ERCOT Responsibility
Responsibilities
22
Learning Objectives:Learning Objectives:
Dispute TimelineDispute Timeline
ResponsibilitiesResponsibilities
ERCOT ResolutionERCOT Resolution
ERCOT Billing
23
Dispute is correct Amount of change is paid on next
settlement statement for a trade day
Dispute Resolution
Dispute is Granted
24
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
Dispute Resolution
Dispute is Granted with Exceptions
25
Settlement Statement is correct No change on Settlement
statement MP may take dispute to ADR
Dispute Resolution
Dispute is Denied
26
Questions
27
Data Extracts
28
Learning Objectives:
Data Extracts
What are Data Extracts?What are Data Extracts?
Where do I find the Data Extracts?Where do I find the Data Extracts?
What’s in the Data Extracts?What’s in the Data Extracts?
29
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.
What are Data Extracts?
Extracts in a NutshellExtracts in a Nutshell
30
Settlementsand Billing
MOS
LoadProfiling
POS
Meter Data
Database
Data Warehouse
Report Explorer
RegistrationCustomer
MarketParticipant
DailyScheduled Extracts
Extracts
& .DDLs
Texas Texas Market Market
LinkLink
InitialScheduled Extracts
What is this stuff?What is this stuff?
What are Data Extracts?
31
DDL
ERCOT TML Market Participants’ mechanism to pull data
Initial Data Extract
Daily Data Extract
DataWarehouse
Market Participant’sDatabase
How does the process work?How does the process work?
What are Data Extracts?
Powermonger (QSE)Powermonger (QSE)
32
Powermonger (QSE)Powermonger (QSE)
DDL
Market Participants’ mechanism to pull data
Initial Data Extract
Daily Data Extract
DataWarehouse
Market Participant’sDatabase
• Defines a database structure with field definitions and referential integrity
DDL
DDL
What are Data Extracts?
ERCOT TML
How does the process work?How does the process work?
33
Powermonger (QSE)Powermonger (QSE)
DDL
Market Participants’ mechanism to pull data
Initial Data Extract
Daily Data Extract
DataWarehouse
Market Participant’sDatabase
DDL
Initial Data
• Provides a complete set of tables, including static tables
• Typically provides a month of data from the date of request
Initial Data Extract
What are Data Extracts?
ERCOT TML
How does the process work?How does the process work?
34
Powermonger (QSE)Powermonger (QSE)
ERCOT TML
DDL
Market Participants’ mechanism to pull data
Initial Data Extract
Daily Data Extract
DataWarehouse
Market Participant’sDatabase
DDL
Initial Data
• Typically provides all data that changed within a 24 hour period
• Needs to be scheduled only once.
Daily Data Extract
Day 1 Data
What are Data Extracts?
How does the process work?How does the process work?
35
ERCOT TML
Powermonger (QSE)Powermonger (QSE)
DDL
Market Participants’ mechanism to pull data
Initial Data Extract
Daily Data Extract
DataWarehouse
Market Participant’sDatabase
DDL
Initial Data
• Typically provides all data that changed within a 24 hour period
• Needs to be scheduled only once.
Daily Data Extract
Day 1 Data
Day 2 Data
What are Data Extracts?
How does the process work?How does the process work?
36
ERCOT TML
Powermonger (QSE)Powermonger (QSE)
DDL
Market Participants’ mechanism to pull data
Initial Data Extract
Daily Data Extract
DataWarehouse
Market Participant’sDatabase
DDL
Initial Data
• Typically provides all data that changed within a 24 hour period
• Needs to be scheduled only once.
Daily Data Extract
Day 1 Data
Day 2 Data
Day 3 Data
.
.
.
Day ‘n’
What are Data Extracts?
How does the process work?How does the process work?
37
Learning Objectives:
Data Extracts
What are Data Extracts?What are Data Extracts?
Where do I find the Data Extracts?Where do I find the Data Extracts?
What’s in the Data Extracts?What’s in the Data Extracts?
38
How to Schedule ExtractsHow to Schedule Extracts
Where Do I Find the Data Extracts?
11
22
3344
39
How to Schedule ExtractsHow to Schedule Extracts
Where Do I Find the Data 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
40
Public extracts are posted in the Public TML folder. They are not scheduled but are posted automatically by ERCOT
Public ExtractsPublic Extracts
Where Do I Find the Data Extracts?
DDLs found DDLs found here!here!
41
Public ExtractsPublic Extracts
Where Do I Find the Data Extracts?
42
Public Market Data
Extract Data Definitions
DDL FilesDDL Files
Where Do I Find the Data Extracts?
43
ext.(02-26-2007 17:35:21).Resource_IDv1.sql
DDL FilesDDL Files
Where Do I Find the Data Extracts?
44
Learning Objectives:
Data Extracts
What are Data Extracts?What are Data Extracts?
Where do I find the Data Extracts?Where do I find the Data Extracts?
What’s in the Data Extracts?What’s in the Data Extracts?
45http://www.ercot.com/services/userguides/index.html
What’s in the Data Extracts?
Extract User Guides
46
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
What’s in the Data Extracts?
Types of Information Available
47
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.
Data Extracts
Scheduled Extracts
48
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.
Data Extracts
Scheduled Extracts
49
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.
Data Extracts
Scheduled Extracts
50
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
Data Extracts
Scheduled Extracts
51
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.
Data Extracts
Scheduled Extracts
52
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)
Data Extracts
Other Scheduled Extracts
53
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.
Data Extracts
Public Extracts
54
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
Data Extracts
Public Extracts
55
Data Extracts
Packaging of ExtractsZip file Zip file
with .csv with .csv filesfiles
56
Questions