Performance analysis uses pavement management history information to provide a feedback mechanism to improve the predictive capabilities of pavement performance models. The primary repository for data used in performance analysis is the Performance Master.

The main difference between Performance Master and Network Master is that Performance Master has an EFF_YEAR column, and can be considered an archive or history of the Network Master’s data from each year.

Performance Master typically contains the exact same columns as Network Master, and typically follows the same data aggregation rules. Normally, each year after the Network Master is finalized, the user runs the process to update Performance Master, which will append Network Master’s data to Performance Master.

Out of the box, the Performance Master Data window can be navigated to by following the steps below:

  1. Select Analysis in the top banner menu
  2. Select Performance Analysis from the drop-down menu
  3. Click Performance Master 

The table is named PMSX_PERFORMANCE_MASTER. The columns in the table are almost the same as NETWORK_MASTER, with an addition of EFF_YEAR column.

The configuration for Performance Master is essentially the same as Network Master: 1) expanding the existing PMSX_PERFORMANCE_MASTER table to include the needed columns (typically same set of columns as Network Master); and 2) Update their Update Target Table SQLs so the data can be updated.

Out of the box, the system has provided a system job to update Performance Master once all the configuration is done. It includes both copying management sections into Performance Master (through Import) and Run Update Target Table on Performance Master. The system job is named Pavement Express: Create and Update Performance Master. Before running the job, make sure to specify which effective year (EFF_YEAR) the data is by updating the argument in the import PMX_PERFORMANCE_MASTER Import.

  • No labels