The DPAS diverse customer base results in DPAS having attribute requirements that do not apply to every DPAS customer's mission.  To require every customer to managed attributes/functionality that does not apply to them results in unwanted / unnecessary overhead on the part of the customer.  Recently DPAS received unique attribute requirements for the maintenance of aircraft parts and unique attribute requirements for the maintenance of boats.  The objective of this SCR is to provide a method for the customer to self-mange unique attribute requirements by Stock Number.

 

Create a new process that will reside within the M&U module to enable maintenance personnel to identify the 'extra' attributes that are required to manage a specific type of assets (Stock Nbr level).  The process will reside within the Catalog menu tree within M&U with  the entries being available for use by all maintenance activities that are associated to the same Maintenance Program. The data will be stored by Stock Nbr for NSN and CAGE/Part Nbrs to enable the values to be applied to all like Stock Nbrs regardless of which catalog the Stock Nbr originated.  

 

This SCR addresses how the specific attributes will be associated to a type of asset.  This capability will be used to support the completion of the following SCRs:
6. SCR 01767 - MU Data Field Additions for Boats/Craft

 

This process will allow for numerous customizations within the application to increase accuracy as well as to create efficiencies within the processes that are customized

 

Daily

 

The DPAS Catalog is established at the Logistics Program level today.  Current AF CICP users have access to the entire catalog and stock item list under the AF CMP GFP Logistics Program.  There are no access controls on the DPAS catalog other than role-based controls.  DPAS should limit CICP access to only their data, as designated by commodity types, DoDAAC and/or contract number.

 

Create a sub-catalog for each AF CICP; to record stock number entries at the ICP and Materiel Mgt Program levels.  Make use of the commodity types, DoDAACs and/or contract numbers in DPAS to limit use and viewing at the contract level.  This will prevent everyone from seeing every stock number and standard price in DPAS warehouse.

 

The problem leaves the DPAS catalog open to all users.  It is mission critical that CICPs cannot have access to other CICP data including stock numbers and standard prices.

Implementing this solution will prevent all users from seeing every stock number and standard price in the DPAS catalog and DPAS warehouse receiving process.

 

AF is reconciling the quarterly CFO reports submitted by the contractors with the transactional data the contractors enter into/interface to DPAS.  The purpose of the reconciliation is to determine if the data contained in DPAS is complete and accurate prior to enabling the automated financial reporting capability.  AF is having difficulty reconciling the asset values submitted by the contractors with those in DPAS.  The contractors’ quarterly reports are valued at latest acquisition cost while DPAS provides moving average cost on its reports and queries.  AF needs a query or report that provides asset values at latest acquisition cost for each contractor.  

 

Recommend that DPAS ICP module add the LAC and LAC Extended Price as an attribute(s) to the inventory inquiry screen.  DPAS would utilize the last submitted asset value for each item on this inquiry.  

 

This is a critical step to verify the completeness and valuation of the contractor’s assets prior to enabling the automated financial reporting.  This will provide the AF the supporting documentation necessary to complete the reconciliation

 

This provides the ability to review CICP transactions and asset valuations for accuracy prior to sending financial data to GAFS-R.  Provides an apples-to-apples comparison of asset values for the reconciliation.

 

 

DPAS PA – Asset Management does not list serial numbers in Alpha/Numerical sequence in the Serial Number column.  This causes extensive research for EAE, CEMF, and/or MAJCOMs to find and select multiple serial numbers identified by the user (customer) and flagged for processing.

 

Enable capability to sort Asset management Transfer, Update, Excess, UII, transactions by serial number, stock number, custodian number, location ect.

 

Currently sort capability is limited to dispositions and limited data elements

 

Providing this simple fix would make searching, finding, selecting, and processing serialized SE much more effective and efficient.  

 

Frequency: Daily

 

DPAS is currently using an old version of the DD1150, Request for issue/transfer/ turnin. A new version was published Aug 2022

 

Replace the older version of DD1150 for the new version dated Aug 2022

 

DoD update to the DD1150 published

 

DPAS will have the most current version of the DD1150 in use.

 

Hourly

 

Utilize the O.Req quantity as the multiplier to F.Req quantity which will auto populate the O. Auth as the product (F.Req x O.Req= O.Auth). F.Req/F. Auth match flag must be turned on to use the O. Req as the multiplier.

 

