DPAS SCR: 01176

• SCR Number
  01176
• Title
  FAST Reportable Inquiry
• DPAS Module
  MU
• Reporting Organization
  OSD
• State
  New
• History
  Submitted: 7/29/17
• Description

  Description
  Mr. Sims (DoD FAST Manager) has requested DPAS Leidos personnel to execute a data extract monthly.  As such, it's only available when Leidos executes the database script.  If these output products are a required product of DPAS, they should be added to the menu as a standard inquiry, report or an Agency Pre-defined report.  The reports should have some filtering capability, thus the possibility of having these extracts as Agency Pre-defined may not be a viable solution. 
  For example:  the ECC for trailers falls under ACC = P, but trailers are not FAST Reportable 'yet'.  I just want to ensure we all are on the same page on that.  This means, I need to have ECC = VU/VW omitted from the pulls and ensure we do not send those to FAST 'yet'.  Using the example, it appears that the reporting of trailers to FAST may be in the works, thus allowing the FAST Manager to include/exclude certain ECCs may be beneficial.
  Also, there are some scripts/pulls I will need at the Enterprise Level.  Do I do a SCR to have it created so I can pull in DPAS? 
  These are the monthly reports I need reflecting FYTD and month totals:

  • FAST Reportable in PA and M&U
  • Maint Mgmt Cd = NPD
  • Maint Asset Util <= 0
  • Fuel Util not Reported
  • Cost <= 0

  Recommended
  Migrate the current FAST database scripts from being limited to being executed by a Leidos person with Database Read Access to a menu selection allowing the user with the FAST Manager's role to request them as they require them.

  Mission Critical
  Any report that is a user report should not require a DBA to execute them.  The receipt of the reports is considered critical to the success of DPAS being able to accurately report to FAST.

  Benefits
  Eliminates the need for the FAST Manager to contact Leidos to execute the extracts each time they require them, as well as it eliminates the repeated receipt and running of the extracts by DPAS Leidos personnel.

  Users
  This report would be limited to user who are granted the FAST Reports.