Best Practices for Structuring and Managing Statewide Resource-Tracking Databases

Sullivan, Kenneth T.; Hurtado, Kristen

i

Best Practices for Structuring and Managing Statewide Resource-Tracking Databases

2025-10-01
By Sullivan, Kenneth T. ; Hurtado, Kristen

File Language:

English

Details

Creators:

Sullivan, Kenneth T. ; Hurtado, Kristen
Corporate Creators:

Arizona State University
Corporate Contributors:

Arizona. Department of Transportation ; United States. Department of Transportation. Federal Highway Administration
Subject/TRT Terms:

Automatic Tracking Automation Best Practices Compliance Databases Data Integration Data Management Federal Aid Federal Funds Management Finance Financial Management Systems Government Funding Management Procurement Real Time Control Reports Resource-tracking Databases State Departments Of Transportation System Modernization
Publication/ Report Number:

SPR-795
Resource Type:

Tech Report
Geographical Coverage:

United States ; Arizona
Edition:

Final Report
Corporate Publisher:

Arizona. Department of Transportation
Abstract:

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.
Format:

PDF
Collection(s):

US Transportation Collection
Main Document Checksum:

urn:sha-512:afbda72e49d86dbc13d0756759941c19e9b5ea8822a81dab0ec90b24d026baa4820bbfd3f8ff510462672e1ee35c71b25e9004a16b17a33d6ddce2efdd1739b5
Download URL:

https://rosap.ntl.bts.gov/view/dot/89172/dot_89172_DS1.pdf
File Type:

[PDF - 1.88 MB ]

File Language:

English

ON THIS PAGE

Details

ROSA P serves as an archival repository of USDOT-published products including scientific findings, journal articles, guidelines, recommendations, or other information authored or co-authored by USDOT or funded partners. As a repository, ROSA P retains documents in their original published format to ensure public access to scientific information.