DPAS SCR: 00427

• SCR Number
  00427
• Title
  Asset Tracker Report
• DPAS Module
  PA
• Reporting Organization
  Other
• State
  Removed
• History
  Submitted: 10/15/2009
• Description

  Description
  In DPAS Legacy, user created a Eureka report called "Asset Tracker"

  Recommended
  Need a User Defined Inquiry called Asset Tracker. The SQL that Eureka generated is attached.
  This query would read the Asset Master for all assets that have an Asset ID not like "PG" and the UIC not like:

  • SITEMI
  • CPO100
  • CPOSHP
  • CPOGFE
  • CPODLT
  • CPO150
  • CPOADD
  • CPOAVH
  • CPOEAA
  • CPOFLD
  • CPOMAL
  • CPORCV
  • CPOSTR
  • CPOWAR
  • CPO*M

  Fields to output are:

  • Total Amt
  • Asset ID
  • Doc Nbr
  • Eff Dt
  • Major Custodian Nbr
  • Last Inventory Dt
  • Location
  • Mfr Name
  • Model
  • Item Desc
  • Agency 1
  • Agency 2
  • Serial Nbr
  • Stock Nbr
  • Sub Loc
  • UIC

  SQL indicates displaying the MFE Part Nbr, but user wants the Model displayed instead. Office should be replaced with Agency 1 and Agency 2 fields.

  Mission Critical
  Critical. This report / query is run on a daily basis.

  Benefits
  This report is needed to generate daily and the current reports / queries do not give this functionality.

  Users
  All users.

  23Aug2016 – cancelled per Joe Stossel
  Set to canceled in Joe S meeting.

×

×

Welcome to the NEW ELMS Support Site. You may still see some documents or other items still referencing DPAS, but we are working to update our remaining content as soon as possible. Be sure to update your bookmark to https://elmssupport.golearnportal.org.

 

Please note that the URL for the live Production environment has changed due to the ELMS name rebranding process. The new URL for ELMS Production is: https://prod.elms.dla.mil