Docstoc

Extract__Report_Incident_Log_11-14-2008

Document Sample
Extract__Report_Incident_Log_11-14-2008 Powered By Docstoc
					Document Definition:
This document is a summary of ERCOT IT incidents, or service delivery failures related to Data Extracts & Reports that have been designated as Priority 1 extracts & reports by the Data Extracts Working Group
This document also contains application availability reports for Data Extracts & Reports IT Applications

Spreadsheet Tab:                                       Contents:

Ext Rpt Annual Summary:                                This tab summarizes the annual cumulative number of incidents by root cause, when the timeliness, completeness or accuracy of extracts or reports occurred

Ext Rpt Monthly Summary:                               This tab summarizes the number of incident types by month to inform the reader of what month to examine for detailed information regarding an incident
                                                       when the timeliness, completeness or accuracy of extracts or reports was affected.

Detailed Incident data:                                This tab contains the detailed information for each incident summarized on the annual and monthly tabs

TML Report Explorer Availability                       Data Extracts & Reporting IT Application (TML Report Explorer) availability

Retail API Availability                                Data Extracts & Reporting IT Application (Retail API) availability

Extract & Report Info                                  An information guide to extracts and reports provided by ERCOT to Market Participants

MOS Public Reports                                     Contains a list of MOSPUBLIC reports as an addendum to Extract & Report Information Guide

General Definitions:

Outage                                                 An unplanned change in ERCOT IT systems that prevents users from being able to access the systems

Degradation:                                           An event that causes the normal levels of ERCOT IT systems to be impacted while still allowing for minimal processing of or access to these systems

Incident Types, Impacts and Glossary of Terms

Term                                                   Definition:

TML Report Explorer Application                        A TML Report Explorer outage caused by failure of the application (not infrastructure)
Retail API                                             A Retail API outage caused by failure of the Retail API application (not infrastructure)
Database                                               A data extracts & reporting service incident caused by a database outage
Infrastructure                                         A data extracts & reporting service incident caused by an infrastructure failure (server, switch, etc…)
Human Error                                            A data extracts & reporting service incident caused by human error
TML Application                                        A TML outage caused by failure of the TML application (not infrastructure)
TML Connectivity                                       An incident resulting in the inability of Market Participants being able to connect to TML
TML Functionality Error                                A failure of TML to function correctly
Other                                                  A data extracts & reporting service incident that is not described by another defined incident type
Incident                                               Any event that causes the agreed levels of service of ERCOT IT systems to be impacted
Slow System Performance                                A data extracts & reporting service impact resulting in abnormally slow or delayed response to extracts and reports queries
Timeliness                                             A data extracts & reporting service impact resulting in noncompliance of delivery time requirements of an extract or a report, as specified in Protocols or Market Guides
Completeness                                           A data extracts & reporting service impact resulting in noncompliance of content requirements of an extract or a report, as specified in Protocols or Market Guides
Accuracy                                               A data extracts & reporting service impact resulting in noncompliance of accuracy requirements of an extract or a report, as specified in Protocols or Market Guides
Availability                                           The ability of a component or IT service to perform its required function over a stated period of time
Planned Outage                                         A planned change in ERCOT IT systems that prevents users from being able to access the systems
Unplanned Outage                                       An unplanned change or incident in ERCOT IT that prevents users from being able to access the systems
Gross minutes                                          Total minutes in a month
Net minutes                                            Gross minutes minus planned outage minutes
Planned outage minutes                                 Minutes used by ERCOT during the maintenance and release windows
Unplanned outage minutes                               Minutes retail transaction processing services were not available that are outside of the planned use of the maintenance and release windows
Exception outage minutes                               Minutes outside of the maintenance and release outage windows that have been granted exception from the availability metric (TX Set, etc.)
Service availability percent                           The percent of time that retail transaction processing services were available, not including planned outage minutes
ERCOT IT Incident Summary
Data Extracts & Reports Service
Annual Summary

                       Data Extracts & Reports Service
2008 Year To Date

Incident - Root Cause                          Incident - Effect
                                  Number of                         Number of
Root Cause                       occurrences   Resulting effect    occurrences

Software                              5        Timeliness               9

Database                              4        Completeness             9

Infrastructurre                       4        Accuracy                 1

Human Error                           1        Availability             3

Source System Issues                  8        Other                    3

Other                                 3
ERCOT IT Incident Summary
Data Extracts & Reports Service
Monthly Summary

                       Incident - Root Cause                                                                 Incident - Effect




                                                                  Source System Issue




                                                                                                              Completeness
                                   Infrastructure

                                                    Human Error




                                                                                                Timeliness




                                                                                                                                        Availability
                        Database




                                                                                                                             Accuracy
            Software




                                                                                        Other




                                                                                                                                                       Other
   2008
January

February

March       4                      1                1                                           2             5

April       1           1                                                               2       1             1

May                     1          1                                                                                                                   2

June                               2                                                            1                                                      1

July                    1                                         2                             2                                       2

August

September               1                                         1                     1       1             1                         1

October                                                           5                             2             2              1

November

December

