Fixed_Asset_Implementation_Requirement_Specification_12152025.docx.pdf

738 KB Posted

Attached to
AC150 (Capital Asset)/Movable Asset Implementation in Oracle Fixed Asset in e-Business Suite (EBS)
Solicitation number
99586
Issued by
Prince George's County, Maryland

About this file

Written by GovTribe AI ·

This is an IT Business Analysis Requirements Specification document for the Washington Suburban Sanitary Commission (WSSC) in Maryland, detailing the implementation requirements for the Fixed Asset Module in Oracle E-Business Suite (EBS). The project aims to migrate two legacy mainframe applications—AC150 (Capital Asset) and Movable Asset systems—into a unified Oracle EBS Fixed Assets Module. The primary objectives include consolidating separate systems into a single platform, enhancing operational efficiency, streamlining asset management processes, and reducing costs. The implementation encompasses asset tracking for infrastructure, water and sewer pipes, water meters, vehicles, and equipment. The solicitation, issued by WSSC, requires sealed responses submitted via the WSSC eProcurement Portal prior to 2:00 PM on Monday, July 27, 2026. The project involves Oracle Fixed Asset Consultant and Professional Services to support the migration, historical data migration, system customization for asset value allocation, and enablement of asset creation, updating, and reporting functionalities.

The requirements specification document provides comprehensive functional, business, and data requirements organized into eight use cases covering module access, data migration, asset information creation and updates, and reporting capabilities. The system must integrate seamlessly with WSSC's existing Oracle EBS environment and General Ledger module while interfacing via flat files with external systems including Engineering and Construction team platforms, Work and Asset Management (WAM), Dossier, and Customer-to-Meter (C2M) systems. Key functional requirements include role-based access control using Single Sign-On (SSO), file validation with required fields and data types, automatic asset identification number assignment, depreciation calculation using the straight-line method, and comprehensive audit tracking. The solution must support both fixed assets (pipes, meters, infrastructure) and movable assets (vehicles, equipment) with strict criteria requiring movable assets to have a useful life exceeding one year and unit cost greater than $10,000. The requirements include seeded and ad hoc reporting capabilities with export options in Excel, PDF, and CSV formats, with no requirement for developer assistance for common queries.

View the file

Other files

