HPMS Assistant

HPMS Assistant provides tools specifically designed to address the Federal Highway Administration’s (FHWA’s) Highway Performance Monitoring System (HPMS) annual submittal process. HPMS Assistant is used to merge and validate data from existing road inventory databases and other operational systems based on DOT and FHWA validation rules.

Three of Transcend’s Productivity Tools are used in conjunction with HPMS Assistant and are accessible from HPMS Assistant’s interface:

  • Segment Analyzer – to dynamically segment business data into denormalized tables, one for Full Extent data and one for Sample Panel data.
  • Validation Assistant – to check data output from Segment Analyzer against DOT and FHWA rules and to step through and resolve problem records.
  • Report Engine – to generate the Full Extent and Sample Panel data files as well as certified mileage reports.

Map Data Fields to HPMS Items

HPMS-specific templates that map a transportation agency’s data to the data items included in the most current FHWA HPMS Field Manual.

Templates can be saved and used to run multiple iterations of data through the submittal process and can also be used as starting points for the process in subsequent years.

Monitor Your Progress with Workflow Indicators

As each step is completed, an associated indicator changes to green to denote its successful completion.

Validate Data & Correct Issues

Data is validated against established rules (HPMS validations are provided).

Corrections can be made in the source systems or within HPMS Assistant.

Run Reports & Generate Submittal Files

Network geodatabase and certified mileage reports are prepared along with the final April and June FHWA compliant submittal files.

Related summary files are created based on the current submittal data or from previous year’s summary data so they can be sent to FHWA.

Talk to a Rizing expert

Whether you're just getting started or are well on your way with SAP solutions, we can help.

Additional Information

Rizing Virtual Leadership Series: Ingredients of a Great Virtual Workplace
by Nicholas Yu published on Jun 09, 2020

In our next video in our mini-series on working successfully in the remote landscape, we will focus on how to create a great virtual workspace for your team! Join Rizing…

Read more

Build an Intelligent Data Foundation with /N SPRO at ASUG Roadshows
by Craig Powers published on May 23, 2019

We are hitting the road to show customers how to build a data-driven foundation for the Intelligent Enterprise and Digital Transformation. Join us!

Read more

SAP Analytics Cloud Use Case

In this whitepaper, we review one of the key differentiators of SAP Analytics Cloud: business intelligence extended by collaborative planning and predictive analytics in one integrated solution.

Read more