This is a mission critical requirement, as part of the readiness reporting and requirements buy, authorizations must be established in order for units to identify their requirements and the AF Sustainment Center can POM for current and future procurements for fielding

 

Improves accuracy of organizational authorizations and eliminates the potential of human error.

 

Daily

 

Offer option to produce and print a DD Form 1149 from relevant Material Release Order, similar to those from Warehouse Transfer and Warehouse Issue

 

Critical - DD Form 1149's are the Document of Record for shipping and transferring material, and we currently have to produce them manually.

 

Property accountability; reduced/time and cost; accuracy of historical paperwork.

 

Have relevant address populate in FROM: (Block 1) and TO: (Block 2)

 

Critical - in order to reduce man-hours to correct DD Form 1149 prior to shipments/accuracy of Data. DD Form 1149's are the Document of Record for shipping and transferring material, and thus must be accurate

 

Property accountability; reduced/time and cost; accuracy of historical paperwork.

 

Add DD1348 to the Warehouse Module for item issue to the customer during the Warehouse Issue.

 

Accessibility of the DD1348 enable DISA users to have better accountability of items being issued.

 

Workforce Service Directorate (WSD) is responsible for managing all DISA warehouses and would like to transition warehouse operations from DPAS property module to DPAS warehouse module.

 

Within the Stock Number AUD edit process the management code will be enabled for edit under our standard validations. The expiration override will always be enabled. Unit of issue, and stocking unit of issue will be enabled for edit. Conversion factor updates will be accounted for in the existing Inventory Update Manager.

 

Mission Critical. Users should be able to edit stock numbers to support needed updates without the necessity of submitting a data fix request for these common processes.  The expected outcome is timely changes updates performed by the user which will lessen the number of help desk tickets requesting support for these types of updates.

 

These changes will improve efficiency for the user due to less time spent modifying or removing associated inventory, or submitting a data fix request and waiting for the change to occur; Additionally, the changes will reduce costs for the DPAS project due to the expected reduction in the number of data change requests that need to be completed.

 

DPAS will update its business processes to account for externally sourced stock numbers without a using service code to enable users to catalog their items using these stock numbers.

 

Mission Critical. DPAS should be updated to account for the lack of this field. Today this is preventing several externally sourced stock numbers from being integrated into DPAS.

 

This change will improve the user's cataloging capabilities when Web FLIS NSNs are selected as the source enabling the user to select Stock Nbrs that do not contain a Using Service Cd.  

 

To allow ease of access to manufacturer part number information which defines type B ( part number ) stock numbers the associated manufacturer name, part number, and CAGE code will be added as additional columns in the results grids on both the Stock Number AUD and Stock Number Inquiry pages within DPAS.

 

Mission critical. DPAS users currently have to navigate between multiple screens within the catalog process to view data which exists at the stock number level. Users should be able to view all stock number defining data from a singular screen within DPAS

 

Once implemented in DPAS this solution will reduce time for the users to complete their data inquiries by including all stock number defining data on singular screens without the need to navigate or merge data within Excel.

 

DAAS will supply the CAGE master data in JSON format to GEX where it will be consumed by DPAS and made available to the users within relevant DPAS update processes (Address, Contractor, Manufacturer Part Nbr AUD, etc., and will be used to provide context  to the CAGE by displaying the Supplier Name within inquiries and reports).

 

Mission Critical. Today there is no data feed supplying CAGE data. Validations are already in place to limit the allowed CAGE codes, however, many invalid codes exist in the system today. This feed will allow a source for users to access official CAGE data provided by DAAS.

 

Consumption of the CAGE master data from DAAS will improve the accuracy and accountability of the DPAS system by ensuring a source exists for users to access official CAGE codes from DLA instead of relying on current logic allowing entry of any CAGE fitting the required format.

 

Add "UIC" as a column option in MAM when searching by Maint Mgt Code.

N/A

 

When mass profiling assets it's critical to be able to identify assets by owning UIC.  This prevents having to individually identifying assets by Asset ID if all assets in the UIC will be  profiled with the same few Maint Mgt Codes.

 

Currently, there is not a good way to run a report or inquiry to provide a single snapshot of all equipment in an EP or MA, including NMC status. I would like to recommend creating a new Maintenance inquiry titled Equipment Status. I would recommend the following search fields with corresponding operands and search values:

 