YTD         5           4          4                1             8                     3       9             9              1          3              3
ERCOT IT Incident Summary
Data Extracts & Reports and IT Applications Services
Detailed Incident Data
                             Initial                                                                                                    Service Impact (Timeliness,
                           Notification                                         Duration    Application         Extract or Report       Accuracy, Completeness or                                                                                                                   ERCOT Protocols                                    Identified by (ERCOT Internal                                               Date (to be)
 Month       Issue Date       Date        Notification ID Start Time End Time    (mins)      Impacted               Impacted                    Availability)                                Issue Description                                        Root Cause                      Missed (Y/N)     Market Participant Input                     / MP)                           Resolution                    Implemented                          Notes                             Current Status
                                                                                                                                                                      An automated process that generates the daily Service Order
                                                                                                                                                                      Extracts was not successfully completed as scheduled on           An automated process that generates
                                                                                                                                                                      November 6, 2008. As a result, ERCOT experienced a delay         the daily Service Order Extracts was not
                                                                                                               Siebel Service Order                                   in posting the Siebel Service Order Extracts for November 6,     successfully completed as scheduled on
   Nov        11/6/08        11/7/08      R-A110708-01      n/a      11/7/08      n/a      Report Explorer           Extracts                   Timeliness            2008.                                                                       November 6, 2008                         y                                                  ERCOT Internal                  restart of scheduled task                                                                              Complete

                                                                                                                                                                      The Settlement and Billing Extracts due to be posted on
                                                                                                                                                                      October 10, 2008, October 11, 2008 and October 12, 2008
                                                                                                                                                                      have been removed from TML. The affected extracts had
   Oct        10/10/08      10/13/08      W-A101308-01      n/a     10/14/08      n/a      Report Explorer    Settlements and Billing         Completenenss           missing private interval data files.                                   Change in system behavior.                    n                                                  ERCOT Internal               Adjustment of extract creation                                                                            Complete
                                                                                                                                                                      The Generation Extracts due to be posted on October 8, 2008
                                                                                                                                                                      have been removed from TML. The affected extracts had
   Oct        10/8/08        10/9/08      M-A100908-01      n/a     10/10/08      n/a      Report Explorer     Generation Extracts         Timeliness & Accuracy      duplicate interval data included in the private files.                 Change in system behavior.                    y                                                  ERCOT Internal               Adjustment of extract creation                                                                            Complete
                                                                                                                                                                      The Settlement Input Data (SID) and the Market Shadow
                                                                                                                                                                      Prices (SHP) extracts due to be posted on Thursday, October
                                                                                                                                                                      2, 2008 have been corrected and re-posted.
   Oct        10/2/08        10/3/08      W-A100308-01      n/a      10/3/08      n/a      Report Explorer    Multiple-SID and SHP      Completenenss & Timeliness                                                                           Change in system behavior.                    y                                                  ERCOT Internal               Adjustment of extract creation                                                                            Complete

                                                                                                                                                                                                                                         Performance of the Settlements and
                                                                                                                                                                                                                                       Billing database were poor and required
   Sep         9/3/08        9/3/08       M-A090308-01    4:30PM     5:03PM       33            TML                    TML                      Availability          Unplanned outage had cross impact with regards to TML                      an emergency outage                       y                                                    Monitoring                          no required                      9/3/08                                                          Complete
                                                                                                                                                                      Due to a high volume of data processing through the data
                                                                                                                                                                      archive because of preparations for Hurricane Ike, ERCOT                                                                                                                                            Extracts have been posted after
   Sep        9/21/08        9/22/08      M-A092208-01    9/21/08    9/27/08      n/a      Report Explorer          Multiple-12                 Timeliness            has not posted several extracts.                                preparations for Hurricane Ike                       y                                                  ERCOT Internal                   replication cought up.                9/27/08                                                         Complete

                                                                                                                                                                                                                                      The Settlement Input Data (SID) and the                                                                                           The SID and SHP Extract posted for
                                                                                                                                                                                                                                      Market Shadow Prices (SHP) extracts                                                                                              the Initial Settlement of Operating Day
                                                                                                                                                                      The SID and SHP extracts that were posted had incomplete        posted on Monday, September 8, 2008                                                                                                 September 5, 2008 reposted on
   Sep         9/8/08        9/8/08       M-A090808-02    9/8/08     9/16/08      n/a      Report Explorer    SID and SHP Extracts      Completenenss & Timeliness    data for Operating Day September 5, 2008.                       were affected by a processing issue.                Y                                                   ERCOT Internal                     September 16, 2008.                 9/16/08                                                         Complete

                                                                                                                                                                      ERCOT has posted the Settlement Input Data Extract (SID)
                                                                                                                                                                      later than required. The extracts that should have posted
                                                                                                              Settlements input Data                                  prior to midnight were posted at approximately 2:30 am on                                                                                                                                            Extract has been posted after
   Aug        8/28/08        8/28/08      M-A082808-01     8/30      2:30 AM    150 min.   Report Explorer           Extract                    Timeliness            August 28, 2008.                                                System performance degradation                      Y                                                   ERCOT Internal                        completion                       8/28/08                                                         Complete
                                                                                                                                                                      The Report Explorer functionality of the Texas Market Link
                                                                                                                                                                      (TML) is currently experiencing technical difficulties. Some    ERCOT has made adjustments to the
                                                                                                                                                                      Market Participants are receiving this message “The system is   affected server and has observed
                                                                                                                                                                      not responding” when attempting to access Report Explorer       improvements in performance. ERCOT
                                                                                                                                                                      but, have been able to access extracts and reports after        will continue to monitor performance and                                                                                         ERCOT has made adjustments to the
   Aug        8/13/08        8/17/08           n/a          n/a        n/a        n/a      Report Explorer         Multiple - All               Availability          several attempts.                                               make adjustments if needed                          N                                                   ERCOT Internal                    affected server                      8/17/08       this was not an outage.                           Complete
                                                                                                                                                                      Due to a data corruption issue which began on August 8,
                                                                                                                                                                      2008, ERCOT removed the affected database from service in       ERCOT has repaired the data corruption                                                                                            Extracts have been regenerated and
   Aug         8/8/08        8/9/08       M-A080908-01      n/a       8/21        n/a      Report Explorer           Multiple              Timeliness & Accuracy      order to recover and repair the data corruption.                and posted the delayed data.                        Y                                                   ERCOT Internal                          reposted                       8/9/08                                                          Complete

                                                                                                                                                                                                                                      ERCOT determined the root cause to be
                                                                                                                                                                      The Load, Generation and Settlements and Billing extracts       a settlement backout and rerun for trade
                                                                                                                                                                      posted at approximately 6:00 PM on August 5, 2008. The          date February 3, 2008 which caused the
                                                                                                                                                                      Operating Days affected are July 24, 2008, June 5, 2008 and     other trade dates to be missed in the                                                                                             Extracts have been regenerated and
   Aug         8/5/08        8/6/08       M-A080508-01      n/a        n/a        n/a      Report Explorer          Multiple - 3              Completenenss           February 3, 2008.                                               generation of the above extracts.                   Y                                                   ERCOT Internal                          reposted                       8/6/08                                                          Complete


                                                                                                                                                                      ERCOT experienced multiple outages of Texas Market Link                                                                                                                                          The Enterprise Application Integration
                                                                                                                                                                      (TML) Report Explorer functionality on July 21, 2008 from 5:05 Enterprise Application Integration Server                          Report explorer was not                                         Server and TML Proxy Server were
   July       7/22/08        7/22/08      M-A072208-01    9:33AM     11:03AM      90       Report Explorer           Multiple                   Availability          PM to 7:11 PM, and July 22, 2008 from 9:33 AM to 11:03 AM      issue                                                N                    available                      ERCOT Internal                         restarted                       7/22/08                                                         Complete

                                                                                                                                                                      ERCOT experienced multiple outages of Texas Market Link                                                                                                                                          The Enterprise Application Integration
                                                                                                                                                                      (TML) Report Explorer functionality on July 21, 2008 from 5:05 Enterprise Application Integration Server                          Report explorer was not                                         Server and TML Proxy Server were
   July       7/21/08        7/22/08      M-A072208-01    5:05PM     7:11PM       126      Report Explorer           Multiple                   Availability          PM to 7:11 PM, and July 22, 2008 from 9:33 AM to 11:03 AM      issue                                                N                    available                      ERCOT Internal                         restarted                       7/21/08                                                         Complete
                                                                                                                                                                                                                                     ERCOT determined the root cause to be
                                          M-A071808-01,                                                        Backcasted Profiles                                    The Backcasted Profiles Extract for July 16, 2008 was posted a database component that encountered                                                                                                Exception was corrected and extract
   July       7/18/08        7/18/08         02, 03         n/a        n/a        n/a            n/a                Extract                     Timeliness            on Friday, July 18, 2008                                       an exception                                         Y                                                   ERCOT Internal                        was rerun                        7/18/08                                                         Complete
                                                                                                                                                                      Settlement Input Data (SID) and the Market Shadow Prices
                                                                                                                                                                      (SHP) due to be posted on Friday, July 11, 2008 were posted
   July       7/14/08        7/14/08      W-A071408-01      n/a        n/a        n/a            n/a          SID and SHP Extracts              Timeliness            later than expected                                            due to a delay in batch processing                   N                                                   ERCOT Internal                     Batch completion                    7/14/08                                                         Complete

                                                                                                                                                                                                                                      Failure between the Application
                                                                                                                                                                      ERCOT’s Texas Market Link (TML) Report Explorer Application     Programming Interface (API) application
                                          M-A062308-01,                                                                                                               Programming Interface (API) was unavailable on Sunday,          and the Lightweight Directory Access                            Report explorer/API was not
  June        6/22/08        6/22/08           02         2:55PM     4:00PM       65       Report Explorer           Multiple                   Availability          June 22, 2008 from 2:55 PM to 4:00 PM.                          Protocol (LDAP) server                              N                     available                     ERCOT Internal                Completion of maintenance                6/22/08                                                         Complete
                                                                                                               Actual Transmission                                    Due to an infrastructure component the extract has not been                                                                     Extract has been posted past
  June        6/27/08        6/25/08      M-X062708-01      n/a        n/a        n/a            n/a               Loss Factor                  Timeliness            posted in time                                                  Infrastructure issue                                Y                      6:00 AM                      ERCOT Internal                 Extract has been reposted              6/27/2008                                                        Complete
                                                                                                                                                                      This outage was caused by unplanned maintenance of the
                                                                                                                                                                      Settlements & Billing Database. This maintenance project
                                                                                                                                                                      required the Settlements & Billing Database and the
                                                                                                                                                                      Enterprise Application Integration server to be shut down.
                                                                                           Report Explorer,                                                           These outages caused the web components to be                   Database issue and interdependency of                             Report explorer was not
   May        4/30/08        5/1/08       M-A043008-01    3:50PM     5:06PM       76           Retail                Multiple                   Availability          unavailable.                                                    multiple components                                 N                    available                      ERCOT Internal                Completion of maintenance                4/30/08                                                         Complete
                                                                                           Report Explorer,                                                           Due to an infrastructure component several services had been                                                                      Report explorer was not
   May         5/7/08        5/7/08       M-A050708-01    2:35PM     2:55PM       20         Retail API              Multiple                   Availability          unavailable                                                     Infrastructure issue                                N                    available                      ERCOT Internal            Recycle of infrastructure component         5/7/2008                                                         Complete

                                                                                                                                                                                                                                                                                                        The first extracts (after
                                                                                                                                                                                                                                                                                                        incident) had not been
                                                                                                                                                                                                                                                                                                       delivered completely & on                                       1. Synchronize source with target
                                                                                                                                                                                                                                      Several Market Information Extracts were                                    time.                                                database
                                                                                                                                                                                                                                      affected due to a database failover on                           The first 30-day Initial will                                   2. restore data which had been            1. completed by
                                                                                                                                                                                                                                      April 21, 2008 which resulted in an out-of-                      post at the end of May for                                      submitted during logical standby          end of April
  April      4/21 - 4/30      4/23        W-A042308-01      n/a        n/a        n/a            n/a                Multiple - 8        Completeness & Timeliness     Some Extracts were affected as a result of a database failover. synch situation.                                    Y            data from May 1 forward.               ERCOT Internal           rebuild.                                  2. n/a                                                              Complete



                                                                                                                                                                       ERCOT's Texas Market Link Find ESIID, Find Transactions,   This outage was caused by unplanned
                                          M-A043008-01,                                    Report Explorer;                                                           Report Explorer, and eServices components were unavailable maintenance of the Settlements & Billing                                report explorer was not                                           Application and database were
  April      4/30/2008      4/30/2008          02         3:50PM     5:06PM       76         Retail API              Multiple                   Availability                                on April 30, 2008                                  Database.                                  N                     available                     ERCOT Internal                          restarted                     4/30/2008         Application and database were restarted        Complete


                                          M-A041408-01,                                                                                                                                                                                                                                                  report explorer was not
  April      4/14/2008      4/14/2008          02         7:23AM     8:35AM       72       Report Explorer           Multiple                   Availability          ERCOT's Texas Market Link Report Explorer was unavailable                Root cause is unknown                      N                     available                     ERCOT Internal               The application was restarted            4/14/2008              The application was restarted             Complete



                                                                                                                                                                                                                                                                                                         report explorer was not
  April       4/8/2008         n/a             n/a        1:51PM     2:17PM       28       Report Explorer           Multiple                   Availability          ERCOT's Texas Market Link Report Explorer was unavailable               Issue with LDAP directory                   N                     available                     ERCOT Internal              Restart of LDAP and application           4/8/2008              Restart of LDAP and application            open ticket with vendor


                                                                                                                                                                      Permissions issue between the Settlements & Billing database
                                                                                                                                                                      and the EDI component used to load 867 data caused some
                                          R-A031208-01                                                                                                                files to not be processed during report generation.
                                               &                                                               867_03 Error Report                                    Update: Ergot has identified sixty additional NIDR 867_03 files Configuration, permissions issue                                                                                                  Granted the appropriate permissions
  March      3/10 - 3/21      3/12        M-A031208-09    10-Mar     21-Mar       n/a            n/a             (Activity Report)            Completeness            that were not loaded into S&B application.                      following a retail release                          N                                                   ERCOT Internal               and manually reprocessed files              n/a                                                           Complete
                                                                                                                                                                                                                                                                                                                                                                        Eventual resolution was a rollback of
                                                                                                               867 -03 Error Report                                   EDI system processing delays caused a delay in the posting      EDI system delays due to failed retail                                                                                             the EDI infrastructure causing the
  March         3/13          3/14        R-A031408-01      n/a        n/a        n/a            n/a             (Activity Report)              Timeliness            of the NIDR 867_03 activity reports for 3/13                    release                                             N                                                   ERCOT Internal                  delays in EDI processing                3/22                                                           Complete
                                                                                                                                                                                                                                                                                                                                                                            Eventual resolution will be the
                                                                                                                                                                      ERCOT's retail and wholesale systems were offline due to        Batch processing delays due to SAN                                                                                                  replacement of this infrastructure         5/3 - 5/4
  March      3/15 - 3/17      3/17        M-A031708-01      n/a        n/a        n/a            n/a                Multiple - 6                Timeliness            SAN infrastructure failures                                     infrastructure failures                             Y                                                   ERCOT Internal               during the first weekend in May         (estimated)                                                       Complete
                                                                                                              Settlement and Billing                                                                                                                                                                                                                                    Timeframe corrected and the extract       Scheduled for
  March                       3/21        W-A031708-01      n/a        n/a        n/a            n/a                 Extract                  Completeness            Daylight savings time issue that did not show up in testing     Software Code                                       N                                                   ERCOT Internal                          was rerun                     mid 2008                                                         Complete
                                                                                                                                                                                                                                                                                                                                                                         Corrected configuration and reran
  March         3/26          3/26        M-A032608-01      n/a        n/a        n/a            n/a                Multiple - 3              Completeness            Configuration error during the transition to a new server       Configuration                                       N                                                  Market Participant                         extracts                     26-Mar                                                          Complete
                                                                                                                                                                      The Load Extract that originally posted on 3/28 was missing
                                                                                                                                                                      public data as well as delay in posting of the Load Extract for
  March      3/28 - 3/29      3/31        M-A033108-01      n/a        n/a        n/a            n/a               Load Extract         Completeness & Timeliness     some Market Participants on 3/29                                Timing issues with job schedules                    Y                                                   ERCOT Internal               Job schedules timing adjusted              2-Apr                                                          Complete
                                                                                                              Settlement and Billing                                  The Settlement and Billing extract for 3/28 was missing public Multiple report generations running                                                                                                                                                           This incident is related to the same root cause
  March         3/28           4/9        W-A040908-01      n/a        n/a        n/a            n/a                 Extract                  Completeness            data.                                                           concurrently                                        N                                                  Market Participant            Job schedules timing adjusted             30-Mar        as Load Extract issue                             Complete
                                      2008 Retail API Availability
