Best Practices for Structuring and Managing Statewide Resource-Tracking Databases
The Arizona Department of Transportation (ADOT) is working to modernize its financial tracking systems to improve transparency, compliance, and efficiency in managing federally funded transportation projects. Existing tools, including the Resource Administration database and related systems, operate independently, and require extensive manual data entry, limiting real-time financial coordination. This study evaluated federal requirements, reviewed ADOT’s current financial management processes, and examined practices from peer state departments of transportation. The research identified best practices in system integration, governance, and automation, and also developed a three-phase framework, covering preparation, procurement, and implementation to guide modernization. The recommendations provide ADOT with a practical roadmap for developing a unified, data-driven resource-tracking system that supports efficient decision-making and regulatory compliance.
- Record URL:
Language
- English
Project
- Status: Completed
- Funding: $75,000.00
-
Contract Numbers:
SPR-795
-
Sponsor Organizations:
Arizona Department of Transportation Research Center
206 S. 17th Avenue
ADOT Research Center
Phoenix, AZ United States 85007 -
Managing Organizations:
Arizona Department of Transportation Research Center
206 S. 17th Avenue
ADOT Research Center
Phoenix, AZ United States 85007 - Performing Organizations: Tucson, Arizona United States 85721
-
Principal Investigators:
Sullivan, Kenneth
- Start Date: 20241201
- Expected Completion Date: 20251231
- Actual Completion Date: 20260331
- USDOT Program: Federal Highway Administration
Subject/Index Terms
- TRT Terms: Automation; Best practices; Data management; Financing; Modernization
- Identifier Terms: Arizona Department of Transportation
- Subject Areas: Administration and Management; Data and Information Technology; Finance; Planning and Forecasting; Transportation (General);
Filing Info
- Accession Number: 02002943
- Record Type: Research project
- Source Agency: Arizona Department of Transportation
- Contract Numbers: SPR-795
- Files: RIP, STATEDOT
- Created Date: Sep 18 2026 1:15PM