1 / 10

AMS Reports & Extracts

AMS Reports & Extracts. AMS Workshop III. Web Services - AMS interval data. Purpose: Provide point-in-time (PITS) data for all ESIIDs for a trade date for load or generation usage. PITS - Archiving changes to data over time Default settings

kimberley-curry
Download Presentation

AMS Reports & Extracts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AMS Reports & Extracts AMS Workshop III September 19, 2014

  2. Web Services - AMS interval data • Purpose: Provide point-in-time (PITS) data for all ESIIDs for a trade date for load or generation usage. • PITS - Archiving changes to data over time • Default settings • Point in time: Most current version of the data record • Trade date: Most recent trade date available • Previous versions available by selecting a time in the past • Users can narrow search by uploading a list of up to 1,000 ESIIDs • Submitting web service requests places the request in the queue • Output files posted to the MIS for download. • Turnaround time is less than three business days AMS Workshop III – September 19, 2014

  3. Web Services - AMS interval data • AMS interval data for a trade date • Provides AMS data for all ESIIDs owned as of a particular point-in-time (PITS), for a particular trade date for load or generation usage. AMS Workshop III – September 19, 2014

  4. Web Services - AMS interval data • ESIIDs without AMS data for a trade date • Provides a list of all ESIIDs owned that DO NOT have AMS data loaded as of a particular point-in-time (PITS), for a particular trade date for load or generation usage. AMS Workshop III – September 19, 2014

  5. Web Services - AMS interval data • ESIIDs for a trade date • Provides a list of ESIIDs owned, on a particular trade date, as of a particular point-in-time (PITS). AMS Workshop III – September 19, 2014

  6. Real Time Market Settlements Extracts • RTM Market Operating Day Extract (MODE) • Public • RTM Consolidated Operating Day Extract(CODE) • Certified specific to a Market Participant • Contents • Settlement Operating Day data used in the RTM settlement calculations • Timing • Within 48 hours of posting the corresponding Settlement Statement • Questions • Please call your ERCOT Client Services Account Manager AMS Workshop III – September 19, 2014

  7. To Recreate the Load Volume & ESI ID Counts Presentation AMS Workshop III – September 19, 2014

  8. TDSP Load Volume Information • Data provided in RTM MODE extract • Data contained in tables DAIOUTPUTHEADER/DAIOUTPUTINTERVAL • Billdeterminant is LTDSPUNADJ - load by TDSP & method (unadjusted) • Recorder format • LTDSPUNADJ_<TDSPCODE>_<METHOD> • Methods used • AMC • AME+AMDP+AMDPS AMS Workshop III – September 19, 2014

  9. REP Load Volume Information • Data provided in RTM CODE extract • Data contained in tables LLSOUTPUTHEADER/LLSOUTPUTINTERVAL • Billdeterminant is LSEGUNADJ - load by REP, QSE, ProfileCode, LossCode, UFE Zone, LoadZone, TDSP, Method (unadjusted) • Recorder format • LSEGUNADJ_<REP>_<QSE>_<PROFILECODE>_<LC>_<UFE>_<LZ>_<TDSP>_<METHOD> • Methods used • AMC • AME+AMDP+AMDPS AMS Workshop III – September 19, 2014

  10. TDSP Load Count Information Load Estimation Counts Report • Produced daily on ERCOT.com • Includes data for each operating date • Includes meter types NIDR & IDR (AMS & BUSIDRRQ) grouped together • Provides counts per three categories • Actual • Historical • Default Profile • Provides data by TDSP & ERCOT wide • Provides counts & count percentages AMS Workshop III – September 19, 2014

More Related