130 likes | 212 Views
SMT Update To AMWG. January 21, 2014. Review of Interim Process for RORs to Request Backfilling Historical Usage. AMWG Change Request 2013-17. Requirements outlined in Change Request approved by RMS
E N D
SMT Update To AMWG January 21, 2014
Review of Interim Process for RORs to Request Backfilling Historical Usage
AMWG Change Request 2013-17 • Requirements outlined in Change Request approved by RMS • Backfill of Historical Usage Data for Existing Customers – delivered “interim” solution Dec 18th 2013 • 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) • Subscription for New Customer Historical Usage – in process for delivery Q1 2014 • Ability for the REP of Record to subscribe to automatically receive a one-time report of historical interval usage data (up to 12 months) for customers/ESIIDs that are newly served by them (new enrollments)
Backfill of Historical Usage Requests – “Interim” 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 – “Interim” Functionality Delivered 12/18/13 (cont.) Business Process • REP contacts the Help-Desk via email 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
Backfill of Historical Usage Requests - Form Backfill Request Form
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.
Status Update of AMWG Change Requests Approved by Retail Market Subcommittee (RMS)
Project Schedule 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2014 2013 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Third-Party Design AMIT / SMT DO Third-Party Security Independent Review SMT Design Assessment Security Validation Security Validation Third-Party Customer Experience Review Additional Solution Requirements SMT Customer Experience Changes Third-Party Technical Design & Development Third-Party Technical Integration Sessions Legend Third-Party Testing Future Task In Process Completed Third-Party Implementation
SMTDO – Third Party Updates SMT DO Webinar Schedule February 28th – 10:00 – 11:00 a.m. (Tentative) March 21st – 10:00 – 11:00 a.m. April 25th – 10:00 – 11:00 a.m. May 23rd – 10:00 – 11:00 a.m. June 20th – 10:00 – 11:00 a.m.