99% Availability Target
                                           Gross Available       Planned Outage       Net Available         Unplanned           Percent
    Month                   Service           Minutes                Minutes            Minutes           Outage Minutes       Availability
Example:
January     Retail API Application

February    Retail API Application

March       Retail API Application

April       Retail API Application                   43,200                  720              42,480                   76           99.82%

May         Retail API Application                   44,640                2,880              41,760                   96           99.77%

June        Retail API Application                   43,200                1,872              41,328                       0          100%

July        Retail API Application                   44,640                1,173              43,467                       0          100%

August      Retail API Application                   44,640                3,145              41,495                       0          100%

September   Retail API Application                   43,200                1,320              41,880                       0          100%

October     Retail API Application                   44,640                1,198              43,442                       0          100%

November    Retail API Application                           0                    0                   0                    0

December    Retail API Application                           0                    0                   0                    0



Jan - Dec
2008        Retail API Application                 308,160               12,308             295,852                  172           99.94%
                         2008 TML Report Explorer Application Availability
99% Availability Target
                                              Gross Available       Planned Outage       Net Available         Unplanned           Percent
    Month                 Service                Minutes                Minutes            Minutes           Outage Minutes       Availability
Example:
January     TML Report Explorer Application

February    TML Report Explorer Application

March       TML Report Explorer Application

April       TML Report Explorer Application             43,200                  720              42,480                  176            99.59%

May         TML Report Explorer Application             44,640                2,880              41,760                   96            99.77%

June        TML Report Explorer Application             43,200                1,872              41,328                   65            99.84%

July        TML Report Explorer Application             44,640                1,173              43,467                  216            99.50%

August      TML Report Explorer Application             44,640                3,145              41,495                       0        100.00%

September   TML Report Explorer Application             43,200                1,320              41,880                   33            99.92%

October     TML Report Explorer Application             44,640                1,198              43,442                       0        100.00%

November    TML Report Explorer Application                     0                    0                   0                    0

December    TML Report Explorer Application                     0                    0                   0                    0



Jan - Dec
2008        TML Report Explorer Application           308,160               12,308             295,852                  586            99.80%
Extract & Report Information Guide
VERSION 4.3, UPDATED 5-9-2008


ID             Extract or Report Name                                 Definition
       867 Received on Cancelled Service   Identifies instances where ERCOT has received either an
       Orders (RCSO) Report                867_03F Monthly Usage Final Read or an 867_04 Initial Read
 1
                                           Notification on a service order which is cancelled in the ERCOT
                                           system
       867_03 Error Report                 Responses to ERCOT data loading attempt for 867_03s into the
       (867_03 Activity Report)            Lodestar Database. This report includes both errors and
                                           successful loading responses.


 2




       997 Report                          Provides MPs and ERCOT details on any 997 "accept or reject"
                                           that ERCOT has not received from a market participant for EDI
                                           files ERCOT sent to a MP three calendar days prior.
 3



       Actual Distribution Loss Factors    Publishes the current day's actual distribution loss factors. The
                                           loss factors are published in 15 minute intervals. They are
 4
                                           divided by TDSP per loss code.

       Actual Transmission Loss Factor     This extract provides cuts of data for daily base loads plus
                                           distribution losses and transmission losses by presenting
                                           aggregate information for profiled accounts. Non-profiled
 5
                                           accounts will associate the interval data for a specific account.


       Ancillary Service Schedules         This extract publicly discloses the Ancillary Service bids and
                                           schedules for all QSE's 6 months after they are submitted.
 6



       Ancillary Services Deployments      This extract discloses total deployments of Regulation and
                                           Responsive Reserve by Operating Day. Deployments are issued
 7                                         through Automatic Governor Control (AGC). Deployment data
                                           provided in this extract is integrated into 5-minute values.

       Ancillary Services Extract          This extract provides a QSE with information about their
                                           participation in the ERCOT Ancillary Service Markets. It reflects
 8                                         back to the QSE the schedules and bids they have submitted to
                                           ERCOT for all Ancillary Service Markets.
     Backcasted Profiles Extract              Non-interval data scaled into interval data based on customer
                                              type. These interval readings are the values that were actually
                                              used for billing purposes vs. the forecasted profiles. Includes
