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.

 

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.

 

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

 

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