Maintenance Attribute Management
|
01836
|
MU |
Leidos |
In Progress |
Change Request: New System process
Description:
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.
Recommended:
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.
Mission Critical:
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:
1. SCR 01711 - M&U Corrosion Score and Coating Fields for Work Order Forms
2. SCR 01631 - Nuclear, Reimbursable, Mission Critical Indicator
3. SCR 01330 - Nuclear, Reimbursable, Mission Critical Indicator Reflect on Basic Work Order
4. SCR 01744 - UTIL Modification for Boat Engine Hours
5. SCR 01766 - MU Data Field Suppression for Boats/Craft
6. SCR 01767 - MU Data Field Additions for Boats/Craft
Benefits:
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
Frequency:
Daily
Users:
All customers that utilize the M&U module will benefit by the implementation of this SCR as it will reduce the number of attributes they will need to manage if it were not implemented with the completion of the SCRs identified in Type of Change section.
Partially Completed – Release 2023.1.6 – 24 March 2023 |
Limit CICP data visibility by Commodity DoDAAC or Contract
|
01835
|
Materiel Management |
USAF GFM-A |
New |
Description:
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.
Recommended:
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.
Mission Critical:
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.
Benefits:
Implementing this solution will prevent all users from seeing every stock number and standard price in the DPAS catalog and DPAS warehouse receiving process.
Users:
All AF GFM-A users of DPAS |
Latest Acquisition Cost Inventory Inquiry
|
01834
|
Materiel Management |
USAF GFM-A |
New |
Description:
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.
Recommended:
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.
Mission Critical:
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
Benefits:
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.
Users:
ALL AF GFM-A users of DPAS |
Sort capability for Asset Management
|
01833
|
PA |
AF: A4/HAF FH-AFHAF |
New |
Change Request: Process Improvement
Description:
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.
Recommended:
Enable capability to sort Asset management Transfer, Update, Excess, UII, transactions by serial number, stock number, custodian number, location ect.
Mission Critical:
Currently sort capability is limited to dispositions and limited data elements
Benefits:
Providing this simple fix would make searching, finding, selecting, and processing serialized SE much more effective and efficient.
Frequency: Daily
Users:
~2000 |
New DD1150 Form
|
01832
|
Enterprise |
DDD/ DoD |
New |
Change Request: Policy/ Regulatory
Description:
DPAS is currently using an old version of the DD1150, Request for issue/transfer/ turnin. A new version was published Aug 2022
Recommended:
Replace the older version of DD1150 for the new version dated Aug 2022
Mission Critical:
DoD update to the DD1150 published
Benefits:
DPAS will have the most current version of the DD1150 in use.
Frequency:
Hourly
Users:
Across DoD |
Automate O.Auth qty with FSM multiplier
|
01831
|
FSM |
AF: A4/HAF FH-AFHAF |
New |
Change Request Type:
New System process
Description:
Currently, O. Auth quantities are a manual input. Authorization managers calculate the O. Auth by multiplying the F_Req by the O_Req = O_Auth
Recommended:
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.
Mission Critical:
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
Benefits:
Improves accuracy of organizational authorizations and eliminates the potential of human error.
Frequency:
Daily
Users:
AF Enterprise |
Add DD1149 to MRO
|
01830
|
Warehouse |
NAVY NBG-2 |
New |
Description:
Material Release Order does not produce a DD Form 1149
Recommended:
Offer option to produce and print a DD Form 1149 from relevant Material Release Order, similar to those from Warehouse Transfer and Warehouse Issue
Mission Critical:
Critical - DD Form 1149's are the Document of Record for shipping and transferring material, and we currently have to produce them manually.
Benefits:
Property accountability; reduced/time and cost; accuracy of historical paperwork.
Users:
Yes |
DD1149 Address Block Additions
|
01829
|
Warehouse |
Navy NBG-2 |
New |
Description:
DD Form 1149 does not complete (populate) with all required data. Address of sending and receiving organizations do not populate, even though the associated addresses have been loaded (Master Data Mgmt > Warehouse; select Warehouse > Edit > POC Info)
Recommended:
Have relevant address populate in FROM: (Block 1) and TO: (Block 2)
Mission Critical:
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
Benefits:
Property accountability; reduced/time and cost; accuracy of historical paperwork.
Users:
Yes |
Service Microservice
|
01828
|
Enterprise |
Leidos |
In Progress |
Signed SCR attached
Description:
During the initial Feature Flag implementation in DPAS, the architecture team recognized that a new microservice would be required to properly manage and access services like the Feature Flag. This requirement is in support of the DPAS modernization effort.
Recommended Solution:
Implement a Service Management microservice. While the microservice will be usable for additional processes later, the initial use will be for the Feature Flag. We will create API endpoints to retrieve feature flags from the feature_flag table and synchronously retrieve enabled features associated to its microservice on start-up. We will also develop a UI for users with a certain role (e.g., Feature Flag Manager) to turn the feature flag on/off via toggle switch. When a change is made, an event will fire to log/notify the subscriber that the feature flag change occurred.
Mission Critical or Mandated:
It is critical for DPAS standard system functionality to implement a microservice for service management.
The recommended solutions will improve service management.
Partially Completed – Release 2022.3.2 – 02 December 2022
|
DD Form 1348 for WM Issue
|
01827
|
Warehouse |
DISA |
New |
Description:
The warehouse module doesn't currently create DD1348 for warehouse Issue. We would like to use the DD1348 as issuing document. Using the DD1348 will create a separate document for each like item only. This will make it easier to keep accountability of items being issue.
Recommended:
Add DD1348 to the Warehouse Module for item issue to the customer during the Warehouse Issue.
Mission Critical:
Accessibility of the DD1348 enable DISA users to have better accountability of items being issued.
Benefits:
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.
Users:
Yes, this action affects all user within the Agency. |
Catalog Stock Number Edit
|
01826
|
Enterprise |
Leidos |
In Progress |
Description:
The Stock Number AUD within DPAS currently prevents the update of several fields due to the association to ICNs and/or inventory assets, prompting users to submit data fix requests. We propose opening up certain fields during the Stock Number edit process to allow users to make changes to the stock number record as well as required updates to inventory handled automatically through the existing Stock Number process.
Recommended:
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:
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.
Benefits:
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.
Users:
This change will impact/benefit all users of the DPAS Stock Nbr AUD Process.
Partially Completed – Release 2022.3.2 – 02 December 2022
Partially Completed – Release 2023.1.2 – 27 January 2023 |
WebFlis Catalog Migration Using Service Compliance
|
01825
|
Enterprise |
Leidos |
New |
Description:
Currently DPAS receives NSNs from FLIS containing no data in SEG H. DLA confirmed this is expected for NSNs only used by Foreign services. Current DPAS business rules prevent these stock numbers from loading to the master table for selection / use by the DPAS user. To resolve this issue DPAS will update the FLIS import process to account for this missing segment and apply a using service code of X - Abbreviated Segment H to the stock number. DPAS users will then be able to utilize these NSNs.
Recommended:
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:
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.
Benefits:
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.
Users:
This change will impact/benefit all users of the DPAS Stock Nbr AUD Process. |
Stock Number MPN Additions
|
01824
|
Enterprise |
Leidos |
Done |
Description:
Recently DPAS implemented changes to support a one to one association between stock item type B ( Part Numbers ) and Manufacturer Part Numbers. Currently the manufacturer's name, CAGE, and part number are not included within the returned data on the existing stock number screens. To support day to day data inquiry these fields will be included on both the Stock Number AUD and the Stock Number Inquiry.
Recommended:
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:
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
Benefits:
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.
Users:
This change will impact/benefit all users of DPAS cataloging processes.
Completed – Release 2023.1.1 – 13 January 2023 |
CAGE Interface Data Import
|
01823
|
Enterprise |
Leidos |
In Progress |
Description:
As of May 2022 CAGE data is being sent to DAAS in two forms, a monthly full file and daily update files. The monthly files will be a complete set of commonly requested CAGE data, current as of the file date stamp. Daily update files will contain only changes from previous day’s data. Each of these files will be sent to DAAS in JSON format and CAGE Data Element descriptions will be provided by DAAS. To consume this data for use within DPAS the JSON files will be passed to GEX to be consumed by the system. DPAS will be updated to allow the user reference to this data within the cataloging processes to ensure utilization of official CAGE codes.
Recommended:
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:
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.
Benefits:
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.
Users:
This change will impact/benefit all users of all DPAS processes where CAGE codes are utilized.
Partially Completed – Release 2023.1.6 – 24 March 2023 |
Add UIC Column Option to MAM Mass Edit
|
01822
|
MU |
USAF AvSE |
New |
Description:
MAM Mass Edit (Search by Maint Mgt Code) does not have the UIC as a column option. This severely limits user ability to mass profile without identifying individual Asset IDs. In most cases, users will profile all assets in the UIC with the same few Maint Mgt Codes (either MAU, MNT, or NMU). This can be easily accomplished if MAM search results contain the UIC column.
Recommended:
Add "UIC" as a column option in MAM when searching by Maint Mgt Code.
Mission Critical:
N/A
Benefits:
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.
Users:
All |
MU Equipment Status Inquiry
|
01821
|
MU |
USAF AvSE |
New |
Description:
Add the ability to run an inquiry that shows equipment status for an EP or MA.
Recommended:
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:
Search Field Operands Search Value
Asset ID =/>/Like IntelliSense
Asset S/N =/>/Like IntelliSense
DoD/Secondary S/N =/>/Like IntelliSense
Maintenance Activity =/>/Like IntelliSense
Equipment Pool =/>/Like IntelliSense
NMC Status = Yes/No
I would recommend the search results grid populates with clickable links to Work Orders and an option to print the entire list.
Mission Critical:
Mission Critical
Benefits:
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.
Users:
All users daily, at least 7 days a week/possibly several times a day |
Add Multi Year Maintenance Schedule Options
|
01820
|
MU |
USAF: AvSE |
New |
Description:
Maintenance Schedules do not have an option to accommodate 2-year, 3-year, etc., inspection requirements.
Recommended:
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).
Mission Critical:
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.
Benefits:
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.
Users:
This will affect all Aviation Support Equipment (AvSE) users within the Maintenance and Utilization (M&U) module. It may affect users in other Site IDs if they have inspections based on yearly increments. |
DPAS Depreciation Period FMR 7000.14R Review
|
01819
|
PA |
Leidos |
In Progress |
Description:
This SCR is for DPAS to review the FMR 7000.14R and compare the depreciation periods to what DPAS has, then update the depreciation periods in DPAS as required, except where a component has received an approval for a deviation from the value contained within the FMR.
Recommended:
Ensure DPAS depreciation periods are in agreement with the FMR.
Mission Critical:
Yes. DPAS deprecation periods must be in alignment with the FMR.
Benefits:
Provides for accurate computation of depreciation.
Users:
Components / Agencies with capital assets
Partially Completed – Release 2022.3.2 – 02 December 2022 |
Retroactive User Activity
|
01818
|
Enterprise |
Leidos |
Done |
Description:
Control activity 2.7 states “DLA Information Operations conducts an annual review of individuals with privileged operating system and database access and DPAS application security and admin user type access. The results of these annual reviews are documented, retained, and inappropriate access is removed. User Account Activity Logs are reviewed for accounts found to have inappropriate access, which is addressed in CA 2.10.”
• 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)
• DPAS management also does not have a process in place to properly monitor that the user entities are ensuring that all users that have access are properly reviewed.
Recommended:
Develop a stored procedure that can be used by DBAs to support retroactive user activity requests from IO/AIOs.
Mission Critical:
Mandated - This SCR is required to resolve a NFR in the FY22 SSAE audit.
Benefits:
Passing the next SSAE audit.
Users:
This process will be used mainly by the DBAs to support IO/AIOs requests.
Completed – Release 2022.2.2 – 23 September 2022
|
Database Backup Monitoring
|
01817
|
Enterprise |
Leidos |
Done |
Description:
Control activity 5.4 states: “DLA Information Operations personnel monitor the successful completion of database backup and document the results in a monthly MFR.” • From October 2021 through May 2022 DPAS did not actively monitor the successful completion of database backups. DPAS researched database backup failures if they were notified of any through an automated notification process. DPAS was also unable to provide evidence demonstrating this control since database backup logs or database backup notifications were not retained.
Recommended:
Add a new table, Stored Procedure, and SQL Agent job to support the monitoring.
Mission Critical:
Mandated - This SCR is required to resolve a NFR in the FY22 SSAE audit.
Benefits:
Passing the next SSAE audit.
Users:
This process will be used mainly by the DBAs.
Completed – Release 2022.2.2 – 23 September 2022
|