9
                                              both Backcasted Load Profiles Extract & Auxillary Backcasted
                                              Loa

     Bids and Schedules Extract               This extract reflects back to the QSE the energy schedules and
                                              resource plans they have submitted.
10

     Data Aggregation Daily Postings          Reports UFE and all values to calculate UFE.
11

     Day Ahead Report                         Contains the hourly Ancillary Services market clearing prices
                                              (MCPCs) from the day ahead markets and shows the MWs
12
                                              ERCOT procured on behalf of QSEs who did not self-provide.

     Default Profile ESIID                    Provides MPs a listing of the ESI IDs (both NIDR & IDR) that
                                              received the non-adjusted default profile for which they were
                                              estimated in settlements by trade date.
13



     ENERGY Schedules                         This extract publicly discloses the energy schedules for all QSE's
                                              6 months after they are submitted.
14


     ESI ID Service History & Usage Extract   This data extract provides transparency to Market Participants
     (SCR727)                                 for ESI ID level data that ERCOT utilizes in market settlement
                                              and provides Market Participants with the data needed to
15                                            develop shadow settlement systems.




     Forecast Data Extract                    This extract provides all participants with ERCOT's load
                                              forecast data and the weather forecast data used to produce
16                                            it. Load forecasts are provided by load area (combination of
                                              Weather Zone and Congestion Management Zone).

     Forecasted Distribution Loss Factors     Publishes the current day's forecasted distribution loss factors.
                                              The loss factors are published in 15 minute intervals. They are
17
                                              divided by TDSP per loss code.

     Forecasted Load Profiles                 Contains forecasted load profile values by profile class in 15
                                              minute intervals.
18


     Forecasted Transmission Loss Factor      Contains data for the current day's predicted transmission
                                              losses in 15 minute intervals.
19
     Generation Extract                          Provides daily interval data including aggregated generator site
                                                 totals, generator splitting percentages and DC Tie import data.
                                                 Provides daily scalar data including fuel index, average daily
20
                                                 usage and UFE allocation factors.


     Generation Outages                          Approved generation outages that are 180 days expired.

21


     IDR Protocol Compliance Report              This report provides the number of active IDR ESIIDs for a
                                                 specified time period and determines the percentages of actual
                                                 data for that same time period.
22



     IDR Requirement Report                      The Interval Data Recorder (IDR) Requirement Report is a
                                                 monthly report that displays the ESI-IDs that are currently non-
23                                               IDR metered, but that need IDR meters installed because they
                                                 have exceeded the peak demand threshold.

     Individual AS Bid Information (Apr 2003 Information containing hourly bid prices received by ERCOT for
     and after)                              the Non-Spin, Regulation Reserve Ancillary Services (Reg Up,
                                                 Reg Down) and Responsive Reserve Ancillary Services for the
24
                                                 Day Ahead Market (data is six months and older).


     Individual BES Bid Information (Apr 2003 QSE-specific Balancing Energy bid stacks - posted 6 months
     and after)                               after operating date for April 2003 and after.
25



     Individual RPRS Bid Information (Apr        QSE-specific Replacement Reserve bid stacks - posted 6
     2003 and after)                             months after operating date for April 2003 and after.
26



     Load Estimation Counts                      Counts of ESI Ids and percentages of counts by MRE settled
                                                 with actual meter data, estimated using historical meter data,
27                                               and estimated using default load profile data.


     Load Estimation Volume                      Load volumes and percentage of load volumes in MWh settled
                                                 with actual meter data, estimated using historical meter data,
                                                 and estimated using default load profile data by TDSP.
28
     Load Extract                           Provides information that will allow Market Participants
                                            visibility into aggregated load cuts in the ERCOT systems that
29                                          are used for settlement purposes to track the amount of
                                            electric power delivered or required at a certain time.

     Load Profile ID Exceptions             A report that identifies invalid Load Profile IDs or Load Profile
                                            IDs that do not correspond with the assigned Premise Type.
30

     Mapping Status Reject Report           Identifies those files that ERCOT has rejected due to mapping
31                                          status errors. Mapping status errors are defined as not passing
                                            Texas Set Validation.
     Market Information Extract             This extract provides all participants with general information
                                            about market processes. This information includes market
                                            schedules, timing of market studies, and the market solutions
32
                                            determined by these studies.


     Market Shadow Prices Extract           Shadow Prices for Commercially Significant Constraints (CSC)
                                            for every 15 minute interval of an operating day.
33


     MIMO Exceptions Report                 Identifies exceptions as a result of transactions sent by the
                                            TDSP that may indicate an out of synch condition between
                                            ERCOT and the TDSP.
34



     Missing 867 Report                     Identifies any 867_04 Initial Meter Read Notification or
                                            867_03F Monthly Usage Final Read that is missing at ERCOT to
35                                          complete the business process of service orders that are in a
                                            status of “Scheduled”.

     Missing Consumption Report             Identifies ESI IDs for which ERCOT has not received
                                            consumption data for thirty-eight (38) days ago. Market
                                            Participants should use this report to identify situations where
36                                          consumption data has not been supplied to ERCOT.




     Pending Cancel with Exception Report   Identifies exceptions where the pending response transactions
                                            from the TDSP (i.e. 814_04, 814_25 or 814_28) have not been
                                            received by ERCOT and the 20 day expiration clock will expire
37
                                            within 10 days changing the service order status to ‘Cancel
                                            with Except
     Potential Load Loss Report             Daily extract of potential customer loss notifications based on
                                            ERCOT's receipt of the TDSP's accepted response.




38




     Profile Type Count Report              The Profile Type Count report contains a list of all Profile Types
                                            (and the associated TDSP, Weather Zone and Congestion
39
                                            Management zone) and the number of active ESIIDs belong to
                                            each.
     Public Reference Data Extract (PRDE)   This extract includes all dimensional market level tables that
40                                          are included in the ESIID Service History & Usage Extract
                                            (SCR727).
     Recorder Extract (REC)                 A Daily REC RID Extract provides special Market Participants
                                            with the data for which they have special entitlement to a
                                            UIDCHANNEL defined in the RECORDER_EXTRACT table.
41



     Resource ID Extract (RID)              This extract includes all necessary reference table data and
                                            transactional changes. This extract provides Resource data
                                            including Resource ID data, ERCOT Polled Settlement metering
42
                                            information, generation unit telemetry, TDSP read generation,
                                            and relation

     Resource Plan Details                  Report of QSE Resource Plan details with confidentiality
                                            expired. Data is 6 months and older.
43


     Settlement & Billing Extract (S&B)     This extract provides a QSE with all the settlement billing
                                            determinants used for calculating the charge types that appear
44                                          on their settlement statement.


     Settlement Input Data Extract (SID)    This extract provides the day-after operating day public and
                                            private settlement input data, and public load forecast data 2
                                            days prior to an operating day, on a daily basis.
45



     Siebel Service Order Extract (SSOE)    The SSOE gives information on the service order and other
                                            pertinent enrollment/registration information pertaining to the
46                                          ESI IDs BPO. The SOs are not an indication of existing Siebel
                                            Service Instances.

     Switcher Report                        A presentation on counts of ESI IDs that have selected an
                                            electric service provider other than the AREP. This is part of
47
                                            the Performance Measures Report.
     TDSP ESI ID Extract                    Provides information that allows MPs to verify the ESI ID by
                                            TDSP area for a Service Delivery Point (SDP) using the service
                                            address.
48



     Weather Responsiveness Change          Provides MPs a list of IDR ESIIDs that have Load Profile IDs that
                                            have changed from weather sensitive to non-weather sensitive
49                                          or vice versa.


     WS and NWS IDR Proxy Dates             The WS and NWS IDR Proxy Dates displays the proxy days that
                                            ERCOT selected to use in estimating usage for ESI-IDs with IDR
50                                          meters. The dates chosen are representative dates from the
                                            past that are the most similar to the current settlement day.

     MOS Public                             Mid-term Load Forecast (MTLF); Market Clearing Prices
51                                          (MCPE); Capacity & insufficiency

     TDSP Transmission Loss Methodology     Seasonal Transmission Losses; NOIEs have an internal loss and
52                                          the methodology is there to calculate internal loss

     AS Bid Stacks Extract                  Provides information related to aggregate bids for
