SMT Historical Usage Reporting Functionality
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

AMWG Change Request 2013-17 PowerPoint PPT Presentation


  • 74 Views
  • Uploaded on
  • Presentation posted in: General

SMT Historical Usage Reporting Functionality Backfill Requests Interim Solution Instructions Version Dated March 24, 2014. AMWG Change Request 2013-17. Requirements outlined in Change Request approved by RMS Backfill of Historical Usage Data for Existing Customers

Download Presentation

AMWG Change Request 2013-17

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Amwg change request 2013 17

SMT Historical Usage Reporting Functionality Backfill Requests Interim Solution InstructionsVersion Dated March 24, 2014


Amwg change request 2013 17

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

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:

ROR 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

Backfill of Historical Usage Requests – Functionality Delivered 12/18/13 (cont.)

Business Process

  • ROR contacts the Help-Desk by phone at 1-888-616-5859 or via email ([email protected]) to create a ticket for historical usage backfill report

  • ROR downloads the SMT historical usage backfill request form from AMWG or the SMT help desk sends the historical usage backfill request form to the ROR

  • ROR 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)

  • RORs include with the request form a list of ESIIDs in a separate CSV file

  • SMT will place the request in the ad hoc report request 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 ROR folder

  • SMT will inform the ROR 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

Estimated Turnaround Time For Backfill of Historical Usage Requests

Parameter Estimates

For 1,000 ESIIDs for 1 year interval data – apprx 2 - 4 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.


  • Login