120 likes | 238 Views
SMT Update To AMWG Documentation. February 24, 2014. Review of Documentation Updates. Process Instructions - Interim Solution for RORs to Request Backfilling Historical Usage. Review of Documentation Updates.
E N D
SMT Update To AMWGDocumentation February 24, 2014
Process Instructions - Interim Solution for RORs to Request Backfilling Historical Usage Review of Documentation Updates
SMT Historical Usage Reporting Functionality Backfill Requests Interim Solution InstructionsVersion 5 Dated February 17, 2014 Added Version Number and Version Date
AMWG Change Request 2013-17 • Requirements outlined in Change Request approved by RMS • Backfill of Historical Usage Data for Existing Customers • Ability for the REP of Record to request a one-time retrieval of historical interval usage data (up to 12 months) for some or all of its existing customer base (backfill requests)
Backfill of Historical Usage Requests – Functionality Delivered 12/18/13 Submit: REP of Record requests a one-time report of historical usage data. The request may be for 15-minute interval usage data (up to 12 months), daily usage data (up to 12 months) ,or monthly usage data (up to 12 months). Input: REP request form and a listing of requested ESIIDs for existing customers Output: Delivery format for 15-minute interval usage data: LSE or Delivery format for daily usage data: CSV or Delivery format for monthly usage: CSV
Backfill of Historical Usage Requests – Functionality Delivered 12/18/13 (cont.) Added Email Address Business Process • REP contacts the Help-Desk via email (Support@Smartmetertexas.com) or phone to create a ticket for historical usage backfill report • SMT sends the historical usage backfill report request form to the REP • REP utilizes SMT request form to request historical backfill usage for existing customers to include following information: • DUNS No (may include more than 1 DUNS number) • Start & End date • Report Type (15 min interval or Daily or Monthly) • REPs include with the request form a list of ESIIDs in a separate CSV file • SMT will place the request in the queue and will execute the job at the most optimized time e.g. after hours & weekends • SMT will place the historical usage report on the SMT FTPS site in the appropriate REP folder • SMT will inform the REP once the file has been placed on the SMT FTPS site • SMT will keep the file for 5 days on the SMT FTPS site and after those 5 days it will be deleted
Estimated Turnaround Time For Backfill of Historical Usage Requests Parameter Estimates For 1,000 ESIIDs for 1 year interval data – apprx 2 days* For 100,000 ESIIDs for 1 year interval data – apprx 4 weeks* *These are estimates only and actual will be dependent on the system load, other request, environmental constraints etc.
Request Form - Interim Solution for RORs to Request Backfilling Historical Usage Review of Documentation Updates
Backfill of Historical Usage Requests - Form & Sample ESIID File Added Version Number and Version Date Form Version 04 Dated February 17, 2014 Backfill Request Form Added SMT Email Address Changed from ROR to Requestor for Email and Phone Added Boxes for All and ESIID List Attached
AMWG Change Request Spreadsheet Review of Documentation Updates
Added Column for Actual Embedded Document Link AMWG / RMS Change Requests