53                                          Ancilliary Services submitted by Market


     Scheduled Load & Actual Load Extract
54
                                           User Guide
SLA Level           ERCOT Contact           Location           Functional Process Origins
            Retail Client Services      none               Retail
    2

            Retail Client Services      http://www.ercot.c Retail
                                        om/services/usergui
                                        des/ret/867_03_Act
                                        ivity_Report_Descri
                                        ption.xls
    1                                   http://www.ercot.c
                                        om/services/usergui
                                        des/ret/867_03_Err
                                        or_Codes_Documen
                                        t.xls

            Retail Client Services      http://www.ercot.c Retail
                                        om/services/usergui
                                        des/ret/997_Report
    1                                   _Extract_User_Guid
                                        e_Version_%281.1%
                                        29.doc

            Wholesale Client Services   http://www.ercot.c Data Aggregation
                                        om/mktinfo/data_a
    1
                                        gg/index.html

            Wholesale Client Services   http://www.ercot.c Data Aggregation
                                        om/mktinfo/data_a
                                        gg/index.html
    1



            Wholesale Client Services   none               Energy and Ancillary Services


    3



            Wholesale Client Services   none               Energy and Ancillary Services

    1


            Wholesale Client Services   none               Energy and Ancillary Services

    1
    Retail Client Services       http://www.ercot.c Load Profiling
                                 om/services/usergui
                                 des/lp/FileFormatBa
1
                                 ckcastandForecast.xl
                                 s

    Wholesale Client Services    none                Energy and Ancillary Services
1

    Wholesale Client Services    http://www.ercot.c Data Aggregation
                                 om/mktinfo/data_a
3
                                 gg/index.html

    Wholesale Client Services    none                Market Prices
1

    Retail Client Services       none                Data Aggregation


2



    Wholesale Client Services    none                Energy and Ancillary Services

3


    Retail Client Services       http://www.ercot.c Retail
                                 om/services/usergui
                                 des/ret/SCR727_ESII
1                                D_Service_History_
                                 Usage_Extract_Guid
                                 e2.doc

    Wholesale Client Services    none                Energy and Ancillary Services

1


    Wholesale Client Services    http://www.ercot.c Data Aggregation
                                 om/mktinfo/data_a
1
                                 gg/index.html

    Retail Client Services       http://www.ercot.c Load Profiling
                                 om/services/usergui
1                                des/lp/FileFormatBa
                                 ckcastandForecast.xl
                                 s
    Wholesale or Retail Client   http://www.ercot.c Data Aggregation
    Services                     om/mktinfo/data_a
1
                                 gg/index.html
    Wholesale Client Services    http://www.ercot.c Data Aggregation
                                 om/services/usergui
                                 des/da/Generation_
1
                                 Extracts_User_Guid
                                 e.doc

    Wholesale Client Services    none               Grid Information

3


    Wholesale or Retail Client   none               Data Aggregation
    Services
3



    Retail Client Services       none               Load Profiling

3


    Wholesale Client Services    none               Energy and Ancillary Services


3



    Wholesale Client Services    none               Energy and Ancillary Services


3



    Wholesale Client Services    none               Energy and Ancillary Services


3



    Wholesale or Retail Client   none               Data Aggregation
    Services
2


    Wholesale or Retail Client   none               Data Aggregation
    Services
2
    Wholesale or Retail Client   http://www.ercot.c Data Aggregation
    Services                     om/services/usergui
1                                des/da/Load_Extrac
                                 ts_User_Guide.doc

    Retail Client Services       none               Load Profiling
3

    Retail Client Services       none               Retail
2

    Wholesale Client Services    none               Market Reports


2



    Wholesale Client Services    http://www.ercot.c Market Prices
                                 om/services/usergui
1                                des/mp/Market_Sha
                                 dow_Pricing_Extract
                                 s.doc
    Retail Client Services       http://www.ercot.c Retail
                                 om/services/usergui
                                 des/ret/061305_MI
1
                                 MO_Exception_User
                                 _Guide_Version_1.2
                                 .doc
    Retail Client Services       none                Retail

2


    Retail Client Services       none               Retail


3



    Retail Client Services       none               Retail


2
    Retail Client Services      http://www.ercot.c Retail
                                om/services/usergui
                                des/ret/Potential_L
                                oad_Loss_Extract_U
                                ser_Guide_Version_
2                               %283%29.doc




    Retail Client Services      none                 Load Profiling
3

    Retail Client Services      none                 Retail
3

    Wholesale Client Services   http://www.ercot.c Data Aggregation
                                om/services/usergui
                                des/da/Resource_ID
1
                                _and_Recorder_Extr
                                act.doc

    Wholesale Client Services   http://www.ercot.c Data Aggregation
                                om/services/usergui
                                des/da/Resource_ID
1
                                _and_Recorder_Extr
                                act.doc

    Wholesale Client Services   none                 Grid Information

3


    Wholesale Client Services   http://www.ercot.c Settlements
                                om/services/usergui
1                               des/set/Settlements
                                _and_Billing_Extrac.
                                doc
    Wholesale Client Services   http://www.ercot.c Settlements
                                om/services/usergui
                                des/set/Settlement_
1
                                Input_Data_Extract_
                                1.doc

    Retail Client Services      http://www.ercot.c Retail
                                om/services/usergui
1                               des/ret/Siebel_Servi
                                ce_Order_Extract.d
                                oc
    Retail Client Services      none                 Retail
3
    Retail Client Services       http://www.ercot.c Retail
                                 om/services/usergui
                                 des/ret/TDSP_ESIID
1
                                 _Extract.doc


    Retail Client Services       none               Load Profiling

3


    Wholesale Client Services    none               Data Aggregation

1


    Wholesale Client Services    none               Energy and Ancillary Services
1

                                                    Data Aggregation
3

     Wholesale Client Services   none               Energy and Ancillary Services
1

                                                    Energy and Ancillary Services
2
       Public or Market
      Participant Specific               DDL File Name                            Delivery Point
TDSP                         none                             TML Report Explorer Folder: "867 RCSO Report"




LSE/TDSP                     none                             FTP




LSE/TDSP                     none                             FTP




Public                       none                             TML Report Explorer Folder: "Actual Transmission Loss
                                                              Factor"


Public                       none                             TML Report Explorer Folder: "Actual Transmission Loss
                                                              Factor"
                                                              ERCOT.com:
                                                              http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                                              ?report=Actual%20Transmission%20Loss%20factor

Public                       ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Ancillary Service Schedules"
                             HH:MM:SS).AS_SCHED_DDL.sql       ERCOT.com:
                                                              http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                                              ?report=Ancillary%20Service%20Schedules


Public                       ext.(MM-DD-YYYY                  TML Report Explorer Folder: "ASDEPLOYMENTS"
                             HH:MM:SS).ASDEPLOYMENTSDDL.sql   ERCOT.com:
                                                              http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                                              ?report=ASDEPLOYMENTS

QSE                          ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Ancillary Services Extract"
                             HH:MM:SS).AncillarySrvcv9.sql
Public     none                            TML Report Explorer Folder: "Backcasted Profiles Extract"
                                           ERCOT.com:
                                           https://pi.ercot.com/contentproxy/publicList?folder_id=
                                           10001721


QSE        ext.(MM-DD-YYYY                 TML Report Explorer Folder: "Bids and Schedules Extract"
           HH:MM:SS).BidsSchedsv9Inc.sql
           ext.(MM-DD-YYYY
           HH:MM:SS).BidsSchedsv9.sql
Public     none                            TML Report Explorer Folder: "Unaccounted For Energy"




Public     ext.(MM-DD_YYYY                 TML Report Explorer Folder: "Dayahead Report"
           HH:MM:SS).DAYAHEADRPT_DDL.sql   ERCOT.com:
                                           http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                           ?report=DayAhead%20Report
LSE/TDSP   none                            TML Report Explorer Folder: "Default Profile ESIID"




Public     ext.(MM-DD_YYYY                 TML Report Explorer Folder: "Load Estimation Counts"
           HH:MM:SS).ENE_SCHED_DDL.sql     ERCOT.com:
                                           http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                           ?report=Energy%20Schedules

LSE/TDSP   ext.(MM-DD-YYYY                 TML Report Explorer Folder: "ESIID Extract"
           HH:MM:SS).ESIIDExtractv5.sql




Public     ext.(MM-DD-YYYY                 TML Report Explorer Folder: "Forecast Data Extract"
           HH:MM:SS).Forecastv8.sql




Public     none                            TML Report Explorer Folder: "Forecast Data Extract"