File Type Posted
AC150_(Capital_Asset)_Movable_Asset_Implementation_in_Oracle_Fixed_Asset_in_e-Business_Suite_(EBS)_(Addendum_#1_Revision).pdf PDF
AC150_(Capital_Asset)_Movable_Asset_Implementation_in_Oracle_Fixed_Asset_in_e-Business_Suite_(EBS).pdf PDF
Fixed_Asset_Module_Customizations_Document.pdf PDF
Fixed_Asset_Implementation_Requirement_Specification.pdf PDF
Fixed_Asset_Module_Customizations_Document_120125.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

IT Business Analysis

Fixed Asset Module Implementation Requirements Specification

Project Name Fixed Asset Module Implementation

Business Unit Accounting Division

Project Sponsor Joe Edwards

Author Bhumik Patel

Version 1.1

Date December 15th, 2025

Docusign Envelope ID: 55C62D81-1526-476D-B022-C0D282D1452C

This section denotes the approval of the content provided in this deliverable and is confirmed by the stakeholders signing below.

Approver Name Title/Dept. Project Role Signature Date

Rong Zhao Division Manager / Accounting

Business Lead / Approver

Dec 19, 2025 | 7:42 AM EST

Table of Contents

1 INTRODUCTION

1.1 PURPOSE

1.2 DOCUMENT ORGANIZATION

1.3 STAKEHOLDERS

2 USE CASE ANALYSIS

2.1 USE CASE DESCRIPTIONS

2.2 ACTORS

2.3 FIXED ASSET MODULE IMPLEMENTATION USE CASE MODEL

3 REQUIREMENTS

3.1 FUNCTIONAL REQUIREMENTS

3.2 BUSINESS RULES

3.3 DATA REQUIREMENTS

4 REQUIREMENTS TRACEABILITY MATRIX

4.1 FUNCTIONAL REQUIREMENTS / DATA REQUIREMENTS / BUSINESS RULES

1 Introduction

AC150 and MAIS are mainframe-based applications currently used by the Accounting Division. Both systems are scheduled to be replaced by the Fixed Assets module in Oracle E-Business Suite (EBS). To ensure a successful migration, the IT Application Services Division has requested development of requirements of the Fixed Asset module.

Business Group Intranet URL

Accounting Division https://wsscoffice365.sharepoint.com/sites/rtfinance/SitePages/hubley%20Pages /accounting-division-home.aspx?csf=1&web=1&e=3s3leU&CID=bfe3ee9e-7db5- 4380-a484-480b9cac4857

1.1 Purpose

This document will provide the requirements (e.g., functional, data requirements, and business rules) elicited from the subject matter experts for the Fixed Asset Module Implementation project.

1.2 Document Organization

Section 1 – This section provides background information.

Section 2 – This section provides use case analysis artifacts, including use case model, and use cases with descriptions.

Section 3 – This section provides functional requirements, business rules, and data requirements.

Section 4 – This section provides requirements traceability matrix.

https://wsscoffice365.sharepoint.com/sites/rtfinance/SitePages/hubley%20Pages/accounting-division-home.aspx?csf=1&web=1&e=3s3leU&CID=bfe3ee9e-7db5-4380-a484-480b9cac4857 https://wsscoffice365.sharepoint.com/sites/rtfinance/SitePages/hubley%20Pages/accounting-division-home.aspx?csf=1&web=1&e=3s3leU&CID=bfe3ee9e-7db5-4380-a484-480b9cac4857 https://wsscoffice365.sharepoint.com/sites/rtfinance/SitePages/hubley%20Pages/accounting-division-home.aspx?csf=1&web=1&e=3s3leU&CID=bfe3ee9e-7db5-4380-a484-480b9cac4857

1.3 Stakeholders

This table provides primary stakeholders for this initiative:

Stakeholder Title/Dept. Project Role Phone Number

Ezeugwu, N David

Solution Architect / IT Application Services Division

Technical Lead 301-206-8619

Kelch, Diana Accountant III / Accounting Division

Subject Matter Expert

301-206-8236

Murphy, Kerry E

Section Manager / Accounting Division

Subject Matter Expert

301-206-8856

Zhao, Rong

Division Manager / Accounting Division

Business Lead / Approver

301-206-8311

Pradhan, Prajwal

Section Manager / Accounting Division

Subject Matter Expert

301-206-8511

Kelley, Jason C Accountant III / Accounting Division

Subject Matter Expert

301-206-7043

Beckman, Delia

Section Manager / Accounting

Subject Matter Expert

301-206-8301

Mahmoudi, Ali

Section Manager / IT Application Services Division

Subject Matter Expert

301-206-8462

Workeman, Myeshia

Accountant I / Accounting Division

Subject Matter Expert

301-206-7977

Elias Eshetu Functional Implementer / Accounting Division

Subject Matter Expert

301-206-8434

2 Use Case Analysis

2.1 Use Case Descriptions

Use Case Name Use Case Description UC226745 – Access the Oracle EBS Fixed Asset Module

This use case is to access the Oracle EBS Fixed Asset Module.

UC224973 – Migrate Fixed Asset Data to Oracle EBS

This use case is to migrate historical fixed Asset Data to the Oracle EBS Fixed Asset Module.

UC224972 – Migrate Movable Asset Data to Oracle EBS

This use case is to migrate historical movable asset data to the Oracle EBS Fixed Asset Module.

UC224968 – Create Fixed Asset Information

This use case is to create fixed asset and water meter entries in the Oracle EBS Fixed Asset Module.

UC224982 – View/Update Fixed Asset Information

This use case is to update fixed asset and water meter information in the Oracle EBS Fixed Asset Module.

UC224984 – Create Movable Asset Information

This use case is to create movable asset information in the Oracle EBS Fixed Asset Module.

UC224997 – View/Update Movable Asset Information

This use case is to update movable asset information in the Oracle EBS Fixed Asset Module.

UC224983 – Generate Asset Information Reports

This use case is to generate fixed and movable asset information reports.

2.2 Actors

Actor Name Actor Description

AC225003 – Fixed Asset Information Creator

The fixed asset information creator is the WSSC Water employee who will create fixed and moveable assets.

AC225004 – Fixed Asset Information Viewer

The fixed asset information viewer is the WSSC Water employee that will have the ability to view information in Oracle EBS.

AC225002 – Fixed Asset Administrator The fixed asset administrator is the WSSC Water employee who will have administrator access to the Oracle EBS Fixed Asset Module.

http://cob-bprintp-01:8080/?ArtifactId=226745 http://cob-bprintp-01:8080/?ArtifactId=224973 http://cob-bprintp-01:8080/?ArtifactId=224972 http://cob-bprintp-01:8080/?ArtifactId=224968 http://cob-bprintp-01:8080/?ArtifactId=224982 http://cob-bprintp-01:8080/?ArtifactId=224984 http://cob-bprintp-01:8080/?ArtifactId=224997 http://cob-bprintp-01:8080/?ArtifactId=224983 http://cob-bprintp-01:8080/?ArtifactId=225003 http://cob-bprintp-01:8080/?ArtifactId=225004 http://cob-bprintp-01:8080/?ArtifactId=225002

2.3 Fixed Asset Module Implementation Use Case Model

3 Requirements

3.1 Functional Requirements

Requirement ID - Name Requirement Description Priority

UC226745 – Access the Oracle EBS Fixed Asset Module

FR226756 – Provide Access The system shall provide access to the module using SSO.

Must Have

FR226757 – Provide Role Based Access The system shall provide role based access.

Must Have

UC224973 – Migrate Fixed Asset Data to Oracle EBS

FR225429 – Request Historical Fixed Asset Data

The system shall request historical fixed asset data in an Excel template.

Must Have

FR225431 – Upload Fixed Asset Excel File The system shall upload the completed fixed asset Excel file to a secure staging area.

Must Have

FR225432 – Validate Fixed Asset File Structure

The system shall validate the structure of the fixed asset Excel file.

Must Have

FR225433 – Save Fixed Asset Records The system shall save all validated fixed asset records.

Must Have

UC224972 – Migrate Movable Asset Data to Oracle EBS

FR225437 – Request Historical Movable Asset Data

The system shall request historical movable asset data in an Excel template.

Must Have

FR225438 – Upload Movable Asset Excel File The system shall upload the completed movable asset Excel file to a secure staging area.

Must Have

FR225439 – Validate Movable Asset File Structure

The system shall validate the structure of the movable asset Excel file.

Must Have

FR225440 – Save Moveable Asset Records The system shall save all validated moveable asset records.

Must Have

UC224968 – Create Fixed Asset Information

FR225443 – Request Fixed Asset Information The system shall request fixed asset data from Engineering & Construction team.

Must Have

FR225541 – Request Meter Intake Information The system shall request meter intake information from the Oracle inventory system.

Must Have

FR227163 – Provide Meter Intake Information The Oracle inventory system shall provide meter intake information.

Must Have

FR227450 – Request Horizontal Pipe Information

The system shall request horizontal pipe information from Capital Accounting.

Must Have

FR227456 – Request Horizontal Pipe Cost Information

The system shall request horizontal pipe cost information from the General Ledger.

Must Have

Docusign Envelope ID: 55C62D81-1526-476D-B022-C0D282D1452C http://cob-bprintp-01:8080/?ArtifactId=226745 http://cob-bprintp-01:8080/?ArtifactId=226756 http://cob-bprintp-01:8080/?ArtifactId=226757 http://cob-bprintp-01:8080/?ArtifactId=224973 http://cob-bprintp-01:8080/?ArtifactId=225429 http://cob-bprintp-01:8080/?ArtifactId=225431 http://cob-bprintp-01:8080/?ArtifactId=225432 http://cob-bprintp-01:8080/?ArtifactId=225433 http://cob-bprintp-01:8080/?ArtifactId=224972 http://cob-bprintp-01:8080/?ArtifactId=225437 http://cob-bprintp-01:8080/?ArtifactId=225438 http://cob-bprintp-01:8080/?ArtifactId=225439 http://cob-bprintp-01:8080/?ArtifactId=225440 http://cob-bprintp-01:8080/?ArtifactId=224968 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=227163 http://cob-bprintp-01:8080/?ArtifactId=227450 http://cob-bprintp-01:8080/?ArtifactId=227456

Requirement ID - Name Requirement Description Priority

FR225496 – Assign Fixed Asset Identification Number

The system shall assign a fixed asset identification number.

Must Have

FR225501 – Provide New Fixed Asset Information for Review

The system shall provide new fixed asset information for review prior to finalization.

Must Have

FR225511 – Provide Fixed Asset Depreciation The system shall provide fixed asset depreciation expenses to the General Ledger System.

Must Have

FR225516 – Request Asset Cost Allocation The system shall allocate actual project costs from the General Ledger to each asset record associated with the project.

Must Have

FR227164 – Provide Asset Cost Allocation The General Ledger System shall provide asset costs to the Fixed Asset Module.

Must Have

FR226586 – Validate Fixed Asset Information The system shall validate fixed asset information.

Must Have

FR226588 – Provide Failed Validation Notification

The system shall provide a failed fixed asset information validation notification.

Must Have

FR226587 – Request Save Fixed Asset Information Decision

The system shall request a save fixed asset information decision.

Must Have

FR226562 – Save Fixed Asset Information The system shall save validated fixed asset information.

Must Have

UC224982 – View/Update Fixed Asset Information

FR225550 – Request Fixed Asset Identification Information

The system shall request fixed asset identification information.

Must Have

FR225548 – Provide Fixed Asset Information The system shall provide fixed asset information.

Must Have

FR225551 – Request Update Fixed Asset Information Decision

The system shall request an update fixed asset information decision.

Must Have

FR226589 – Validate Updated Fixed Asset Information

The system shall validate the updated fixed asset information.

Must Have

FR226593 – Provide Failed Updated Fixed Asset Information Notification

The system shall provide a failed updated fixed asset information notification.

Must Have

FR226591 – Update Fixed Asset Information The system shall update the fixed asset information.

Must Have

FR226590 – Request Save Updated Fixed Asset Information Decision

The system shall request a save updated fixed asset information decision.

Must Have

FR226592 – Save Updated Fixed Asset Information

The system shall save the updated fixed asset information.

Must Have

FR225553 – Request Retire Fixed Asset Information

The system shall request retire fixed asset information decision.

Must Have

FR225557 – Request Meter Disposal Information

The system shall request meter disposal information from the C2M system.

Must Have

FR225558 – Request Enhancement to Fixed Asset Link

The system shall request to link enhancements to original assets and track changes to depreciation.

Must Have

FR225559 – Provide Interface with General Ledger

The system shall provide an interface with the General Ledger to reflect

Must Have

Docusign Envelope ID: 55C62D81-1526-476D-B022-C0D282D1452C http://cob-bprintp-01:8080/?ArtifactId=225496 http://cob-bprintp-01:8080/?ArtifactId=225501 http://cob-bprintp-01:8080/?ArtifactId=225511 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=227164 http://cob-bprintp-01:8080/?ArtifactId=226586 http://cob-bprintp-01:8080/?ArtifactId=226588 http://cob-bprintp-01:8080/?ArtifactId=226587 http://cob-bprintp-01:8080/?ArtifactId=226562 http://cob-bprintp-01:8080/?ArtifactId=224982 http://cob-bprintp-01:8080/?ArtifactId=225550 http://cob-bprintp-01:8080/?ArtifactId=225548 http://cob-bprintp-01:8080/?ArtifactId=225551 http://cob-bprintp-01:8080/?ArtifactId=226589 http://cob-bprintp-01:8080/?ArtifactId=226593 http://cob-bprintp-01:8080/?ArtifactId=226591 http://cob-bprintp-01:8080/?ArtifactId=226590 http://cob-bprintp-01:8080/?ArtifactId=226592 http://cob-bprintp-01:8080/?ArtifactId=225553 http://cob-bprintp-01:8080/?ArtifactId=225557 http://cob-bprintp-01:8080/?ArtifactId=225558 http://cob-bprintp-01:8080/?ArtifactId=225559 updates to asset values and depreciation amounts.

FR225560 – Enforce Role-Based Access Control

The system shall enforce role-based access control.

Must Have

FR226571 – Track Fixed Asset Information Updates

The system shall track fixed asset information updates for audit history.

Must Have

UC224984 – Create Movable Asset Information

FR226550 – Request Create Movable Asset Records

The system shall request to create movable asset records.

Must Have

FR226554 – Provide Asset Class for Selection The system shall provide asset class for selection.

Must Have

FR226555 – Provide Organization Numbers for Selection

The system shall provide organization numbers for selection.

Must Have

FR226553 – Provide Status Code for Selection

The system shall provide status code for selection.

Must Have

FR226557 – Provide Straight Line Depreciation

The system shall provide straight line depreciation.

Must Have

FR231863 – Request Moveable Asset Data The system shall request moveable asset data in a standardized format (may be spreadsheet).

Must Have

FR231862 – Upload Moveable Asset Data The system shall upload moveable asset data using a standardized format (may be spreadsheet-based).

Must Have

FR231869 – Request Movable Asset Information from Dossier

The system shall request movable asset information from the Dossier system.

Must Have

FR231868 – Provide Movable Asset Information

The Dossier system shall provide moveable asset information (vehicles and large equipment) through interface.

Must Have

FR226559 – Provide Moveable Asset Information for Review

The system shall provide the moveable asset information in a staging area (interfaced data from the Dossier system) for review.

Must Have

FR226734 – Validate Movable Asset Information

The system shall validate movable asset information.

Must Have

FR226732 – Provide Movable Validation Failed Notification

The system shall provide a failed movable asset information validation notification.

Must Have

FR226733 – Request Save Movable Asset Information Decision

The system shall request a save movable asset information decision.

Must Have

FR226561 – Save Moveable Asset Information

The system shall save validated moveable asset information.

Must Have

UC224997 – View/Update Movable Asset Information

FR226568 – Request Movable Asset Identification Information

The system shall request movable asset identification information.

Must Have

FR226567 – Provide Movable Asset Information

The system shall provide movable asset information.

Must Have

Docusign Envelope ID: 55C62D81-1526-476D-B022-C0D282D1452C http://cob-bprintp-01:8080/?ArtifactId=225560 http://cob-bprintp-01:8080/?ArtifactId=226571 http://cob-bprintp-01:8080/?ArtifactId=224984 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226554 http://cob-bprintp-01:8080/?ArtifactId=226555 http://cob-bprintp-01:8080/?ArtifactId=226553 http://cob-bprintp-01:8080/?ArtifactId=226557 http://cob-bprintp-01:8080/?ArtifactId=231863 http://cob-bprintp-01:8080/?ArtifactId=231862 http://cob-bprintp-01:8080/?ArtifactId=231869 http://cob-bprintp-01:8080/?ArtifactId=231868 http://cob-bprintp-01:8080/?ArtifactId=226559 http://cob-bprintp-01:8080/?ArtifactId=226734 http://cob-bprintp-01:8080/?ArtifactId=226732 http://cob-bprintp-01:8080/?ArtifactId=226733 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=224997 http://cob-bprintp-01:8080/?ArtifactId=226568 http://cob-bprintp-01:8080/?ArtifactId=226567

FR226569 – Request Update Movable Asset Information Decision

The system shall request an update movable asset information decision.

Must Have

FR226738 – Validate Updated Movable Asset Information

The system shall validate the updated movable asset information.

Must Have

FR226739 – Provide Failed Updated Movable Asset Information Notification

The system shall provide a failed updated movable asset information notification.

Must Have

FR226740 – Update Movable Asset Information

The system shall update the movable asset information.

Must Have

FR226741 – Request Save Updated movable Asset Information Decision

The system shall request a save updated movable asset information decision.

Must Have

FR226737 – Save Updated Movable Asset Information

The system shall save the updated movable asset information.

Must Have

FR226573 – Request Moveable Asset Disposal Information

The system shall request moveable asset disposal information.

Must Have

FR226572 – Track Moveable Asset Information Updates

The system shall track moveable asset information updates for audit history.

Must Have

UC224983 – Generate Asset Information Reports

FR226576 – Provide Seeded Reports for Selection

The system shall provide seeded reports for selection.

Must Have

FR226582 – Provide Asset Creation Report The system shall provide a custom asset creation report.

Must Have

FR226583 – Provide Ad-Hoc Report The system shall provide ad hoc reports using customizable fields.

Must Have

FR226579 – Request Generate Report Decision

The system shall request a generate report decision.

Must Have

FR227601 – Request Generate Pipe Study Report Decision

The system shall request a generate pipe study report decision.

Must Have

FR226742 – Generate Report The system shall generate report. Must Have

FR226578 – Request Schedule Report Decision

The system shall request a schedule report decision.

Must Have

FR226730 – Run Scheduled Report The system shall run scheduled report. Must Have

FR226581 – Request an Export Report Decision

The system shall request an export report decision.

Must Have

FR226743 – Export Report The system shall export report. Must Have

3.2 Business Rules

Requirement ID - Name Requirement Description Functional Requirement

RULE225481 – File Structure Validation

When validating the file structure the system must validate required columns, data types, and formatting rules.

▪ Validate Movable Asset File Structure

▪ Validate Fixed Asset File Structure http://cob-bprintp-01:8080/?ArtifactId=226569 http://cob-bprintp-01:8080/?ArtifactId=226738 http://cob-bprintp-01:8080/?ArtifactId=226739 http://cob-bprintp-01:8080/?ArtifactId=226740 http://cob-bprintp-01:8080/?ArtifactId=226741 http://cob-bprintp-01:8080/?ArtifactId=226737 http://cob-bprintp-01:8080/?ArtifactId=226573 http://cob-bprintp-01:8080/?ArtifactId=226572 http://cob-bprintp-01:8080/?ArtifactId=224983 http://cob-bprintp-01:8080/?ArtifactId=226576 http://cob-bprintp-01:8080/?ArtifactId=226582 http://cob-bprintp-01:8080/?ArtifactId=226583 http://cob-bprintp-01:8080/?ArtifactId=226579 http://cob-bprintp-01:8080/?ArtifactId=227601 http://cob-bprintp-01:8080/?ArtifactId=226742 http://cob-bprintp-01:8080/?ArtifactId=226578 http://cob-bprintp-01:8080/?ArtifactId=226730 http://cob-bprintp-01:8080/?ArtifactId=226581 http://cob-bprintp-01:8080/?ArtifactId=226743 http://cob-bprintp-01:8080/?ArtifactId=225481 http://cob-bprintp-01:8080/?ArtifactId=225439 http://cob-bprintp-01:8080/?ArtifactId=225439 http://cob-bprintp-01:8080/?ArtifactId=225432 http://cob-bprintp-01:8080/?ArtifactId=225432

RULE225486 – Record Upload

Only fully validated records that have been validated by the system and user may be saved.

▪ Save Moveable Asset Records

▪ Save Fixed Asset Records

▪ Save Fixed Asset Information

▪ Save Moveable Asset Information

RULE225445 – Fixed Asset Information Review

When requesting asset creation data, Capital Accounting will be responsible for reviewing submitted data.

▪ Request Fixed Asset

RULE225444 – Fixed Asset Information Ownership

Engineering and Construction must supply asset registry upon project closeout to IT Fixed Asset team.

▪ Request Fixed Asset

RULE225491 – Asset Identification Number Assignment

When assigning asset identification number, the system must assign a unique ID to each newly created asset automatically.

▪ Assign Fixed Asset Identification Number

▪ Save Fixed Asset Information

RULE225506 – Fixed Asset Depreciation

When providing fixed asset depreciation, the system must initiate depreciation based on the asset's substantial completion date.

▪ Provide Fixed Asset Depreciation

▪ Request Horizontal Pipe

RULE225531 – Project and Asset Relation

All fixed asset must be linked to a project and substantial completion date.

▪ Provide New Fixed Asset Information for Review

▪ Provide Fixed Asset

RULE225526 – Depreciation Method

Depreciation must follow the straight-line method.

▪ Request Asset Cost

Allocation

▪ Provide New Fixed Asset Information for Review

RULE225547 – Meter

Meter depreciation will began based on the year the meter was purchased.

▪ Request Meter Intake

RULE225549 – Viewing Asset Information

When providing asset information, the system must provide the information to all users.

▪ Provide Role Based Access

Docusign Envelope ID: 55C62D81-1526-476D-B022-C0D282D1452C http://cob-bprintp-01:8080/?ArtifactId=225486 http://cob-bprintp-01:8080/?ArtifactId=225440 http://cob-bprintp-01:8080/?ArtifactId=225440 http://cob-bprintp-01:8080/?ArtifactId=225433 http://cob-bprintp-01:8080/?ArtifactId=226562 http://cob-bprintp-01:8080/?ArtifactId=226562 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=225445 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225444 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225491 http://cob-bprintp-01:8080/?ArtifactId=225496 http://cob-bprintp-01:8080/?ArtifactId=225496 http://cob-bprintp-01:8080/?ArtifactId=226562 http://cob-bprintp-01:8080/?ArtifactId=226562 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=225506 http://cob-bprintp-01:8080/?ArtifactId=225511 http://cob-bprintp-01:8080/?ArtifactId=225511 http://cob-bprintp-01:8080/?ArtifactId=227450 http://cob-bprintp-01:8080/?ArtifactId=227450 http://cob-bprintp-01:8080/?ArtifactId=225531 http://cob-bprintp-01:8080/?ArtifactId=225501 http://cob-bprintp-01:8080/?ArtifactId=225501 http://cob-bprintp-01:8080/?ArtifactId=225511 http://cob-bprintp-01:8080/?ArtifactId=225511 http://cob-bprintp-01:8080/?ArtifactId=225526 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=225501 http://cob-bprintp-01:8080/?ArtifactId=225501 http://cob-bprintp-01:8080/?ArtifactId=225547 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=225549 http://cob-bprintp-01:8080/?ArtifactId=226757

▪ Provide Fixed Asset

Information

▪ Provide Movable Asset

RULE225552 – Asset Information Update

When requesting update decision, the system must only allow authorized users to update asset information.

▪ Request Update Fixed Asset Information Decision

▪ Request Update Movable Asset Information Decision

RULE225554 – Retire Fixed

When requesting retire decision, the system must only allow authorized users in Capital Staff to retire fixed asset.

▪ Request Retire Fixed

RULE225555 – Meter Information Frequency

When requesting meter information, the system must request the information monthly.

▪ Request Meter Disposal

Information

RULE226549 – Moveable Asset Information Creation

When requesting movable asset information, the system will only let authorized users to create new records after the asset is delivered.

▪ Request Create Movable

Asset Records

RULE226558 – Straight Line

When providing straight line depreciation, the system must start from the defined service date.

▪ Provide Straight Line

RULE226563 – Moveable Asset Identification

Moveable asset must have a useful life of more than one year and the unit cost must be greater than $10,000.

▪ Request Create Movable Asset Records

RULE226564 – Moveable Asset Tags

When requesting to create a moveable asset record, the asset tag must be assigned within five days of receipt.

RULE226565 – Moveable Asset Record Creation Trigger

When requesting to create a moveable asset record, an asset input form acts as the formal authorization to create a record.

RULE226570 – Audit History When tracking asset updates, the system must track what was updated, by who, and when.

▪ Track Moveable Asset Information Updates

▪ Track Fixed Asset Information Updates http://cob-bprintp-01:8080/?ArtifactId=225548 http://cob-bprintp-01:8080/?ArtifactId=225548 http://cob-bprintp-01:8080/?ArtifactId=226567 http://cob-bprintp-01:8080/?ArtifactId=226567 http://cob-bprintp-01:8080/?ArtifactId=225552 http://cob-bprintp-01:8080/?ArtifactId=225551 http://cob-bprintp-01:8080/?ArtifactId=225551 http://cob-bprintp-01:8080/?ArtifactId=226569 http://cob-bprintp-01:8080/?ArtifactId=226569 http://cob-bprintp-01:8080/?ArtifactId=225554 http://cob-bprintp-01:8080/?ArtifactId=225553 http://cob-bprintp-01:8080/?ArtifactId=225553 http://cob-bprintp-01:8080/?ArtifactId=225555 http://cob-bprintp-01:8080/?ArtifactId=225557 http://cob-bprintp-01:8080/?ArtifactId=225557 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=226549 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226558 http://cob-bprintp-01:8080/?ArtifactId=226557 http://cob-bprintp-01:8080/?ArtifactId=226557 http://cob-bprintp-01:8080/?ArtifactId=226563 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=226561 http://cob-bprintp-01:8080/?ArtifactId=226564 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226565 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226570 http://cob-bprintp-01:8080/?ArtifactId=226572 http://cob-bprintp-01:8080/?ArtifactId=226572 http://cob-bprintp-01:8080/?ArtifactId=226571 http://cob-bprintp-01:8080/?ArtifactId=226571

RULE226574 – Moveable Asset Disposal

When requesting moveable asset disposal information, the system must store a disposal date when the asset is marked disposed.

▪ Request Moveable Asset Disposal Information

RULE226584 – Ad Hoc Reporting Module

When providing ad hoc reports, the system must not require any developer assistance to generate common queries.

▪ Provide Ad-Hoc Report

RULE228723 – Allocation Use Project Costs from General Ledger

Asset cost allocations shall be performed using the actual accumulated project costs imported from Oracle General Ledger

▪ Request Asset Cost Allocation

RULE228724 – Allocation Basis for Asset Costs

The distribution of costs across assets shall be determined by each asset’s replacement cost percentage relative to the total replacement cost for the project.

▪ Request Asset Cost

RULE231865 – Movable Asset Data Review

Data extracted from the General Ledger and supporting backup documentation must be reviewed, validated, and edited prior to being copied into the custom spreadsheet template for upload.

▪ Request Movable Asset

RULE231867 – Review Movable Asset Information at Staging

When providing movable asset information in a staging area, only Dossier information must be provided to review at staging area.

▪ Provide Moveable Asset

Information for Review http://cob-bprintp-01:8080/?ArtifactId=226574 http://cob-bprintp-01:8080/?ArtifactId=226573 http://cob-bprintp-01:8080/?ArtifactId=226573 http://cob-bprintp-01:8080/?ArtifactId=226584 http://cob-bprintp-01:8080/?ArtifactId=226583 http://cob-bprintp-01:8080/?ArtifactId=228723 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=228724 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=225516 http://cob-bprintp-01:8080/?ArtifactId=231865 http://cob-bprintp-01:8080/?ArtifactId=231862 http://cob-bprintp-01:8080/?ArtifactId=231862 http://cob-bprintp-01:8080/?ArtifactId=231867 http://cob-bprintp-01:8080/?ArtifactId=226559 http://cob-bprintp-01:8080/?ArtifactId=226559

3.3 Data Requirements

DATA225435 – Fixed Asset Upload Fields

This requirement describes all the required fields for bulk upload of fixed asset data.

The fields are:

• AC150 ACCT NO.

• FUND

• ACCT NO.

• DATA SOURCE

• SUBSTANTIAL COMPLETION

DATE

• FINAL ACCEPTANCE DATE

• JOB DESCRIPTION

• FACILITY NAME

• SIZE

• COUNTY

• YEAR INTO SERVICE

• LIFE

• FEET

• COST

• LAPSE YEARS

• CURRENT DEPRECIATION

(AC150)

• ACCUMULATED DEPRECIATION

(AC150)

• NET BOOK VALUE (NBV)

• SUBSYSTEM

• PROCESS

• SUBPROCESS

• ASSET GROUP

• SOURCE ASSET ID

• ASSET NAME

• REPLACEMENT COST

• INSTALLED DATE

• ASSET STATUS

• CONSTRUCTION CONTRACT /

JOB NUMBER

• REPLACEMENT COST % TO

TOTAL

• ALLOCATED COST

▪ Request Historical Fixed Asset

Data

DATA225441 –

Moveable Asset Upload Fields

This requirement describes all the required fields for bulk upload of movable asset data.

The fields are:

• Asset ID

▪ Request Historical Movable Asset Data http://cob-bprintp-01:8080/?ArtifactId=225435 http://cob-bprintp-01:8080/?ArtifactId=225429 http://cob-bprintp-01:8080/?ArtifactId=225429 http://cob-bprintp-01:8080/?ArtifactId=225441 http://cob-bprintp-01:8080/?ArtifactId=225437 http://cob-bprintp-01:8080/?ArtifactId=225437

• Description

• PL Number

• Serial Number

• Manufacturer/Model

• Dossier/Fleet ID

• Org Number

• Asset Class

• Cost

• Useful Life

• Depreciation Start Date

• Depreciation Method (Straight-line)

• Accumulated Depreciation (if applicable)

DATA225545 – Meter Information Fields

This requirement describes all the fields for meter data information request.

The fields are:

• Txn Date

• Description

• Source Type

• Quantity

• Unit of measure

• Unit Cost

• Txn Value

• Warehouse

• Meter Size

▪ Provide Fixed Asset Information

DATA225546 – Fixed Asset Information Fields

This requirement describes all the fields for fixed asset information request.

The fields are:

• AC150 ACCT NO.

• FUND

• ACCT NO.

• DATA SOURCE

• SUBSTANTIAL COMPLETION

DATE

• FINAL ACCEPTANCE DATE

• JOB DESCRIPTION

• FACILITY NAME

• SIZE

• COUNTY

• YEAR INTO SERVICE

• LIFE

• FEET

• COST

• LAPSE YEARS

▪ Request Fixed Asset

▪ Provide Fixed Asset Information http://cob-bprintp-01:8080/?ArtifactId=225545 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=225541 http://cob-bprintp-01:8080/?ArtifactId=225548 http://cob-bprintp-01:8080/?ArtifactId=225546 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225443 http://cob-bprintp-01:8080/?ArtifactId=225548

• CURRENT DEPRECIATION

(AC150)

• ACCUMULATED DEPRECIATION

(AC150)

• NET BOOK VALUE (NBV)

• SUBSYSTEM

• PROCESS

• SUBPROCESS

• ASSET GROUP

• Reference Number

• Badge ID

• SOURCE ASSET ID

• ASSET NAME

• REPLACEMENT COST

• INSTALLED DATE

• ASSET STATUS

• CONSTRUCTION CONTRACT /

JOB NUMBER

• REPLACEMENT COST % TO

TOTAL

• ALLOCATED COST

DATA225556 – Meter

Fields

This requirement describes the meter disposal information fields.

The fields are:

• Account ID

• Start Date

• End Date

• Meter Size

• Removal Date

• Retired Date

▪ Request Meter Disposal

DATA226551 – Movable Asset Fields

This requirement describes the fields for movable assets and the custom spreadsheet template

The fields are:

• Asset Class

• Asset ID

• Asset Description

• Org Number (Section)

• Serial Number

• PL Number

• Manufacturer

• Model

• Vehicle Identification Number (VIN)

• Cost

• Useful Life

▪ Request Create Movable Asset Records

▪ Provide Movable Asset http://cob-bprintp-01:8080/?ArtifactId=225556 http://cob-bprintp-01:8080/?ArtifactId=225557 http://cob-bprintp-01:8080/?ArtifactId=225557 http://cob-bprintp-01:8080/?ArtifactId=226551 http://cob-bprintp-01:8080/?ArtifactId=226550 http://cob-bprintp-01:8080/?ArtifactId=226550

• First Month of Depreciation

• General Ledger Account

• Location

• Original Cost

• First Taken (Month and Year)

• Depreciable Life (Months)

• Dossier/Fleet ID (Only for Dossier

Data)

DATA226552 – Status Codes Information

This requirement describes the status codes for selection.

The codes are:

• AB - Abandoned

• CA - Cannibal

• IS - In Service

• MS - Missing

• SC - Scrapped

• SD - Sold

• ST - Stolen

• SU - Surplus

• TR - Traded

• TS - Threshold

• NP - Not Paid

• NF - Not Found

• N2 - Not Found (2)

▪ Provide Status Code for Selection

DATA226556 –

Moveable Asset Class Information

This requirement describes the moveable asset classes for selection.

The classes are:

• 00071 - Machinery & Equipment

• 00072 - Trucks

• 00073 - Office Furniture

• 00074 - Radios & Radio Equipment

• 00075 - Passenger Vehicles

• 00076 - Fleet Machinery/Equipment

• 00077 - Shop Tools & Misc

Equipment

• 00078 - Data Processing Software

• 00079 - Data Processing Equipment

• 00083 - Office Equipment

• 00087 - Laboratory Equipment

▪ Provide Asset Class for

DATA226577 – Seeded Reports Information

This requirement describes seeded reports for selection.

The reports are:

• Depreciation Projection Report

▪ Provide Seeded Reports for http://cob-bprintp-01:8080/?ArtifactId=226552 http://cob-bprintp-01:8080/?ArtifactId=226553 http://cob-bprintp-01:8080/?ArtifactId=226553 http://cob-bprintp-01:8080/?ArtifactId=226556 http://cob-bprintp-01:8080/?ArtifactId=226554 http://cob-bprintp-01:8080/?ArtifactId=226554 http://cob-bprintp-01:8080/?ArtifactId=226577 http://cob-bprintp-01:8080/?ArtifactId=226576 http://cob-bprintp-01:8080/?ArtifactId=226576

• Hypothetical What-if Report

• Hypothetical What-if Report

(Variable Format)

• Unplanned Depreciation Report

• What-if Depreciation Report

• What-if Depreciation Report

(Variable Format)

• Account Reconciliation Reserve

Ledger Report

• Accumulated Depreciation Balance

Report

• Asset Cost Balance Report

• CIP Cost Balance Report

• Cost and CIP Detail and Summary

Reports

• Cost Clearing Reconciliation Report

• Cost Clearing Reconciliation Report

(Variable Format)

• Group Asset Report (Variable

Format)

• Journal Entry Reserve Ledger

Report

• Production History Report

• Reserve Detail and Summary

Reports

• Reserve Ledger Report

• Revaluation Reserve Balance

Report

• Revaluation Reserve Detail and

Summary Reports

• Budget Report Budget-To-Actual

Report

• Capital Spending Report

• Capitalizations Report

• CIP Assets Report

• CIP Capitalization Report

• Fixed Assets Book Report

• Asset Description Listing

• Asset Inventory Report

• Asset Listing by Period

• Asset Register Report

• Reconciling Journal Entries to GL

• Reconciling Asset Cost Accounts

• Reconciling CIP Cost Accounts

• Reconciling Reserve Accounts

• Reconciling Depreciation Expense

Accounts

• Tracking and Reconciling Mass Additions

DATA226580 – Report Export File Types

This requirement describes the file types for report exports.

The file types are:

• Excel

• PDF

• CSV

▪ Request an Export Report

Decision

DATA226731 – Fixed Asset Fields for Update

This requirement describes the fields that can be updated for fixed assets.

The fields are:

• Asset Description

• Asset Account/Fund

• In-Service Date

• Useful Life

• Cost

• Accumulated Depreciation

• Depreciation Start Date

• Project Number

• Serial Number

• County / Location Code

• Abandonment Year

• Asset Classification / Category

(Approximately 300 + asset categories)

• GL Posting Adjustments

• Subsystem

• Process

• Subprocess

• Asset Group

• Source Asset ID

• Asset Name

▪ Request Update Fixed Asset Information Decision

DATA226758 – System Administrator Role

This requirement describes the roles of the system administrator.

The roles are:

• Define Asset Types

• Assign Default Useful Life Durations

• Perform Updates

• Perform Edits

• Retire Assets

• Assign Roles

▪ Provide Role Based Access http://cob-bprintp-01:8080/?ArtifactId=226580 http://cob-bprintp-01:8080/?ArtifactId=226581 http://cob-bprintp-01:8080/?ArtifactId=226581 http://cob-bprintp-01:8080/?ArtifactId=226731 http://cob-bprintp-01:8080/?ArtifactId=225551 http://cob-bprintp-01:8080/?ArtifactId=225551 http://cob-bprintp-01:8080/?ArtifactId=226758

DATA226760 – Movable Asset Fields for Update

This requirement describes the fields that can be updated for movable assets.

The fields are:

• Location

• Org Number (Section)

• Status

• Disposal Date

• Disposal Method

• Useful Life

• GL Account

• Project Number

• Depreciation Start Date

• Tag/Label Number

• Serial Number

▪ Request Update Moveble Asset Information Decision

DATA227461 –

Horizontal Pipe Asset Fields

This requirement describes the fields required for horizontal pipe asset records.

The fields are:

• Asset Account

• Pipe Size

• County Code (A, PG, M)

• In-Service Year

• Asset Life

• Abandonment Year

• Footage

• Original Cost

• Current Year Depreciation

• Accumulated Depreciation

• Substantial Completion Date

• Project Number

▪ Request Horizontal Pipe Cost

▪ Request Horizontal Pipe

DATA227626 – Pipe Study Report Fields

This requirement describes the fields in the pipe study report.

The fields are:

• Job Number

• Pipe Size

• Feet

• Cost

• CPF (Cost per Foot)

• Fund/Asset Account

• Utility Type

• Totals (by group)

▪ Request Generate Pipe Study

Report Decision http://cob-bprintp-01:8080/?ArtifactId=226760 http://cob-bprintp-01:8080/?ArtifactId=226569 http://cob-bprintp-01:8080/?ArtifactId=226569 http://cob-bprintp-01:8080/?ArtifactId=227461 http://cob-bprintp-01:8080/?ArtifactId=227456 http://cob-bprintp-01:8080/?ArtifactId=227456 http://cob-bprintp-01:8080/?ArtifactId=227450 http://cob-bprintp-01:8080/?ArtifactId=227450 http://cob-bprintp-01:8080/?ArtifactId=227626 http://cob-bprintp-01:8080/?ArtifactId=227601 http://cob-bprintp-01:8080/?ArtifactId=227601

4 Requirements Traceability Matrix

4.1 Functional Requirements / Data Requirements / Business Rules Functional Requirement ID - Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

FR225429 -

Request Historical Fixed Asset Data

The system shall request historical fixed asset data in an Excel template.

DATA225435-Fixed Asset Upload Fields

This requirement describes all the required fields for bulk upload of fixed asset data.

The fields are:

• AC150 ACCT

NO.

• FUND

• ACCT NO.

• DATA

SOURCE

• SUBSTANTIAL

COMPLETION

DATE

• FINAL

ACCEPTANCE

DATE

• JOB

DESCRIPTION

• FACILITY

NAME

• SIZE

• COUNTY

• YEAR INTO

SERVICE

Functional Requirement ID - Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• LIFE

• FEET

• COST

• LAPSE YEARS

• CURRENT

DEPRECIA

TION

(AC150)

• ACCUMULA

TED

DEPRECIA

TION

(AC150)

• NET BOOK

VALUE (NBV)

• SUBSYSTEM

• PROCESS

• SUBPROCESS

• ASSET

GROUP

• SOURCE

ASSET ID

• ASSET NAME

• REPLACEMEN

T COST

• INSTALLED

DATE

• ASSET

STATUS

• CONSTRUCTIO

N CONTRACT /

JOB NUMBER

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• REPLACEMEN

T COST % TO

TOTAL

• ALLOCATED

COST

FR225431 - Upload Fixed Asset Excel File

The system shall upload the completed fixed asset Excel file to a secure staging area.

FR225432 -

Validate Fixed Asset File Structure validate the structure of the fixed asset Excel file.

RULE225481-File Structure Validation

When validating the file structure the system must validate required columns, data types, and formatting rules.

FR225433 - Save Fixed Asset Records

The system shall save all validated fixed asset records.

RULE225486-Record Upload

Only fully validated records that have been validated by the system and user may be saved.

FR225437 -

Request Historical Movable Asset Data request historical movable asset data in an Excel template.

DATA225441-

Moveable Asset Upload Fields

This requirement describes all the required fields for bulk upload of movable asset data.

The fields are:

• Asset ID

• Description

• PL Number

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• Serial Number

• Manufacturer/M odel

• Dossier/Fleet

ID

• Org Number

• Asset Class

• Cost

• Useful Life

• Depreciation

Start Date

• Depreciation

Method (Straight-line)

• Accumulated Depreciation (if applicable)

FR225438 - Upload

Excel File

The system shall upload the completed movable asset Excel file to a secure staging area.

FR225439 -

Validate Movable Asset File Structure validate the structure of the movable asset Excel file.

RULE225481-File Structure Validation

When validating the file structure the system must validate required columns, data types, and formatting rules.

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

FR225440 - Save Moveable Asset all validated moveable asset records.

RULE225486-Record Upload

Only fully validated records that have been validated by the system and user may be saved.

FR226756 -

Provide Access provide access to the module using SSO.

FR226757 -

Provide Role Based Access provide role based access.

RULE225549-Viewing Asset Information

When providing asset information, the system must provide the information to all users.

DATA226758-

System Administrator Role

This requirement describes the roles of the system administrator.

The roles are:

• Define Asset Types

• Assign Default Useful Life Durations

• Perform Updates

• Perform Edits

• Retire Assets

• Assign Roles

FR225443 -

Request Fixed request fixed asset data from Engineering & Construction team.

RULE225445-Fixed Asset Information Review

When requesting asset creation data, Capital Accounting will be responsible for

DATA225546-Fixed Asset Information Fields

This requirement describes all the fields for fixed asset information request.

The fields are:

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description reviewing submitted data.

RULE225444-Fixed Asset Information Ownership

Engineering and Construction must supply asset registry upon project closeout to IT Fixed Asset team.

• AC150 ACCT

NO.

• FUND

• ACCT NO.

• DATA

SOURCE

• SUBSTANTIAL

COMPLETION

DATE

• FINAL

ACCEPTANCE

DATE

• JOB

DESCRIPTION

• FACILITY

NAME

• SIZE

• COUNTY

• YEAR INTO

SERVICE

• LIFE

• FEET

• COST

• LAPSE YEARS

• CURRENT

DEPRECIATIO

N (AC150)

• ACCUMULATE

D

DEPRECIATIO

N (AC150)

• NET BOOK

VALUE (NBV)

• SUBSYSTEM

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• PROCESS

• SUBPROCESS

• ASSET GROUP

• Reference

Number

• Badge ID

• SOURCE

ASSET ID

• ASSET NAME

• REPLACEMEN

T COST

• INSTALLED

DATE

• ASSET

STATUS

• CONSTRUCTIO

N CONTRACT /

JOB NUMBER

• REPLACEMEN

T COST % TO

TOTAL

FR225541 -

Request Meter Intake Information request meter intake information from the Oracle inventory system.

RULE225547-Meter Depreciation

Meter depreciation will began based on the year the meter was purchased.

RULE225555-Meter Information Frequency

When requesting meter information, the system must request the information monthly.

DATA225545-Meter

This requirement describes all the fields for meter data information request.

The fields are:

• Txn Date

• Description

• Source Type

• Quantity

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• Unit of measure

• Unit Cost

• Txn Value

FR227163 -

Provide Meter Intake Information

The Oracle inventory system shall provide meter intake information.

FR227450 -

Request Horizontal Pipe Information request horizontal pipe information from Capital Accounting.

RULE225506-Fixed Asset Depreciation

When providing fixed asset depreciation, the system must initiate depreciation based on the asset's substantial completion date.

DATA227461-

Horizontal Pipe Asset Fields

This requirement describes the fields required for horizontal pipe asset records.

The fields are:

• Asset Account

• Pipe Size

• County Code

(A, PG, M)

• In-Service Year

• Asset Life

• Abandonment

Year

• Footage

• Original Cost

• Current Year

Depreciation

• Accumulated

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• Substantial Completion Date

FR227456 -

Request Horizontal Pipe Cost request horizontal pipe cost information from the General Ledger.

DATA227461-

Horizontal Pipe Asset Fields

This requirement describes the fields required for horizontal pipe asset records.

The fields are:

• Asset Account

• Pipe Size

• County Code

(A, PG, M)

• In-Service Year

• Asset Life

• Abandonment

Year

• Footage

• Original Cost

• Current Year

Depreciation

• Accumulated

Depreciation

• Substantial

Completion Date

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

FR225496 - Assign Fixed Asset Identification

The system shall assign a fixed asset identification number.

RULE225491-Asset Identification Number Assignment

When assigning asset identification number, the system must assign a unique ID to each newly created asset automatically.

FR225501 -

Provide New Fixed for Review provide new fixed asset information for review prior to finalization.

RULE225531-Project and Asset Relation

All fixed asset must be linked to a project and substantial completion date.

RULE225526-

Depreciation Method

Depreciation must follow the straight-line method.

FR225511 -

Provide Fixed Asset Depreciation provide fixed asset depreciation expenses to the General Ledger System.

RULE225506-Fixed Asset Depreciation

When providing fixed asset depreciation, the system must initiate depreciation based on the asset's substantial completion date.

RULE225531-Project and Asset Relation

All fixed asset must be linked to a project and substantial completion date.

FR225516 -

Request Asset Cost Allocation request asset cost allocation from the General Ledger to each fixed asset based on predefined logic.

RULE225526-

Depreciation Method

Depreciation must follow the straight-line method.

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

RULE228723 –

Allocation Use Project Costs from General Ledger

Asset cost allocations shall be performed using the actual accumulated project costs imported from Oracle General Ledger

RULE228724 –

Allocation Basis for Asset Costs

The distribution of costs across assets shall be determined by each asset’s replacement cost percentage relative to the total replacement cost for the project.

FR227164 -

Provide Asset Cost

The General Ledger System shall provide asset costs to the Fixed Asset Module.

FR226586 -

Validate Fixed validate fixed asset

FR226588 -

Provide Failed Validation Notification provide a failed fixed asset information validation notification.

http://cob-bprintp-01:8080/?ArtifactId=228723 http://cob-bprintp-01:8080/?ArtifactId=228724

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

FR226587 -

Request Save Fixed Asset request a save fixed decision.

FR226562 - Save validated fixed asset information.

RULE225486-Record Upload

Only fully validated records that have been validated by the system and user may be saved.

RULE225491-Asset Identification Number Assignment

When assigning asset identification number, the system must assign a unique ID to each newly created asset automatically.

FR225550 -

Request Fixed request fixed asset identification

FR225548 -

Provide Fixed provide fixed asset information.

RULE225549-Viewing Asset Information

When providing asset information, the system must provide

DATA225545-Meter

This requirement describes all the fields for meter data information request.

The fields are:

• Txn Date

• Item No.

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• Description

• Source Type

• Quantity

• Unit of measure

• Unit Cost

• Txn Value

DATA225546-Fixed

Fields

This requirement describes all the fields for fixed asset information request.

The fields are:

• AC150 ACCT

NO.

• FUND

• ACCT NO.

• DATA

SOURCE

• SUBSTANTIAL

COMPLETION

DATE

• FINAL

ACCEPTANCE

DATE

• JOB

DESCRIPTION

• FACILITY

NAME

• SIZE

• COUNTY

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• YEAR INTO

SERVICE

• LIFE

• FEET

• COST

• LAPSE YEARS

• CURRENT

DEPRECIATIO

N (AC150)

• ACCUMULATE

D

DEPRECIATIO

N (AC150)

• NET BOOK

VALUE (NBV)

• SUBSYSTEM

• PROCESS

• SUBPROCESS

• ASSET GROUP

• Reference

Number

• Badge ID

• SOURCE

ASSET ID

• ASSET NAME

• REPLACEMEN

T COST

• INSTALLED

DATE

• ASSET

STATUS

• CONSTRUCTIO

N CONTRACT /

JOB NUMBER

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

• REPLACEMEN

T COST % TO

TOTAL

FR225551 -

Request Update Fixed Asset request an update fixed asset information decision.

RULE225552-Asset Information Update

When requesting update decision, the system must only allow authorized users to update asset

DATA226731-Fixed Asset Fields for Update

This requirement describes the fields that can be updated for fixed assets.

The fields are:

• Asset Description

• Asset Account/Fund

• In-Service Date

• Useful Life

• Cost

• Accumulated

Depreciation

• Depreciation

Start Date

• Project Number

• Serial Number

• County /

Location Code

• Abandonment

Year

• Asset

Classification / Category (Approximately

Name

Functional Requirement Description

Business Rule ID - Name

Business Rule Description

Data Requirement ID

- Name

Data Requirement Description

300 + asset categories)

• GL Posting Adjustments

• Subsystem

• Process

• Subprocess

• Asset Group

• Source Asset ID

• Asset Name

FR226589 -

Validate Updated validate the updated fixed asset information.

FR226593 -

Updated Fixed provide a failed updated fixed asset information notification.

FR226591 -

Update…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .