Transportation Research Program Management Database

The purpose of the project is to modify the California Department of Transportation's (Caltrans) Research Program Management Database (RPMD) in FileMaker Pro to: 1) accommodate the system modifications needed for implementation by the Washington State Department of Transportation (WSDOT), 2) identify the needs and proposed modifications for participating states, and 3) enhance the RPMD to add new functions to meet additional research program management business needs of participating states, including management of the Transportation Pooled Fund (TPF) Module. Unique modifications identified in Study Objective 2 may be developed through this project through separate task agreements funded with additional targeted contributions. Regarding the use of other software, some states would like to use the data architecture of the RPMD as a foundation for a database in a different software product. Study Objective 2 provides an opportunity to investigate the feasibility of this conversion and to understand the technical requirements needed to make this conversion. Development of a module in a different software product will need to be funded through separate task agreements funded with additional targeted contributions. States with similar interests could partner in this effort. States needing the database in a different format may also choose to participate in development of the TPF module, in order to influence the design. Development of the module in software other than FileMaker Pro will require a separate task and funding.

• Record URL:
  http://www.pooledfund.org/Details/Study/407

Language

• English

Project

• Status: Completed
• Funding: $504000
• Contract Numbers:

  TPF-5(181)

• Sponsor Organizations:

  Alaska Department of Transportation and Public Facilities

  Research Development & Technology Transfer
  3132 Channel Dr
  Juneau, AK  United States 

  California Department of Transportation

  1227 O Street
  Sacramento, CA  United States  95814

  Indiana Department of Transportation

  Indiana Government Center North
  100 North Senate Avenue
  Indianapolis, IN  United States  46204-2249

  Michigan Department of Transportation

  Van Wagoner Building
  425 W. Ottawa Street
  Lansing, MI  United States  48909

  Nebraska Department of Transportation

  1500 Highway 2
  P.O. Box 94759
  Lincoln, NE  United States  68509-4759

  Washington State Department of Transportation

  Transportation Building
  Olympia, WA  United States  98504

  New York State Department of Transportation

  50 Wolf Road
  Albany, NY  United States  12232
• Project Managers:

  Oman, Leni

• Start Date: 20211014
• Expected Completion Date: 0
• Actual Completion Date: 0
• Source Data: RiP Project 29759

Subject/Index Terms

• TRT Terms: Databases; Research management; Software packages
• Identifier Terms: California Department of Transportation; Washington State Department of Transportation
• Uncontrolled Terms: Database design
• Subject Areas: Data and Information Technology; Highways; Research;

Filing Info

• Accession Number: 01465836
• Record Type: Research project
• Source Agency: Federal Highway Administration
• Contract Numbers: TPF-5(181)
• Files: RIP, USDOT, STATEDOT
• Created Date: Jan 3 2013 3:06PM