Public     none                            TML Report Explorer Folder: "Forecasted Profiles"
                                           ERCOT.com:
                                           https://pi.ercot.com/contentproxy/publicList?folder_id=
                                           10001775

Public     none                            TML Report Explorer Folder: "Forecasted Transmission
                                           Loss Factor"
QSE/PGC    ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Generation"
           HH:MM:SS).Generationv9inc.sql
           ext.(MM-DD-YYYY
           HH:MM:SS).Generationv9.sql


Public     ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Generation Outages"
           HH:MM:SS).Gen_Outages_DDL.sql    ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=Generation%20Outages

Public     none                             TML Report Explorer Folder: "IDR Protocol Compliance"
                                            ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=IDR%20Protocol%20Compliance


LSE/TDSP   none                             TML Report Explorer Folder: "IDR Requirement"




Public     ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Individual AS Bid
           HH:MM:SS).Ind_AS_BIDS_DDL.sql    Information"
                                            ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=Individual%20AS%20Bid%20Information%20

Public     ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Individual BES Bid
           HH:MM:SS).IND_BES_BIDS_DDL.sql   Information"
                                            ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=Individual%20BES%20Bid%20Information%20(A
                                            pr%202003%20and%20after)
Public     ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Individual RPRS Bid
           HH:MM:SS).IND_REP_BIDS_DDL.sql   Information"
                                            ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=Individual%20RPRS%20Bid%20Information%20(
                                            Apr%202003%20and%20after)
Public     none                             TML Report Explorer Folder: "Load Estimation Counts"
                                            ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=Load%20Estimation%20Counts

Public     none                             TML Report Explorer Folder: "Load Estimation Volumes"
                                            ERCOT.com:
                                            http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                            ?report=Load%20Estimation%20Volume
QSE/LSE    ext.(MM-DD-YYYY                TML Report Explorer Folder: "Load Extract"
           HH:MM:SS).Loadv10Inc.sql
           ext.(MM-DD-YYYY
           HH:MM:SS).Loadv10.sql

TDSP       none                           E-mail




LSE/TDSP   none                           TML Report Explorer Folder: "Mapping Status Reject
                                          Report"

Public     ext.(MM-DD-YYYY                TML Report Explorer Folder: "Market Information
           HH:MM:SS).MarketInfo_DDL.sql   Extract"
                                          ERCOT.com:
                                          http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                          ?report=Market%20Information%20Extract

Public     ext.(MM-DD-YYYY                TML Report Explorer Folder: "Market Shadow Prices
           HH:MM:SS).Market_Prices.sql    Extract"




TDSP       none                           TML Report Explorer Folder: "MIMO Exceptions"




TDSP       none                           TML Report Explorer Folder: "Missing 867 Report"




TDSP       none                           TML Report Explorer Folder: "Missing Consumption
                                          Report"




TDSP       none                           TML Report Explorer Folder: "Pending CWE Report"
LSE                ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Load Loss"
                   HH:MM:SS).LoadLoss.sql




Public             none                             ERCOT.com:
                                                    http://www.ercot.com/mktinfo/loadprofile/index.html


Public             ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Public Reference Data
                   HH:MM:SS).ESIIDExtractv5.sql     Extract"

QSE/PGC/TDSP/LSE   ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Non relational Recorder
                   HH:MM:SS).Resource_IDv1.sql      Extract"




QSE/PGC/TDSP/LSE   ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Resource ID Extract"
                   HH:MM:SS).Resource_IDv1.sql




Public             ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Resource Plan Details"
                   HH:MM:SS).RES_PLN_DTL_DDL.sql    ERCOT.com:
                   ext.(MM-DD-YYYY                  http://www.ercot.com/publicrmc/pubreportexplorer.asp
                   HH:MM:SS).RES_PLN_DTL_Inc.sql    ?report=resource%20plan%20details

QSE                ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Settlement & Billing
                   HH:MM:SS).SettleBillv10.sql      Extract"
                   ext.(MM-DD-YYYY
                   HH:MM:SS).SettleBillv10Inc.sql

QSE                ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Settlement Input Data
                   HH:MM:SS).SettleBillv10.sql      Extract"
                   ext.(MM-DD-YYYY
                   HH:MM:SS).SettleBillv10Inc.sql


LSE/TDSP           ext.(MM-DD-YYYY                  TML Report Explorer Folder: "Service Orders"
                   HH:MM:SS).Service_OrderV3.sql




Public             none                             ERCOT.com:
                                                    http://www.ercot.com/mktinfo/retail/index.html
Public     ext.(MM-DD-YYYY                TML Report Explorer Folder: "TDSP ESIID Report"
           HH:MM:SS).TDSP_ESIID_DDL.sql   ERCOT.com:
                                          http://www.ercot.com/publicrmc/pubreportexplorer.asp
                                          ?report=TDSP%20Esiid%20Reports


LSE/TDSP   none                           TML Report Explorer Folder: "Responsiveness Change"




Public     none                           TML Report Explorer Folder: "WS and NWS IDR Proxy
                                          Dates"




Public                                    See tab "MOS Public Reports"


                                          http://www.ercot.com/mktinfo/data_agg/2007/2007Tra
                                          nsmissionLossFactors.xls

                                          ERCOT.com
Public                                    https://pi.ercot.com/contentproxy/publicList?folde
                                          r_id=10001685
                        Posting Name Format                         How often posted
rpt.(MM-DD-YYYY HH:MM:SS).867RCSO_MMDDYYYY.csv                  Weekly




LSE:                                                            Daily
IDR Report
DUNSNUMBER_867_IDR_ACTIVITY_YYYYMMDD_HHMMSS.csv
NIDR Report
DUNSNUMBER_867_NonIDR_ACTIVITY_YYYYMMDD_HHMMSS.csv

MRE/TDSP:
IDR Report
TDSPNAME_867_IDR_ACTIVITY_YYYYMMDD_HHMMSS.csv
NIDR Report
TDSPNAME_867_NonIDR_ACTIVITY_YYYYMMDD_HHMMSS.csv
rpt.00000236.0000001123456789.Missing997Report.csv              Daily
(Report number. DUNS Number with leading zeros - Report Name)




rpt.(MM-DD-YYYY HH:MM:SS ).TLFACTMMDDYYYY.csv                   Daily




rpt.(MM-DD-YYYY HH:MM:SS).TLFACTMMDDYYYY.csv                    Daily




ext.(MM-DD-YYYY HH:MM:SS).Anci_Schedules.zip                    Monthly




ext.(MM-DD-YYYY HH:MM:SS).ASDEPLOYMENTS.zip                     Daily




ext.(MM-DD-YYYY HH:MM:SS).AnciServ_Daily.zip                    Daily
ext.(MM-DD-YYYY HH:MM:SS).BcstPrflMMDDYYYY.csv   Daily




ext.(MM-DD-YYYY HH:MM:SS).BidsSchs_Daily.zip     Daily




rpt.(MM-DD-YYYY HH:MM:SS).UFEMMDDYYYY_chX.csv    Daily
Where X = channel run
UFEMMDDYYYY = trade date run in the channel

ext.(MM-DD-YYYY HH:MM:SS).DAYAHEADREPORT.zip     Daily




rpt.(MM-DD-YYYY HH:MM:SS).DP_rep_yyyymmdd.csv    Daily
rpt.(MM-DD-YYYY HH:MM:SS).DP_TDSP_yyyymmdd.csv




ext.(MM-DD-YYYY HH:MM:SS).Ene_Schedules.zip      Daily




ext.(MM-DD-YYYY HH:MM:SS).ESI ID_EXTRACT.zip     Daily




ext.(MM-DD-YYYY HH:MM:SS).Forecast_Initial.zip   Daily
ext.(MM-DD-YYYY HH:MM:SS).Forecast_Daily.zip




rpt.(MM-DD-YYYY HH:MM:SS ).TLFFORMMDDYYYY.csv    Daily




ext.(MM-DD-YYYY HH:MM:SS).FcstPrflMMDDYYYY.csv   Daily




rpt.(MM-DD-YYYY HH:MM:SS).TLFFORMMDDYYYY.csv     Daily
ext.(Published Date mm-dd-year time).Generate_Initial.zip      Daily
ext.(Published Date mm-dd-year time).Generate_Daily.zip




ext.(MM-DD-YYYY HH:MM:SS).Gen_Outages.zip                      Monthly




rpt.(MM-DD-YYYY.HH:MM:SS).IDRPCVMMDDYYHHMM.xls                 Daily




rpt.(MM-DD-YYYYHH:MM:SS).IDRReqMMDDYYYY.pdf                    Monthly
rpt.(MM-DD-YYYYHH:MM:SS).IDRReqMMDDYYYY.csv




