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

Commoditized or Competitive Advantage? How to make your company’s “secret sauce” with your SAP investments
by Steve Bronson published on Aug 25, 2020

In debating SAP customization vs. standardization, companies focus on unique technical requirements. But uniqueness comes from more than just technology.

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

Integrate and Accelerate for Promotional Success

With Fiori becoming the primary user Interface for SAP S/4HANA implementations, SAP Gateway is more important than ever, here we look at the steps needed to call SAP Gateway services…

Read more