DPAS SCR: 01745

• SCR Number
  01745
• Title
  Forms_Reports excel export
• DPAS Module
  MU
• Reporting Organization
  SOCOM
• State
  New
• History
  Submitted: 22 December 2021
• Description
  Description:

  Reports scheduled under the Forms-Reports menu in the MU module can only be exported in .pdf file format. When scheduling reports, a drop-down menu is already present for selecting report format types, but the only option currently available is .pdf format. The Work Order report under Forms-Reports is the only MU report/inquiry that provides all work order and sub work order data elements in a single report. NSWC needs these data elements in excel format in order to conduct analytics on the maintenance data that is recorded in the system.

   

  Recommended:

  Modify the file format options for the reports generated within the Forms-Reports menu of MU to include the excel file format. Add the excel format option to the available options on the existing file format drop-down menu.

   

  Mission Critical:

  Yes. WARCOM N8 and the PEO-Maritime SOCOM PEO is required to calculate Mean Time Between Operational Mission Failures (MTBOMF) for NSWC combatant craft using data that is entered into the DPAS MU module via repair work orders. In order to calculate this metric from MU data the Work Order report needs to be available in excel file format.

   

  Benefits:

  The proposed solution will significantly reduce time in conducting data-manipulation of the currently limited MU reports in order to put the data in a usable format for performing analytics.

   

  Users:

  This problem affects all NSW DPAS MU users.