ext.(MM-DD-YYYY HH:MM:SS).Ind_ASBIDS.zip                       Daily




ext.(MM-DD_YYYY HH:MM:SS).Ind_BESBIDS.zip                      Daily




ext.(MM-DD-YYYY HH:MM:SS).Ind_RPRSBIDS.zip                     Daily




rpt.(MM-DD-YYYYHH:MM:SS).yymmddc.XLDcnt.pdf                    Daily
rpt.(MM-DD-YYYYHH:MM:SS).yymmddc.XLDcnt.csv




rpt.(MM-DD-YYYYHH:MM:SS).yymmddc.XLDvol.pdf                    Daily
rpt.(MM-DD-YYYYHH:MM:SS).yymmddc.XLDvol.csv
Where X = Settlement Channel Number
MM-DD_YYYYHH:MM:SS = Timestamp for the posting of the report
yyyymmdd = Trade date represented in the reports
ext.(MMDDYYYY HH:MM:SS).Load_Daily.zip                   Daily




none                                                     Quarterly




rpt.(MM-DD-YYYY HH:MM:SS).MSRejects_MMDD.csv             Daily


ext.(MM-DD-YYYY HH:MM:SS).MrktInfo_Initial.zip           Daily
ext.(MM-DD-YYYY HH:MM:SS).MrktInfo_Daily.zip




ext.(MM-DD-YYYY HH:MM:SS).Market_Prices.zip              Daily




rpt.(MM-DD-YYYY HH:MM:SS).MIMO_EXCEPTIONS_MMDDYYYY.csv   Daily




rpt.(MM-DD-YYYYHH:MM:SS).Miss_MMDDYYYY.csv               Weekly




rpt.(MM-DD-YYYYHH:MM:SS).MissConnMMDDYYYY.csv            Daily




rpt.(MM-DD-YYYY HH:MM:SS).MIMO_EXCEPTIONS_MMDDYYYY.csv   Daily
rpt.(MM-DD-YYYY HH:MM:SS).YYYYMMDDLoadLoss.csv   Daily




Profile Counts_YYYYMMDD.xls                      Quarterly




ext.(DD-MM-YYYY HH:MM:SS ).PRDE_Extract.zip      Daily


ext.(MM-DD-YYYY HH:MM:SSS ).REC_Daily.zip        Daily




rpt.(MM-DD-YYYY HH:MM:SS).RID_Daily.zip          Daily




ext.(MM-DD-YYYY HH:MM:SS).ResPlanDetails.zip     Daily




ext.(MM-DD-YYYY HH:MM:SS).SettBill_Daily.zip     Daily




ext.(DD-MM-YYYY HH:MM:SS ).SID_Daily.zip         Daily




ext.(MMDDYYYY HH:MM:SS).Siebel_extract.zip       Daily
ext.(MMDDYYYY HH:MM:SS).Siebel_full.zip




Report output posted to the website              Monthly
ext.(mm-dd-yyyy 00:00:00).MPNAME____NEW.zip      Weekly
ext.(mm-dd-yyyy 00:00:00).MPNAME____FULL.zip




rpt.(MM-DD-YYYYHH:MM:SS).WthrSensMMDDYYYY.csv    Annually




rpt.(MM-DD-YYYY HH:MM:SS).ProxyDayMMDDYYYY.csv   Daily
rpt.(MM-DD-YYYY HH:MM:SS).ProxyDayMMDDYYYY.pdf




Varies depending on MOSPUBLIC report             Varies (See additional
                                                 information column)

                                                 Monthly


ext.(MM-DD-YYYY HH:MM:SS).ASBIDSTACKS.zip        Daily
                                                                             Data Extraction
               ERCOT Delivery                     Source System                 System               Record Addtimes
Delivery - Weekly on Monday                   Paperfree, TCH, Siebel   ETS                     12 AM to 12AM from Friday to
                                                                                               Friday.


Protocol Section 11.22.2 (1)                  Lodestar                 Lodestar                867_03s received from D1 3AM -
Delivery - Daily                                                                               D2 2:59:59AM attempted to
                                                                                               load on D2.




Delivery - Daily                              PaperFree                PaperFree Archive       Sunday-Saturday. Data included
                                                                                               is from Midnight to Midnight
                                                                                               three days prior.




Protocol Section 13.3.1.1.                    Lodestar                 Lodestar                by Trade date run
Delivery - Daily by 6:00AM


Protocol - Section 13.2.2.       Delivery -   Lodestar                 Lodestar                24 hour 15 minute interval cuts
Daily by 6:00AM                                                                                posted day after operating day




Protocol Section 12.4.4.2.3.3.                MOS                      ODS                     15 minute interval data for the
Delivery - Daily                                                                               month 6 months ago




Protocol Section 12.4.4.2.3.2                 MOS                      ODS                     5 minute interval data for the
Delivery - Daily                                                                               previous operating day




Protocol Section 12.4.4.2.3.1.                MOS                      ODS                     15 minute interval data that has
Delivery - Daily                                                                               changed between D1 4AM - D2
                                                                                               3:59:59AM
Protocol - Section 18.3.3.          Delivery - Lodestar   Lodestar   Previous day (12AM -
Daily by 10 AM                                                       11:59:59PM)




Protocol Section 12.4.4.2.3.1.                MOS         ODS        15 minute interval data that has
Delivery - Daily                                                     changed between D1 4AM - D2
                                                                     3:59:59AM

Protocol Section 12.4.4.2.3.2.      Delivery - Lodestar   Lodestar
Daily


Protocol Section 12.4.4.2.3.2.      Delivery - MOS        ODS        Previous day's Day Ahead
Daily                                                                Market


Delivery - Daily                              Lodestar    Lodestar   Displays all trade dates settled
                                                                     the previous night.

                                                                     (One row per ESIID being
                                                                     assigned a default profile, per
                                                                     Trade Date.)

Protocol Section 12.4.4.2.3.3.                MOS         ODS        15 minute interval data for the
Delivery - Daily                                                     month 6 months ago




Protocol Section 12.4.4.2.3.2.                Lodestar    ODS        Three days prior - i.e. On
Delivery - Daily                                                     Thursdays, we run for Monday-
                                                                     Tuesday dataset




Protocol Section 12.4.4.2.3.2.      Delivery - MOS        ODS        Previous day (12AM -
Daily                                                                11:59:59PM)




Protocol Section 13.3.1.1.                    Lodestar    Lodestar   by Trade date run
Delivery - Daily by 6AM


Protocol Section 18.3.3.                      MetrixND    MetrixND   Current day plus three days
Delivery - Daily by 10 AM                                            forward (midnight to 11:59:59)




Protocol Section 13.2.1.         Delivery -   Lodestar    Lodestar   TLF for current day in 15 minute
Daily by 6 AM                                                        intervals
Protocol Section 12.4.4.2.3.1.    Delivery - Lodestar          ODS                Posting lags to 2 days prior
Daily                                                                             from 4AM - 1 day prior
                                                                                  3:59:59AM




Protocol Section 12.4.4.2.3.3.              Outage Scheduler   Outage Scheduler   Approved outages > 180 days
                                                                                  prior




Protocol Section 9.2.6            Delivery - Lodestar          Lodestar           Minimum True-Up trade date
Daily when Ture Ups are run                                                       for that operating day's batch
                                                                                  run as the next 29 consecutive
                                                                                  trade dates.


Protocol Section 18.6                        Lodestar          Lodestar           data as of first of month
Delivery - Monthly on the 2nd of every month




Protocol Section 12.4.4.2.3.3.              MOS                ODS                hourly interval data for the
Delivery - Daily                                                                  operating day 6 months ago




Protocol Section 12.4.4.2.3.3.              MOS                ODS                15 minute interval data for the
Delivery - Daily                                                                  operating day 6 months ago




Protocol Section 12.4.4.2.3.3.              MOS                ODS                15 minute interval data for the
Delivery - Daily                                                                  operating day 6 months ago




SCR 725                                     Lodestar           Lodestar           Batch runs from 2 days prior
Delivery - Daily




SCR 725                                     Lodestar           Lodestar           Batch runs from 2 days prior
Delivery - Daily
Protocol Section 11.5.1.1 & 12.3 (c). Delivery Lodestar                 ODS                Posting lags to 2 days prior
- Daily                                                                                    from 4AM - 1 day prior
                                                                                           3:59:59AM


Load Profiling Guide section 11.4.4            Siebel, Lodestar         Siebel, Lodestar   All active and De-energized
Delivery - Quarterly                                                                       ESIIDs at current
Prior to the 15th day of the month following
the end of the prior quarter
Delivery - Daily                               Paperfree, TCH, Siebel   ETS                Run at 6AM. Prior day's data
                                                                                           midnight to midnight

