DPAS SCR: 00609

• SCR Number
  00609
• Title
  Agency Predefined Report Capital Code N or S - Agency
• DPAS Module
  PA
• Reporting Organization
  Other
• State
  Done
• History
  Submitted: 3/18/2014
• Description

  Description
  The Agency Pre-Definded report titled "Capital Code N or S Errors" does not contain the necessary fields to adequately identify errors due to the OUSD Capitalization threshold changes went into effect 01 October 2013.

  Recommended
  Add the following fields to the Agency Predefined Report - Capital Code N or S Error report:

  • Activation Dt
  • Acq Dt
  • Local Rcpt Dt

  Mission Critical
  This report is required to identify capital assets incorrectly coded and this information is used to create Navy Monthly Metric reports which is sent to Navy Major Commands for corrective actions.

  Benefits
  Will permit Navy to correctly depreciate capital equipment in support of FIAR efforts.

  Users
  All Navy Users

  Joe Stossel comment, 2/25/2015 -
  Same as SCR 00662.

  From Randy For SCR 00609, I added the following fields to WCUSS06 Agency Defined Report:

  • Accumd Deprn
  • Acq Dt
  • Local Rcpt Dt
  • Origl In Svc Dt
  • Activation Dt.

  I named the USP a little better to make it more identifiable.
  I recommend removing the current one from the database andreplacing it with this one.
  For the pre-built report table, I recommend we update the info for the current one to the following and ensure all Site Ids in the dpas.dbo.site table have it.

  • rpt_nm - AssetsWithCapCdNOrS-SiteId
  • rpt_desc - Capital Code N or S Errors by Site Id
  • rpt_std_prcdr - uspCustomRptAssetsWithCapCdNOrS_Site_WCUSS06

  I have also created a new Pre-Build Report that will run at Agency Level that will need to be inserted into the Pre-Built report table for every Agency we have in the dpas.dbo.agencytable.
  The CI Number is WCUSS45.
  I created the FRD and have added to the FRD Archive in SharePoint.

  • rpt_nm -AssetsWithCapCdNOrS-Agency
  • rpt_desc - The extract will display all active assets with a Capital Code or N or S Errors for the Agency of the Site Id the user is logged into at time of run.
  • rpt_std_prcdr - uspCustomRptAssetsWithCapCdNOrS_Agency_WCUSS45
  • setng_lvl_cd - 5

  Note: I do not have permission to create a store procedure, so I don't know if these 2 USPs will actually build.
  I would recommend testing.

  Completed - Release 4.0 - 29 April 2016