-
Print
-
DarkLight
-
PDF
Asset Replacement Cost by Asset Category Type (AMR062)
-
Print
-
DarkLight
-
PDF
Report Description
This report provides summary totals and a detail list of replacement costs by asset category, for any asset records that have a replacement cost recorded (e.g., entered by a user or updated via an interface or spreadsheet upload). This report supports comparison of expected replacement costs to asset book value, with consideration for asset remaining useful life. This on-demand report is intended for agency users but may also be used by enterprise users.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Report Audience
- Florida PALM Subject Matter Experts (SME’s)
- Reporting Team
- Key enterprise partners
Suggested Report Frequency
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
---|---|---|---|---|
Business Unit | N | Financials – Asset Overview.Asset Business Unit.Business Unit | Y | Y |
Organization | N | Financials – Asset Overview.Asset Business Unit.Organization | N | Y |
Project | N | Financials – Asset Overview.Asset.Project ID | N | Y |
Grant | N | Financials – Asset Overview.Asset.Grant ID | N | Y |
Contract | N | Financials – Asset Overview.Asset.Contract ID | N | Y |
Asset ID | N | Financials – Asset Overview.Asset.Asset Number | N | Y |
Asset Category | N | Financials – Asset Overview.Asset.Asset Category | N | Y |
Asset Status | N | Financials – Asset Overview.Asset.Asset Status Description | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
---|---|
Business Unit | Financials – Asset Overview.Asset Business Unit.Business Unit |
Organization | Financials – Asset Overview.Asset Business Unit.Organization |
Asset ID | Financials – Asset Overview.Asset.Asset Number |
Asset Description | Financials – Asset Overview.Asset,Description |
Asset Category | Financials – Asset Overview.Asset Category.Category |
Tag Number | Finacials – Asset Overviw.Asset.Tag Number |
Remaining Useful Life | Financials – Asset Overview.Facts – Asset Payments.Useful Life |
Asset Cost (w improvements / adjustments) | Financials – Asset Overview.Asset.Original Cost + Financials – Asset Overview.Facts – Asset Utilization.Cost Adjustment Amount + Financials – Asset Overview.Facts – Asset Payments.Improvement Cost |
Asset Accumulated Depreciation | Financials – Asset Overview.Facts – Asset Balance.Total Depreciation Expense Amount |
Asset Net Book Value | (Financials – Asset Overview.Asset.Original Cost + Financials – Asset Overview.Facts – Asset Utilization.Cost Adjustment Amount + Financials – Asset Overview.Facts – Asset Payments.Improvement Cost) - Financials – Asset Overview.Facts – Asset Depreciation.Total Depreciation Expense Amount |
Replacement Cost | Financials – Asset Overview.Facts – Asset Payments.Replacement Cost |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
---|---|
01/31/2025 | Original Version |