Protocol Section 12.4.4.2.3.2.                 MOS                      ODS                Initial - 30 operational days
Delivery - Daily                                                                           Daily - delivered today for D-2
                                                                                           4:00AM - D-1 3:59:59AM




Protocol Section 12.4.4.2.3.2.                 Lodestar                 ODS                Daily - delivered today for D-2
Delivery - Daily                                                                           4:00AM - D-1 3:59:59AM




Delivery - Daily                               Paperfree, TCH, Siebel   ETS                Run at 6AM. Prior day's data
                                                                                           midnight to midnight




Delivery - Weekly on Wednesday                 Paperfree, TCH, Siebel   ETS                Runs Wednesday to capture ALL
                                                                                           service orders in Scheduled
                                                                                           status with a SMRD more than
                                                                                           7 days in the past.

ERCOT Protocols, Section 11.2.2 (3) Delivery - Lodestar                 Lodestar           The day of the year for which
Daily                                                                                      this report is run (sysdate). This
                                                                                           report is generated for each
                                                                                           MRE that has an un-read ESIID
                                                                                           that is aged at exactly 38 days.


Delivery - Daily                               Paperfree, TCH, Siebel   ETS                Midnight to Midnight for the
                                                                                           prior ten days.
Delivery - Daily                                Siebel          Siebel             For Switch transactions, CRs will
                                                                                   receive the information when
                                                                                   the SMRD is outside the five (5)
                                                                                   business day window from
                                                                                   effectuating the Switch. For
                                                                                   Move In transactions, CRs will
                                                                                   receive the information when
                                                                                   the SMRD is outside the two (2)
                                                                                   business day


Load Profiling Guide section 11.4.4
Delivery - Quarterly
Prior to the 15th day of the month following
the end of the prior quarter
Delivery - Daily                                Lodestar        ODS                All data as of previous day at
                                                                                   Lodestar Batch Start

Protocol Section 11.1.10 & 11.1.11              Lodestar        ODS
Delivery - Daily




Protocol Section 12.4.4.2.3.1(5) & 11.1.10(5)   Lodestar        ODS                Three days prior - i.e. On
& 11.1.11 (3).                                                                     Thursdays, we run for Monday-
Delivery - Daily by Noon                                                           Tuesday dataset




Protocol Section 12.4.4.2.3.3.                  MOS             ODS                Hourly interval data for 6
Delivery - Daily                                                                   months ago




Protocol Section 12.4.4.2.3.1.       Delivery - Lodestar        ODS                Posting lags to 1 day prior from
Daily                                                                              4AM - 1 day prior 3:59:59AM




Protocol Section 12.4.4.2.3.1                   Lodestar        ODS                Previous day 00:00:00 -
Delivery - Daily                                                                   23:59:59




Delivery - Daily for Incrementals               Siebel          ODS                Previous day (7PM - 7PM)
Weekly on Tuesdays for Full SSOE




Delivery - Monthly by the 25th of each month Siebel, Lodestar   Siebel, Lodestar   Data for end of month for most
for previous month's data.                                                         recent month end and second
                                                                                   file contains historical data
Delivery - Weekly on Tuesday                   Siebel     Siebel     Run from Midnight to Midnight.
                                                                     Weekly - Monday to Monday
                                                                     Monthly - Monday back to the
                                                                     first of the month.


Delivery - Annually in November                Lodestar   Lodestar   Provides changes from Weather
                                                                     sensitive to non-weather
                                                                     sensitive and vice versa over
                                                                     the past 12 mos.

Protocol Section 11.4.3.4.                     Lodestar   Lodestar   The report is created daily for
Delivery - Daily                                                     initial, final, true-up and any
                                                                     resettlement runs for the
                                                                     previous night.

Protocol Section 12.4.4.2.3.2                  MOS        ODS        Varies (see additional
Delivery - Daily                                                     information)

Delivery - Monthly 30 days prior to start of
the month

Protocol Section 12.4.4.2.3.2. Delivery -
Daily                                                                Hourly interval data for the
                                               MOS        ODS
                                                                     operating day
    ERCOT or MP Initiated          Additional Information
ERCOT                        ERCOT Retail 101




ERCOT                        ERCOT.Com
                             ERCOT Retail 101




ERCOT                        ERCOT Retail 101




ERCOT




ERCOT                        ERCOT Wholesale Market Basics




MP - TML Extract Scheduler




ERCOT




ERCOT                        ERCOT Wholesale Market Basics
ERCOT




MP - TML Extract Scheduler   ERCOT Wholesale Market Basics




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT
MP - TML Extract Scheduler




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT




ERCOT
MP - TML Extract Scheduler   Wholesale Market Basics




ERCOT




ERCOT                        ERCOT Retail 101


ERCOT                        Wholesale Market Basics




ERCOT




ERCOT                        ERCOT Retail 101




ERCOT                        ERCOT Retail 101




ERCOT




ERCOT                        ERCOT Retail 101
ERCOT                        ERCOT Retail 101




ERCOT




ERCOT


MP - TML Extract Scheduler




MP - TML Extract Scheduler




ERCOT




MP - TML Extract Scheduler   Wholesale Market Basics




MP - TML Extract Scheduler




MP - TML Extract Scheduler   ERCOT Retail 101




ERCOT
ERCOT




ERCOT




ERCOT




MP - Via ERCOT MOSPUBLIC   MOS Public reports refresh rates vary
website or Retail API      from 1 minute to 24 hours depending
                           on report.




ERCOT
                 Name of the Report
1    Ancillary Service Bid Requests

2    Ancillary Services Market Clearing Prices

3    Balancing Services MCP

4    Control Area Load Forecast

5    Control Area Load History

6    Real-time Data

7    McCamey Area Near Real-time Data

8    Mid-term Load Forecast

9    Scheduled Zonal Generation

10   Approved Transmission Outages

11   Proposed Transmission Outages

12   Sufficiency Report

13   Weather Assumptions

14   CSC/CRE Data

15   Total Transfer Capability

16   Ongoing Transmission Outages

17   Proposed Transmission Outages Received

18   Commercially Significant Constraints

19   Short-term Load Forecast

20   Congestion Notification

21   Emergency Notification

22   Market Schedule

23   Replacement Service MCP
                                        ERCOT URL                               Refresh Rate
http://mospublic.ercot.com/ercot/jsp/ancillary_service_requests.jsp               24 Hours

http://mospublic.ercot.com/ercot/jsp/ancillary_services_mcp.jsp                   24 Hours

http://mospublic.ercot.com/ercot/jsp/balancing_services_mcp.jsp                    15 Min

http://mospublic.ercot.com/ercot/jsp/ca_load_forecast.jsp                          60 Min

http://mospublic.ercot.com/ercot/jsp/ca_load_hist.jsp                              15 Min

http://mospublic.ercot.com/ercot/jsp/frequency_control.jsp                         1 Min

http://mospublic.ercot.com/ercot/jsp/mccamey_flow.jsp                              2 Min

http://mospublic.ercot.com/ercot/jsp/midterm_load_forecast.jsp                     5 Min

http://mospublic.ercot.com/ercot/jsp/scheduled_zonal_generation.jsp                15 Min

http://mospublic.ercot.com/ercot/jsp/planned_trans_out.jsp                         15 Min

http://mospublic.ercot.com/ercot/jsp/proposed_trans_out.jsp                        15 Min

http://mospublic.ercot.com/ercot/jsp/sufficiency_report.jsp                        15 Min

http://mospublic.ercot.com/ercot/jsp/tem_peaks.jsp                                24 Hours

http://mospublic.ercot.com/ercot/jsp/csc_cre.jsp                                   1 Min

http://mospublic.ercot.com/ercot/jsp/total_transfer_capability.jsp                 60 Min

http://mospublic.ercot.com/ercot/jsp/transmission_outages.jsp                      15 Min

http://mospublic.ercot.com/ercot/jsp/trans_outages_received.jsp                    15 Min

http://mospublic.ercot.com/ercot/jsp/commercially_significant_constraints.jsp      15 Min

http://mospublic.ercot.com/ercot/jsp/shortterm_load_forecast.jsp                   5 Min

http://mospublic.ercot.com/ercot/jsp/congestion_notification.jsp                   5 Min

http://mospublic.ercot.com/ercot/jsp/emergency_notifications.jsp                   5 Min

http://mospublic.ercot.com/ercot/jsp/market_schedule.jsp                          24 Hours

http://mospublic.ercot.com/ercot/jsp/replacement_services_mcp.jsp                 24 Hours

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:8/12/2012
language:
pages:44