Fixed_Asset_Implementation_Requirement_Specification.pdf
PDF 373 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
Fixed Asset Implementation Requirement Specification Summary
This document is a comprehensive Fixed Asset Implementation Requirement Specification for the Washington Suburban Sanitary Commission (WSSC Water) in Maryland, detailing the technical requirements for migrating legacy AC150 (Capital Asset) and Movable Asset systems into the Oracle E-Business Suite (EBS) Fixed Assets Module. The project scope encompasses implementing eight primary use cases: accessing the Oracle EBS Fixed Asset Module via single sign-on (SSO) with role-based access control, migrating historical fixed asset and movable asset data from legacy systems via Excel file uploads, creating and managing fixed asset information including water meters and horizontal pipe assets, creating and managing movable asset information such as vehicles and equipment, viewing and updating both fixed and movable asset records, and generating comprehensive asset information reports. The specification defines three primary actors: Fixed Asset Information Creators (employees creating assets), Fixed Asset Information Viewers (employees with read access), and Fixed Asset Administrators (employees with full administrative privileges). The implementation requires integration with multiple existing WSSC systems including the Oracle General Ledger, Engineering and Construction asset registry, Work and Asset Management (WAM), Dossier (vehicle and equipment tracking), and Customer-to-Meter (C2M) systems for meter disposal data.
The specification establishes 44 functional requirements across migration, creation, maintenance, and reporting capabilities, supported by 16 business rules and 11 data requirements that collectively define system behavior and data structures. All 44 functional requirements are marked as "Must Have" priority, indicating critical implementation necessity. Key functional capabilities include automated asset identification number assignment, straight-line depreciation calculation based on substantial completion dates for fixed assets and purchase dates for meters, asset cost allocation based on replacement cost percentages relative to total project costs imported from the General Ledger, role-based access controls, audit history tracking for all asset updates, and comprehensive reporting functionality including 45 seeded reports, custom asset creation reports, ad hoc reporting with customizable fields, and pipe study reports. Fixed asset data fields encompass over 25 required elements including account numbers, facility information, depreciation details, location data, and project associations, while movable asset records require approximately 17 fields including asset classes, serial numbers, manufacturer information, depreciation start dates, and disposal tracking. The system must support multiple status codes for asset management (including In Service, Abandoned, Scrapped, and Surplus designations) and approximately 11 movable asset classes ranging from machinery and equipment to data processing software, with movable asset eligibility restricted to items with useful lives exceeding one year and unit costs greater than $10,000.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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.
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
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 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.
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
Requirement ID - Name Requirement Description Functional Requirement 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 Information
RULE225444 – Fixed Asset Information Ownership
Engineering and Construction must supply asset registry upon project closeout to IT Fixed Asset team.
� Request Fixed Asset Information
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
� Save Moveable 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 Information
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 Depreciation
RULE225526 – Depreciation Method
Depreciation must follow the straight-line method.
� Request Asset Cost Allocation
� Provide New Fixed Asset Information for Review
RULE225547 – Meter Depreciation
Meter depreciation will began based on the year the meter was purchased.
� Request Meter Intake Information
RULE225549 – Viewing Asset Information
When providing asset information, the system must provide the information to all users.
� Provide Role Based Access
� Provide Fixed Asset
Information � Provide Movable Asset
Information
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 Asset Information
When requesting retire decision, the system must only allow authorized users in Capital Staff to retire fixed asset.
� Request Retire Fixed Asset Information
RULE225555 – Meter Information Frequency
When requesting meter information, the system must request the information monthly.
� Request Meter Disposal Information
� Request Meter Intake 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 Depreciation
When providing straight line depreciation, the system must start from the defined service date.
� Provide Straight Line Depreciation
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
� Save Moveable Asset Information
RULE226564 – Moveable Asset Tags
When requesting to create a moveable asset record, the asset tag must be assigned within five days of receipt.
� Request Create Movable Asset Records
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.
� Request Create Movable Asset Records
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
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 Allocation
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 Information
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
3.3 Data Requirements
Requirement ID - Name Requirement Description Functional Requirement 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
• 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
� Request Meter Intake Information
� 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 Information
� Provide Fixed Asset Information
• 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 Disposal Information 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 Information
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 Information
• 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 Selection
DATA226577 – Seeded Reports Information
This requirement describes seeded reports for selection.
The reports are:
• Depreciation Projection Report
� Provide Seeded Reports for Selection
• 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
• 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
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 Information
� Request Horizontal Pipe Information
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
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
Requirement ID - 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
The system shall 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
The system shall 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
Requirement ID - 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 Movable Asset Excel File
The system shall upload the completed movable asset Excel file to a secure staging area.
FR225439 -
Validate Movable Asset File Structure
The system shall 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.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR225440 - Save Moveable Asset Records
The system shall save 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
The system shall provide access to the module using SSO.
FR226757 -
Provide Role Based Access
The system shall 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 Asset Information
The system shall 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:
Requirement ID - 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
Requirement ID - 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
• ALLOCATED
COST
FR225541 -
Request Meter Intake Information
The system shall 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 Information Fields
This requirement describes all the fields for meter data information request.
The fields are:
• Txn Date
• Description
• Source Type
• Quantity
Requirement ID - 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
• Warehouse
• Meter Size
FR227163 -
Provide Meter Intake Information
The Oracle inventory system shall provide meter intake information.
FR227450 -
Request Horizontal Pipe Information
The system shall 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
Depreciation
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
• Substantial Completion Date
• Project Number
FR227456 -
Request Horizontal Pipe Cost Information
The system shall 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
• Project Number
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR225496 - Assign Fixed Asset Identification Number
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 Asset Information for Review
The system shall 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
The system shall 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
The system shall 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.
Requirement ID - 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 Allocation
The General Ledger System shall provide asset costs to the Fixed Asset Module.
FR226586 -
Validate Fixed Asset Information
The system shall validate fixed asset information.
FR226588 -
Provide Failed Validation Notification
The system shall provide a failed fixed asset information validation notification.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR226587 -
Request Save Fixed Asset Information Decision
The system shall request a save fixed asset information decision.
FR226562 - Save Fixed Asset Information
The system shall 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 Asset Identification Information
The system shall request fixed asset identification information.
FR225548 -
Provide Fixed Asset Information
The system shall provide fixed asset information.
RULE225549-Viewing Asset Information
When providing asset information, the system must provide the information to all users.
DATA225545-Meter Information Fields
This requirement describes all the fields for meter data information request.
The fields are:
• Txn Date
• Item No.
Requirement ID - 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
• Warehouse
• Meter Size
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
Requirement ID - 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
Requirement ID - 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
FR225551 -
Request Update Fixed Asset Information Decision
The system shall 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 information.
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
Requirement ID - 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 Fixed Asset Information
The system shall validate the updated fixed asset information.
FR226593 -
Provide Failed Updated Fixed Asset Information Notification
The system shall provide a failed updated fixed asset information notification.
FR226591 -
Update Fixed Asset Information
The system shall update the fixed asset information.
FR226590 -
Request Save Updated Fixed Asset Information Decision
The system shall request a save updated fixed asset information decision.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR226592 - Save Updated Fixed Asset Information
The system shall save the updated fixed asset information.
FR225553 -
Request Retire Fixed Asset Information
The system shall request retire fixed asset information decision.
RULE225554-Retire Fixed Asset Information
When requesting retire decision, the system must only allow authorized users in Capital Staff to retire fixed asset.
FR225557 -
Request Meter Disposal Information
The system shall request meter disposal information from the C2M system.
RULE225555-Meter Information Frequency
When requesting meter information, the system must request the information monthly.
DATA225556-Meter Disposal Information Fields
This requirement describes the meter disposal information fields.
The fields are:
• Account ID
• Start Date
• End Date
• Meter Size
• Removal Date
• Retired Date
FR225558 -
Request Enhancement to Fixed Asset Link
The system shall request to link enhancements to original assets and track changes to depreciation.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR225559 -
Provide Interface with General Ledger
The system shall provide an interface with the General Ledger to reflect updates to asset values and depreciation amounts.
FR225560 -
Enforce Role- Based Access Control
The system shall enforce role-based access control.
FR226571 - Track Fixed Asset Information Updates
The system shall track fixed asset information updates for audit history.
RULE226570-Audit History
When tracking asset updates, the system must track what was updated, by who, and when.
FR226550 -
Request Create Movable Asset Records
The system shall request to create movable asset records.
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.
RULE226564-Moveable Asset Tags
When requesting to create a moveable asset record, the asset tag must be assigned within five days of receipt.
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
• Manufacturer
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
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.
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.
• Model
• Vehicle
Identification Number (VIN)
• Cost
• Useful Life
• 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)
FR226554 -
Provide Asset Class for Selection
The system shall provide asset class for selection.
DATA226556-
Moveable Asset Class Information
This requirement describes the movable asset classes for selection.
The classes are:
• 00071 -
Machinery & Equipment
• 00072 - Trucks
• 00073 - Office
Furniture
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
• 00074 - Radios & Radio Equipment
• 00075 - Passenger Vehicles
• 00076 - Fleet Machinery/Equi pment
• 00077 - Shop Tools & Misc Equipment
• 00078 - Data Processing Software
• 00079 - Data Processing Equipment
• 00083 - Office Equipment
• 00087 - Laboratory Equipment
FR226555 -
Provide Organization Numbers for Selection
The system shall provide organization numbers for selection.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR226553 -
Provide Status Code for Selection
The system shall provide status code for selection.
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)
FR226557 -
Provide Straight Line Depreciation
The system shall provide straight line depreciation.
RULE226558-Straight Line Depreciation
When providing straight line depreciation, the system must start from the defined service date.
FR231863 –
Request Moveable Asset Data
The system shall request moveable asset data in a standardized format (may be spreadsheet).
DATA226551-
Movable Asset Fields
This requirement describes the fields for movable assets and the custom spreadsheet template.
The fields are:
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
• Asset Class
• Asset ID
• Asset
Description
• Org Number
(Section)
• Serial Number
• PL Number
• Manufacturer
• Model
• Vehicle
Identification Number (VIN)
• Cost
• Useful Life
• 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)
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR231862 –
Upload Moveable Asset Data
The system shall upload moveable asset data using a standardized format (may be spreadsheet-based).
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.
FR231869 -
Request Movable Asset Information from Dossier
The system shall request movable asset (vehicles and large equipment) information from the Dossier system.
FR231868 -
Provide Movable Asset Information
The Dossier system shall provide moveable asset information (vehicles and large equipment) through interface.
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
• Manufacturer
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
• Model
• Vehicle
Identification Number (VIN)
• Cost
• Useful Life
• 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)
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.
FR226734 -
Validate Movable Asset Information
The system shall validate movable asset information.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR226732 -
Provide Movable Validation Failed Notification
The system shall provide a failed movable asset information validation notification.
FR226733 -
Request Save Movable Asset Information Decision
The system shall request a save movable asset information decision.
FR226561 - Save Moveable Asset Information
The system shall save validated moveable 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.
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.
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR226568 -
Request Movable Asset Identification Information
The system shall request movable asset identification information.
FR226567 -
Provide Movable Asset Information
The system shall provide movable asset information.
RULE225549-Viewing Asset Information
When providing asset information, the system must provide the information to all users.
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
• First Month of
Depreciation
• General Ledger
Account
• Location
• Original Cost
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
• First Taken (Month and Year)
• Depreciable Life (Months)
• Dossier/Fleet ID (Only for Dossier Data)
FR226569 -
Request Update Moveble Asset Information Decision
The system shall request an update movable asset information decision.
RULE225552-Asset Information Update
When requesting update decision, the system must only allow authorized users to update asset information.
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
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
FR226738 -
Validate Updated Movable Asset Information
The system shall validate the updated movable asset information.
FR226739 -
Provide Failed Updated Movable Asset Information Notification
The system shall provide a failed updated movable asset information notification.
FR226740 -
Update Movable Asset Information
The system shall update the movable asset information.
FR226741 -
Request Save Updated movable Asset Information Decision
The system shall request a save updated movable asset information decision.
FR226737 - Save Updated Movable Asset Information
The system shall save the updated movable asset information.
FR226573 -
Request Moveable Asset Disposal Information
The system shall request moveable asset disposal information.
RULE226574-Moveable Asset Disposal
When requesting moveable asset disposal information, the system must store a disposal date
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description when the asset is marked disposed.
FR226572 - Track Moveable Asset Information Updates
The system shall track moveable asset information updates for audit history.
RULE226570-Audit History
When tracking asset updates, the system must track what was updated, by who, and when.
FR226576 -
Provide Seeded Reports for Selection
The system shall provide seeded reports for selection.
DATA226577-
Seeded Reports Information
This requirement describes seeded reports for selection.
The reports are:
• Depreciation
Projection Report
• Hypothetical What-if Report
• Hypothetical What-if Report (Variable Format)
• Unplanned Depreciation Report
• What-if Depreciation Report
• What-if Depreciation
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
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
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement Description
• 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
Requirement ID - Name
Functional Requirement Description
Business Rule ID - Name
Business Rule Description
Data Requirement ID
- Name
Data Requirement…
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 .