Mission Critical

 

Shop supervisors run a report in legacy systems every morning that allows them to see, at a quick glance the status of all equipment, including what is currently NMC and how long the asset has been NMC, without having to keep track on a separate excel document. This aids supervisors in setting maintenance priorities for the day while also giving an overall look at the health of the fleet. Also, every morning Maintenance Group commanders hold a meeting that covers many different topics, one of which is the health of Aviation Support Equipment (AvSE). The ability for shop supervisors to run this type of inquiry will be instrumental in keeping all informed on the NMC status and availability of all equipment within a Maintenance Activity or Equipment Pool. Furthermore, this will allow various MAJCOM functionals the ability to take a snapshot of the AvSE fleet health across their MAJCOM.

 

Recommend creating a new Yearly type of recurring method for Maintenance Schedules, it could be Selected Month by Year. Recommend adding to account for inspection requirements of 2, 3, 5, and 10 years. Recommend the ability to select the day and the month and the interval of years for the Maintenance Schedule (i.e., 1 January every 2 years).

 

Mandated, There are several inspections required by manufacturers of equipment that are beyond a year. Many assets require a 2, 3, 5, or 10 year inspection to be completed.

 

There are several inspections that are on a biannual, 3 year, 5 year, or in some cases 10 year basis. It would greatly benefit the enterprise if Work Orders for these inspections were guaranteed to generate on the required day, regardless of when the last inspection was completed. This ability would ensure assets do not inadvertently fall off their inspection cycle. Currently the only way to create a Maintenance Schedule for more than one year it to use the Every X Days recurring method. This method does not guarantee a Work Order will generate on the same day every time it is due, as it generates the next Work Order based of when the previous Work Order was Completed. While it is possible to have Maintenance Schedules generate Work Orders before the Asset Next Maintenance Date, that still does not guarantee that a Work Order will generate on the first of the month that it would be due.  

 

Ensure DPAS depreciation periods are in agreement with the FMR.

 

Yes.  DPAS deprecation periods must be in alignment with the FMR.

 

Provides for accurate computation of depreciation.

 

• DPAS management does not retain evidence that demonstrates that the data used in the performance of the annual review of security and admin users is complete and accurate (i.e., screenshots of parameters/query used to produce the listing its entirety prior to execution within the query tool itself, screenshots of the row count within the query tool prior to extraction to demonstrate data wasn't lost or modified in transfer, etc.). Therefore, EY was unable to determine whether the data that was used in the performance of the annual access review of security and admin user types was complete and accurate. DPAS management is also not properly monitoring that all security and admin type users are properly reviewed. For users identified as requiring access to be removed during the annual review of privileged operating system and database access, as well as DPAS application security and admin user type access, DPAS management has not established a process to:

• Identify the length of time users had access but did not require it commensurate with their job responsibilities; and

• Analyze the activity for these users for that length of time, depending on the nature and risk of the roles held by the users (privileged, elevated-risk roles as identified by management.

 

Control activity 2.8 states: “DPAS PMO requires all IO/AIOs to submit an annual user review report. DPAS PMO performs user account maintenance based on this report. If no report is received by DPAS PMO by the designated due date, all accounts associated with the IO/AIO are deactivated.”

• DPAS management is not properly monitoring the user entity-performed access reviews. Specifically, Management is not verifying the completeness and accuracy of the user listings that are used in the performance of the reviews. Also, DPAS management does not perform a comprehensive retroactive review of activity for users identified with inappropriate access during each application user access review performed by Management or the user entity. Further, in their access reviews, Management has not established a process to:

• Identify the length of time users had access but did not require it commensurate with their job responsibilities; and

• Analyze the activity for these users for that length of time, depending on the nature and risk of the roles held by the users (privileged, elevated-risk roles as identified by management)

Develop a stored procedure that can be used by DBAs to support retroactive user activity requests from IO/AIOs.

 

Mandated - This SCR is required to resolve a NFR in the FY22 SSAE audit.  

 

Passing the next SSAE audit.  

 

 

Completed – Release 2022.2.2 – 23 September 2022

Add a new table, Stored Procedure, and SQL Agent job to support the monitoring.

 

Mandated - This SCR is required to resolve a NFR in the FY22 SSAE audit.  

 

Passing the next SSAE audit.