DPAS SCR: 01961

• SCR Number
  01961
• Title
  MU Data to Advana
• DPAS Module
  MU
• Reporting Organization
  AF: A4/HAF FH-AFHAF
• State
  In Progress
• History
  Submitted 10/03/2023
• Description
  Change Request: Process Improvement

  
  

  Description:

  The current interface control document does not ask for the data related to the Work_Order_Header_ NMC  as well as the Work_Order_Header_NMC_Total header tables.  These tables track the time and reason work orders are placed in a NMC status (including NMCS & NMCM).  Without these tables it is difficult to calculate the amount of time a piece of equipment was down for each status, either total lifecycle downtime or relative to a specific work order.

   

  Recommended:

  Add all the data elements from these tables to the ADVANA data feed.  Furthermore, the ADVANA Interface Control Document (ICD) will need to be updated to capture the additional data elements and the associated formats.  In addition, any keys necessary to join to the work order header table will need to be included.

   

  Mission Critical:

  ADVANA dashboards are needed to support data analytics from DPAS M&U.

   

  Benefits:

  Allows the ability to capture metrics on how long equipment was down due to supply or maintenance issues.  Attaining lifecycle sustainment data on aviation support equipment was the entire reason for our transition to DPAS M&U.  This is a further step to making that data available to leadership, sustainment orgs, and users across the AF enterprise.

   

  Frequency: Daily

   

  Users:

  These analytical tools will be used by the various program offices to capture trends and support business/budget decisions vs federated error prone spreadsheets currently in use.  

   

  Partially Completed – Release 2024.3.3 – 09 August 2024

  Partially Completed - Release 2024.3.6 - 20 September 2024

  Partially Completed - Release 2024.4.3 - 01 November 2024