Skip to contentU.S. Department of Transportation/Federal Highway Administration
Asset Management | Bridge Technology | Operations | Pavement

Pavement Health Track Graphical User Interface, User's Manual 2.x

PHT Application Window

SETTINGS

The first tab, shown in Figure 8, is the Settings tab, which provides the user interface for working with highway data, GIS selections, and PHT analysis parameters and for running the PHT analysis. A hierarchical tree displays and organizes these items and a toolbar and various RIGHT-click popup menus are provided to work with them.

A screen shot shows options under the Settings tab of the PHT analysis tool. It serves to access functions to read, create, open, copy, delete, or refresh data or GIS selection, as well as run a PHT analysis.
Figure 8. PHT Analysis Tool - Model Settings

The toolbar at the top of the window provides for the following functions:

icon Read HPMS Data Read HPMS Data. Open an HPMS 2010 formatted comma-delimited text file and read its contents into a PHT database.
icon Read Non-HPMS Data Read Non-HPMS Data. Connect to a Microsoft® Access, dBase, comma-delimited file, or other ODBC (open database connectivity) data source and import its contents into a PHT database using the import wizard.
icon Create a new GIS Selection Create a new GIS Selection. Create a new GIS selection based on an existing GIS shape file.
icon Create a new set of Parameter Metrics Create a new set of Parameter Metrics. Create a new set of parameter metrics that is used to control the PHT analysis.
icon Open Open. Open the item currently selected in the tree.
icon Copy Copy. Create a copy of the item currently selected in the tree.
icon Delete Delete. Delete the item currently selected in the tree.
icon Refresh Refresh. Refresh the display.
icon Run PHT Analysis Run PHT Analysis. Display the PHT run dialog window to initiate the PHT analysis process.

In addition to the functions provided by the toolbar, individual items in the tree structure have unique operations that can be performed. Access to these functions is provided by the popup menu that appears when you RIGHT-click on a specific item in the tree structure. The popup menu for each item type is shown in Figure 9.

A screen shot shows settings under the popup menu associated with PHT Databases. A screen shot shows settings under the popup menu associated with GIS Selections. A screen shot shows settings under the popup menu associated with Analysis Parameters.
Figure 9. PHT Settings - RIGHT-Click Popup Menus

The items in the popup menus provide the following functions:

icon Open Open. Open the item currently selected in the tree.
icon Copy Copy. Create a copy of the item currently selected in the tree.

Export. Export the contents of the currently selected PHT database to an external comma-delimited file in the HPMS 2010 format.
icon Delete Delete. Delete the item currently selected in the tree.

Rename. Rename the currently selected item.
icon Select from GIS Selection Select from GIS Selection. Select highway sections to be evaluated by the PHT analysis using an existing GIS selection.
icon Properties Properties. Display the properties dialog of a GIS selection.
icon Compile Corridor Compile Corridor. Evaluate the highway sections that make up a GIS selection and determine if they form a continuous corridor.

Reverse. Reverse the direction of a corridor.
icon Save as Default Parameters Save as Default Parameters. Save the currently selected set of parameter metrics as the default values to be automatically applied to new sets of parameters.

Restore National Defaults. Restore the original national default values to the currently selected set of parameter metrics.
PHT RESULTS

The second tab in the PHT analysis window, shown in Figure 10, is the PHT Results tab, which provides the user interface for working with results data for the PHT analysis and allows you to generate automated reports. A hierarchical tree displays and organizes each set of results, and a toolbar and RIGHT-click popup menus are provided to work with them.

A screen shot shows options under the PHT Results tab of the PHT analysis tool. It also displays a hierarchical tree that organizes results.
Figure 10. PHT Analysis Tool - PHT Results

The toolbar at the top of the window provides for the following functions:

icon Open Open. Open the item currently selected in the tree.
icon Delete Delete. Delete the currently selected set of PHT results.
icon Refresh Refresh. Refresh the display.
icon Generate Report Generate Report. Display the PHT report wizard dialog window to automatically generate a report based on a selected set of PHT results and a report template.

In addition to the functions provided by the toolbar, individual items also provide a popup menu that appears when you RIGHT-click on a specific item in the tree structure. The menu for each item type is shown in Figure 11.

A set of screen shots shows settings under the popup menu associated with the PHT Result Root and Database/Analysis Parameters.
Figure 11. PHT Results - RIGHT-Click Popup Menus

The items in the popup menus provide the following functions:

icon Open Open. Open the item currently selected in the tree.
icon Delete Delete. Delete the item currently selected in the tree.

Rename. Rename the currently selected item.
CORRIDOR ANALYSIS

The third tab in the PHT analysis window, shown in Figure 12, is the Corridor Analysis tab, which provides the user interface for evaluating the PHT results for any given corridor. The top pane displays a list of existing corridor profiles for you to select from, while the bottom pane displays the options for the selected corridor profile. You must select a set of PHT analysis results, a GIS selection that represents the continuous corridor, and up to four data items to profile.

Once you have selected the profile options, click the Display icon Display button in the toolbar to view the corridor profile as shown in Figure 13. If you make any changes to the options for the profile, you must then click the Display button again to refresh the display window.

A screen shot shows options under the Corridor Analysis tab of the PHT analysis tool. The toolbar serves to access functions to create, delete, refresh, and display profile analysis.
Figure 12. PHT Analysis Tool - Corridor Analysis

The toolbar at the top of the window provides for the following functions:

icon Create New Create New. Create a new profile analysis.
icon Delete Delete. Delete the currently selected profile analysis.
icon Refresh Refresh. Refresh the display.
icon Display Display. Display the results of the currently selected profile. After making any changes, click this button to refresh the display of the corridor profile.
A screen shot shows a set of histograms coded to indicate the type of pavement in highway sections that make up a corridor. The types include rigid, flexible, and composite. To the right of the histograms the display shows a GIS map of the corridor. The toolbar serves to access functions to print, stack charts, tab charts, synchronize the Y axis, zoom, copy the GIS map, and zoom and pan on the map.
Figure 13. Corridor Profile Display

The corridor profile identifies the pavement type of each highway section as a color code depicting rigid, flexible, and composite pavements for those regions of the corridor that have sample PHT data. Regions without sample data appear gray. Corridors are characterized by virtual mileposts beginning at zero and incrementing based on the lengths of the highway sections that make up the corridor.

A GIS map of the corridor is displayed with color highlighting identical to the profile charts. The GIS map window will initially appear at the right or bottom of the window depending on the general orientation of the highlighted route, and you can resize and move the window as desired.

The toolbars provide for the following functions:

icon Print Print. Display the print dialog to print the charts to a file, printer, or clipboard.
icon Stack Charts Stack Charts. Display the chart windows stacked vertically.
icon Tab Charts Tab Charts. Display each chart as an individual tabbed window.
icon Synchronize Y Axis Synchronize Y Axis. Synchronize the Y Axis of all the charts to a single scale.
icon Zoom Zoom. Activate chart zooming.
icon Copy Copy. Copy the GIS map image to the clipboard.
icon Zoom +, icon Zoom -, icon Zoom Large, icon Zoom Small, icon Pan Zoom and Pan. Zoom in or out, and pan through the GIS map.
ZOOM

To zoom into an area of the corridor, click the Zoom icon Zoom button on the toolbar. The zoom control will appear at the bottom of the window. Drag the beginning and ending markers left or right to adjust the zoom region. The GIS map will automatically track with the zoom region of the corridor and will highlight only those highway sections that appear in the profile charts. Click the zoom button on the toolbar again to remove all zooming from the charts and restore the profile to its original scale.

SYNCHRONIZE Y-AXIS

The synchronize Y-axis button will cause all of the charts in the display to use the same scale for their vertical axis. This can be useful when comparing similar data on multiple charts.

MAINTENANCE DATA FIELDS

The data fields for the maintenance analysis can be profiled also. Before the maintenance analysis results can be profiled you must first open the PHT analysis result window from the Results tab and apply a maintenance analysis to the PHT result data. The maintenance analysis results are not persisted or saved when the PHT result window is closed, so this window must remain open with a maintenance analysis applied for the maintenance analysis results to be available to be profiled.

When you select a set of PHT analysis results that has had a maintenance analysis applied, the additional results fields for the maintenance analysis will be appended to the list of data fields available for profiling, as shown in Figure 14. Simply select the maintenance data field(s) of interest as you would any other data field and click the Display button to display the profile chart.

A screen shot shows selectable data fields associated with the Corridor Analysis tab of the PHT analysis tool.
Figure 14. Corridor Analysis with Maintenance Fields

PHT Properties

The PHT properties window is displayed by clicking the PHTv2/Properties menu item in the application main menu. The PHT properties window has six tabs as follows.

PHT DATABASE

The PHT Database tab (shown in Figure 15) allows you to specify the database file used by the PHT analysis tool to store local information unique to the PHT tool. The user name and password requirements are not implemented at this time. The location of the PHT database file is set up during installation and will generally not need to be modified.

A screen shot shows the window associated with the PHT Database tab associated with the PHT Properties menu item of the PHT Analysis Tool, where the database file is listed. Options for logon and to test the connection are also available.
Figure 15. PHT Properties - PHT Database
COEFFICIENT VALUES

The PHT coefficient values tab (shown in Figure 16) are used by the analytical models employed by the analysis engine and are not editable without authorization.

A screen shot shows the window associated with the Coefficient Values tab associated with the PHT Properties menu item of the PHT Analysis Tool, where information on distress type as well as coefficients and their values are listed.
Figure 16. PHT Properties - Coefficient Values

The coefficient values apply to the model equations defined in the Pavement Health Track RSL Forecasting Models Technical Information document, version 2.x, March 2013. A cross-reference between the coefficient values and the analysis model equations is provided in Table 3.

Table 3. Coefficient Reference Equations
Distress Type Coefficients Reference Equations (Technical Information Document)
HMA IRI C0 - C3 Equation 31
HMA Rutting C0 - C3 Equations 25, 26, 27, 28
HMA Cracking Percent C0 - C1 Equation 24
HMA Cracking Length C0 - C5 Equation 29
PCC IRI C0 - C3 Equation 8
PCC Faulting C0 - C7 Equations 6, 7
PCC Spalling NA  
PCC Cracking Percent C0 - C9 Equations 4, 5
Composite IRI C0 Equation 34
Composite Cracking Length C0 - C2 Equation 33
NTAD DATA

The National Transportation Atlas Database (NTAD) data tab, shown in Figure 17, provides background images for the GIS maps used by the GIS selections. The NTAD backgrounds are useful to provide you with additional references when viewing the GIS maps but are otherwise optional. You can select which backgrounds that you would like to appear in the GIS maps.

A screen shot shows the window associated with the NTAD Data tab associated with the PHT Properties menu item of the PHT Analysis Tool, where the root directory is shown and options are provided for enabling certain NTAD map backgrounds.
Figure 17. PHT Properties - NTAD Data
VALIDATION RULES

The validation rules tab, shown in Figure 18, is used to selectively enable individual highway data validation rules that are applied to the input PHT database. Each validation rule is displayed along with a checkbox to enable or disable it. If a rule is checked, it is enabled and will be enforced. The validation rules are defined in detail in Appendix A.

A screen shot shows the window associated with the Validation Rules tab associated with the PHT Properties menu item of the PHT Analysis Tool, where the user can select specific validation rules to be applied to the input PHT database.
Figure 18. PHT Properties - Validation Rules
TEMPLATE LIBRARY

The template library tab shown in Figure 19 provides management of the template library. The templates provide the format for predefined charts used to generate reports. Once a template is selected from the list, it can be deleted or exported to an XML file. In XML form, the template file can be shared with other PHT users who can import it into their own template library.

A screen shot shows the window associated with the Template Library tab associated with the PHT Properties menu item of the PHT Analysis Tool, where the user can select report templates with selectable chart inputs to generate reports.
Figure 19. PHT Properties - Template Library

You can easily create chart templates by first using the Report Wizard to produce a chart report, and then modifying the report to meet your unique needs. You can save the report as a template to the library as described in section discussing the PHT Report Wizard.

LOGGING

The analysis logging tab shown in Figure 20 is used to enable the PHT analysis logging capability and to specify the level of logging to be captured. The PHT analysis log can be used to track the analysis process to aid in understanding the results. When an analysis log has been captured, the logging for the analysis for each individual highway section is available on the Log tab of the PHT results window; however, logging can significantly increase the analysis runtime and should be disabled when the log is not of interest.

A screen shot shows the window associated with the Logging tab associated with the PHT Properties menu item of the PHT Analysis Tool, where the user can select specific logs to be incorporated in the PHT Analysis log.
Figure 20. PHT Properties - Logging

PHT Database Window

The PHT database window is displayed by selecting a database on the Settings tab of the PHT analysis window and clicking the Open button on the toolbar.

The PHT database is the source data for the RSL analysis. It contains the data fields that describe the condition of each highway section. Each record in the database represents a highway section. The PHT database is displayed in the data table window shown in Figure 21.

A screen shot shows the window associated with the Settings tab associated with the PHT analysis window, where the user views the records that reside in the PHT database. On the left the user can examine the data entries for a given record. On the right the user can view the data table row by row. A column to the right of the row of records allows the user to select or deselect any given row.
Figure 21. PHT Database Window

This window provides layout formatting, editing, and validation testing through popup menus. The menus are activated by RIGHT-clicking on individual records or on the column headers. Each menu is described in the following paragraphs.

A vertical oriented panel is available that displays the data items of the selected highway section in a convent format that allows all of the data items to be seen at once. The vertical panel is located on the left of the window and can be expanded by dragging the slider bar to the right.

When validation testing has been performed, individual highway sections that have violated one or more validation tests are highlighted with a red shaded background. When one of these errant records is selected, a list of its validation errors is displayed in the panel at the bottom of the window. DOUBLE-clicking on an error message entry will cause the application to jump focus to the specific record and data item that has caused the error. Individual validation rules can be enabled or disabled from the PHT properties window.

The error message panel for the validation rules normally displays the validation errors for the selected highway section; however it can also show all the validation errors of the entire dataset or a list of each unique error message in that dataset. To change how the validation errors are displayed, RIGHT-click on the panel to display its popup menu and select an option under the View menu item.

SELECTION MENU

The first column in the table (Select) determines if a highway section will be included in the PHT analysis. If this field is checked, the record will be analyzed by the PHT tool when the analysis is run; otherwise the record will be ignored. To select or unselect a highway section, you can manually click on its checkbox or use the selection commands available from the menu shown in Figure 22. This popup menu is activated by RIGHT-clicking on the Select column header.

A screen shot shows the window associated with the Select column of the database window, where the user has options for manipulating the records.

Select All. Select all highway sections.

Select Range. Select the highway sections in the highlighted range, and unselect all others.

Clear Selection. Unselect all highway sections.

Toggle Selection. Toggle the selection state of all highway sections.

Select Valid Records. Select only highway sections that do not have validation errors.

Select Errant Records. Select only highway sections that have violated one or more validation tests.

Select by Query. Display a query wizard to select highway sections based on their attributes.

Figure 22. Selection Popup Menu

When selecting highway sections by Query, the query builder shown in Figure 23 is displayed. On the Filter Wizard tab, select the data fields you want to use as the selection criteria and then click the Apply button to select the records that meet the criteria. To add to the current selection rather than replace it, check the option to append the selection results at the bottom of the window.

Users that are comfortable working directly with the SQL language may enter the SQL text using the SQL text window. The SQL text represents the WHERE clause of a SQL statement and must comply with all SQL syntax rules. This window provides a list of available data fields, operators, built-in functions, and a list of unique values for the selected field.

A screen shot shows the window associated with the query builder of the database window, where the user can select data fields to build a query. A screen shot shows the window associated with the query builder of the database window, where the user can enter a query directly using the SQL text window.
Figure 23. Selection Query Builder
COLUMN MENU

The column for each data item provides a popup menu, shown in Figure 24, that appears when you RIGHT-click on the column header. Items in this menu apply only to the column that was clicked.

A screen shot shows the window associated with a given data column, where the user has options for manipulating the data.

Fill Data. Display a dialog window that allows you to fill the selected column with a new value, overwriting all previously existing values in the column.

Search and Replace. Display a dialog window that allows search the selected column for a particular value and replace it with a new value.

Sort. Sort the selected column in ascending or descending order, or remove any applied sorting.

Hide. Hide the selected column.

Show. List hidden columns so that individual columns can be re-shown.

Show All. Show all hidden columns.

Figure 24. Column Popup Menu

A screen shot shows the window associated with manipulating the set of data in a given column, where the user can apply search and replace operations or overwrite values.

The Search and Replace window (Figure 23) allows you to search a column of data for a particular value and replace it with a new value. The search operation can apply to a selected range or to the entire column.

A screen shot shows the window associated with manipulating a selected range, the set from active selection point to end of column, or the entire column.

The Fill Data window (Figure 23) allows you to fill a column of data with a new value overwriting all previously existing values in the column. The fill operation can apply to a selected range, from the current record to the end of the table, or the entire column.

Figure 25. Mass Edit Dialog Window

RECORD/TABLE MENUS

Each highway data record provides a popup menu that appears when you RIGHT click on a record as shown in Figure 26. The items in the record menu (top) apply to the selected record, while the items in the table sub-menu (bottom) apply to the entire table.

A screen shot shows the menu associated with a given highway data record, where the user has options for manipulating the data in a selected record.

Select. Select the record for analysis.

Unselect. Unselect the record so it will not be included in the PHT analysis.

Validate. Perform validation testing on the selected record

Table. Displays the Table sub-menu.

Copy Row(s). Copy the selected row(s) to the clipboard.

Copy with Headers. Copy the selected row(s) along with the column headers to the clipboard.

Paste. Paste the contents of the clipboard to the table.

A screen shot shows the menu associated with a given highway data record, where the user has options for manipulating the data in the entire table.

Begin Editing. Place the PHT database window in edit mode to allow user editing of the highway data table. If already in edit mode, this item will labeled End Editing and will terminate the PHT database window edit mode.

Save. Save all changes to the highway data table.

Validate All. Validate all records in the highway data table.

Save Layout. Save the current layout of the table.

Restore Layout. Restore the default layout of the table.

Figure 26. Record/Table Popup Menus

SUMMARY

The Summary tab in the vertical panel shown in Figure 27 summarizes the percentage of highway sections that already have a failing measured distress or have exceed their maximum service life as well as the minimum, maximum, and average distress values and surface age for the rigid, flexible, and composite pavement types. This summary is useful to help you assess your highway data set prior to running the PHT analysis.

A screen shot shows the window associated with the Summary tab in the database window, where the user can review values in the data set before running the PHT analysis.
Figure 27. PHT Database Summary Window

The distress thresholds and maximum service life durations are defined as part of the PHT analysis parameters. To perform a summary analysis you must first select the parameters for the analysis from the drop-down list at the top of the window. Click the Refresh button to perform the summary analysis and display the results in the window.

Only the highway sections that are selected in the data set are used when performing the summary analysis. This allows summaries of different subsets of highway sections, by first selecting only the sections of interest and then clicking the Refresh button.

The Copy button on the toolbar will copy the summary analysis results to the Windows clipboard in a format that is compatible with Microsoft® Word or Excel.

GIS Selections

The GIS Selections are based on a GIS shape file that contains the geographical information about the highway sections associated with your PHT database. You can use the GIS Selections window shown in Figure 28 to select a group of highway sections to work with. The GIS selection has multiple uses in the PHT analysis tool including selecting highway sections for analysis, defining a continuous corridor for corridor profiling, and providing GIS information to generate thematic maps by the report wizard.

A screen shot shows the window associated with the GIS shape file that contains geographical information about the highway sections associated with the PHT database. The user has toolbar options to select highway sections for analysis, define a corridor, or select GIS information to generate maps using the report wizard.
Figure 28. GIS Selection Window

The toolbar at the top of the window provides for the following functions:

icon Manual Selection Manual Selection. Select highway sections by manually clicking on them in the GIS map. Clicking a highway section will toggle it between selected and non-selected.
icon Select by Attributes Select by Attributes. Select highway sections by querying the attributes of the GIS map records. The GIS query builder dialog window will be displayed to write the SQL selection query.
icon Select by Shortest Path Select by Shortest Path. Select highway sections by finding the shortest path between two points. You must click on two highway sections to serve as the beginning point and end point of the path.
icon Remove Remove. Remove the current selection.
icon Save Save. Save the current selection of highway sections.
icon Select Highway Sections Select Highway Sections. Use the GIS selection to select highway sections to be evaluated by the PHT analysis.
icon Compile Corridor Compile Corridor. Evaluate the highway sections that make up a GIS selection and determine if they form a continuous corridor.
icon Zoom +, icon Zoom -, icon Zoom Large, icon Zoom Small, icon Pan Zoom and Pan. Zoom and pan through the GIS map.
GIS SELECTION PROPERTIES

When a GIS selection is first created, its properties window, shown in Figure 29, is displayed. For the GIS selection to work with the PHT database, you must specify the data fields that will be used to link the PHT database with the GIS information. There are five fields to specify:

  • State FIPS. This item identifies the field that contains the state FIPS (Federal Information Processing Standard) code.
  • Route ID. This item identifies the field that contains the route identifier. Route identifiers must be a non-zero alphanumeric value.
  • Beginning Milepost. This item identifies the field that contains the beginning milepost along the route where the highway section begins. To uniquely identify a highway section, route mileposts must be state-based and must increment continuously along the route.
  • Section ID. This item identifies the field that contains a state-wide unique highway section identifier. A section identifier is an alphanumeric value. The section identifier field is optional, but if provided it will be used in lieu of the route identifier and beginning milepost combination when linking the PHT database with the GIS information.
  • Section Length. This item identifies the field that contains section length information. This field is required when working with corridor profiles to provide length information for highway sections that are included in the GIS corridor, but for which there is no corresponding record in the PHT database.

The properties window for the GIS Selection can also be activated by clicking the Properties icon Properties option in the GIS selection RIGHT-click popup menu.

A screen shot shows the window associated with a GIS selection, where the user can specify the data fields that will be used to link the PHT database with the GIS information.
Figure 29. GIS Selection Properties

If a GIS selection is intended to be used for corridor profiling, all the highway sections in the selection must form a single continuous corridor. The properties window indicates if the GIS selection is or is not a continuous corridor, or if its state is unknown. You can determine if the GIS selection is a continuous corridor using the Compile Corridor option in the GIS selection RIGHT-click popup menu. After a GIS selection has been created or edited, its continuous state is defined as Unknown until it is compiled, after which it will be Yes or No.

However, use of the GIS selection by the report wizard to simply generate thematic maps does not require it to define a continuous corridor. For this use, it may define a corridor or any other sub-section of the map such as a type of functional class, or geographical region such as a county or urban area.

Analysis Parameters

The PHT analysis parameters provide many settings that affect the results of the PHT analysis. The PHT tool provides a complete set of national default values for each metric; however, you can modify the metrics to customize the PHT analysis as desired. Once modified, the customized parameters can be saved as the default values, overriding the original national defaults. You can restore any set of parameters to their original national defaults from the Analysis Parameters popup menu.

The analysis parameters are organized on four tabs. The first tab, shown in Figure 30, provides the settings for the pavement maximum service life. The maximum service life is specified in years for each type of surface treatment.

A screen shot shows the window associated with the Maximum Service Life tab under the PHT analysis parameters, where values are specified in years for each type of surface.
Figure 30. Parameters - Maximum Service Life

The next tab, shown in Figure 31, provides the settings for the terminal values for each type of distress associated with rigid, flexible, and composite surfaces. These values are the deficiency thresholds at which point the surface is considered to have reached the end of its service life.

A screen shot shows the window associated with the Terminal Values tab under the PHT analysis parameters, where the user can select surface type options that include rigid pavement, flexible, and composite for a display of values related to distress type for interstates, primary roads, and secondary roads.
Figure 31. Parameters - Terminal Values

The next tab, shown in Figure 32, provides the pavement estimate settings that are used by the PHT analysis to estimate values that are missing from the PHT source data. Values are provided for each individual state for interstates and for primary and secondary roads.

A screen shot shows the window associated with the Pavement Estimates tab under the PHT analysis parameters, where the user can select a particular state from an alphabetical list and view a display of values related to overlay thickness, pavement thickness, as well as parameters related to the base and construction material details for interstates, primary roads, and secondary roads.
Figure 32. Parameters - Pavement Estimates

The last tab, shown in Figure 33, provides options on how the RSL is calculated. You can use the critical RSL or a weighted average. The distress weights are used to set the relative effect of each distress type on the RSL calculation when using weighted averages. Setting all weights to an equal percentage will cause each distress type to have an equal effect. The sum of the weight percentage of all distresses for each surface type must add up to 100%.

A screen shot shows the window associated with the Weights tab under the PHT analysis parameters, where the user can select between using the critical distress for RSL calculation and using the weighted average for RSL calculation and view values for distress type for flexible, rigid, and composite surface types.
Figure 33. Parameters - Weights

Running the PHT Analysis

To run the PHT analysis, select a PHT database and click the Analyze icon Analyze button in the toolbar of the Settings tab of the PHT analysis window. The run dialog window shown in Figure 34 will appear.

A screen shot shows the window associated with the Run PHT Analysis function of the software, where the user can specify a title and database and analysis parameters and select from historical data files to be used to calibrate the analysis. The user also has the option to calculate the reliability RSL.
Figure 34. PHT Run Window

The PHT run dialog window allows you to select options that affect how the analysis is performed.

  • The first option is to enter a descriptive title for the PHT analysis results. This is the title that will appear in the Results tree in the user interface. To avoid confusion with other PHT analysis runs you may perform, you should take time to enter a title that is both descriptive and unique.
  • The second option is to select the PHT database and PHT analysis parameters that you want to use for the analysis. Select the desired PHT database and parameters from the drop-down lists.
  • Finally you may select historical PHT databases from previous years to be used for the calibration of the analysis based on measured values. The records in historical databases must be for the same set of highway samples that are being analyzed. You may choose up to five historical reference years; the years do not need to be contiguous. The historical data are optional, but providing the actual measured distresses will improve the accuracy of the RSL predictions.
  • The final checkbox at the bottom of the window instructs the PHT analysis to calculate the reliability RSL value.

Click the Run button to start the PHT analysis.

During the processing of the PHT analysis, a progress indicator is displayed in the Process Status panel shown in Figure 35 (top) to provide you with feedback about the analysis progress. You can cancel the PHT analysis from this window by clicking on the Cancel button. Textual messages are periodically displayed in the Output window, shown in Figure 35 (bottom), to give more detailed information about the status of the analysis. When logging is enabled, any records that generate an analysis error will display the error message in this window to provide a real-time feedback to the user as an indicator of any problems with the analysis.

A screen shot shows the windows associated with the process status. The process status is indicated by the length of a bar generated in the window. A screen shot shows the windows associated with the output, The output is indicated by a time stamp followed by a brief activity description, as well as a summary statement and a final completed message.
Figure 35. PHT Output Window

After the PHT analysis is complete, a message dialog window will display to inform you about the results of the PHT analysis, as shown in Figure 36.

A screen shot shows the window associated with the Pavement Health Track results, where the user can view a summary of the analysis and press OK to end the routine.
Figure 36. PHT Analysis Result

The PHT results are displayed in the tree on the PHT Results tab of the PHT analysis window. A result set includes a copy of the parameter metrics used during the analysis and a copy of the original PHT database with the fields that contain the analysis results appended to the database table.

If there are no successfully analyzed records, then no result set will be displayed.

PHT Results

The PHT results are displayed in the tree on the PHT Results tab of the PHT analysis window. A result set includes a copy of the parameter metrics used during the analysis and a copy of the original PHT database with the fields that contain the analysis results appended to the database table. The PHT results window is displayed by selecting a result database and clicking the Open button on the toolbar.

The PHT results are displayed in the data table window shown in Figure 37.

A screen shot shows the window associated with the PHT Results, where the user can view a table of values derived from the completed analysis.
Figure 37. PHT Results Window

The data table displays the original highway data that were analyzed by the PHT tool. A vertical oriented panel on the left of the window provides information about the analysis for the highway data record selected in the table including the RSL estimates, a summary report, and an analysis log. All data items in this window are read-only and cannot be modified.

POPUP MENUS

The PHT results window provides popup menus similar to those in the PHT database window. The column menu appears when RIGHT-clicking on a column header and allows for ascending or descending sorting of the selected column or to remove any applied sorting. The table menu appears when RIGHT-clicking on the table body and provides options to copy the contents of the table to the clipboard. When copying the data to the clipboard, all data items are copied including the PHT results data items.

DATA

The Data tab in the vertical panel provides a view of the PHT analysis results for the highway data record selected in the table. All the RSL data items can be displayed, or you can filter the display into categories using a popup menu that appears when you RIGHT-click anywhere on the data list. The filtering options include RSL by years, by ESALs, and user-defined fields.

SUMMARY

The Summary tab in the vertical panel provides a user-friendly readable summary of the analysis results for the highway data record selected in the table as shown in Figure 38. The summary highlights the estimated RSL for the pavement surface and illustrates the distresses and service life limits that contributed to the RSL estimate. It also annotates the analysis with notes that describe the pavement construction and any unusual conditions in the data.

A screen shot shows the popup window associated with the analysis results, where the user can select from data, summary, and maintenance tabs for views of the analysis results. The Summary tab is organized into panels that organize data related to General Information, Remaining Service Life, Distress at End-of-Service, RSL by Distress and Notes.
Figure 38. PHT Result Summary Window
MAINTENANCE

The Maintenance tab in the vertical panel provides access to the PHT maintenance model. The maintenance model uses the forecasted distress levels to select highway sections that have a feasible maintenance treatment available that will extend their RSL. The model also calculates the cost and estimates the monetary benefits of the maintenance treatment for each section.

The maintenance model window is shown in Figure 39.

A screen shot shows the window associated with the Maintenance tab where the user has options for running the maintenance routine and associated lookup tables. A screen shot shows the windows associated with the Data tab where the user can view results.
Figure 39. PHT Maintenance Model Window and Results

There are two objectives for the maintenance model:

  • Minimum Benefit/Cost Ratio (BCR). This objective will identify all highway sections that have a feasible maintenance treatment option available that will produce a benefit/cost ratio greater than some specified level regardless of cost.
  • Constrained by Funds. This objective will identify all highway sections that have a feasible maintenance treatment option available and prioritize each until some specified level of funding has been exhausted. Prioritization is performed using one of three selection methods:
    • Worst RSL. This method selects as the first to be treated those highway sections that have the lowest RSL as forecasted by the PHT analysis.
    • Maximized BCR. This method selects as the first to be treated those highway sections that have a maintenance treatment option that will produce the highest BCR.
    • Best RSL Extension. This method selects as the first to be treated those highway sections that have a maintenance treatment option that will produce the highest service life extension.

The Discount Rate percentage is used by the maintenance analysis for estimating the benefits associated with postponing reconstruction costs by performing a less expensive maintenance treatment to prolong the life of the existing pavement.

Click on Apply Maintenance to apply the maintenance model and see the results. After a maintenance model has been applied, the results will appear in the vertical oriented Data tab. A description of the data fields that make up the maintenance model results is provided in Table 7. Click on Clear to remove the maintenance model and display the original table of PHT results.

The PHT maintenance model feature is a run-time viewer utility. The results of the model are not saved when the PHT result window is closed. A detailed description of the maintenance model is provided in the Technical Information section of this document.

LOOKUP TABLES

The maintenance model uses five lookup tables when performing its analysis. The user can view and modify each of these tables by clicking on the title a table. The default values for each lookup table are provided in Table 9 through Table 13 in the Technical Information section of this document. The following tables are available:

  • Trigger Levels. The trigger-level table provides the deficiency thresholds for each distress type that defines at what point a maintenance treatment is warranted. Any distress exceeding its threshold triggers the need for a maintenance action.
  • Feasibility Thresholds. The feasibility thresholds provide the decision criteria for selecting the improvement option based on the pavement distress and RSL. The preferred improvement will be the lowest feasible improvement group that will address the pavement's conditions.
  • Post-Maintenance Resets. The post-maintenance reset table provides the percentage of improvement for each distress type as a result of a maintenance treatment. The extent of the improvement is determined based on the existing distress level and the type of treatment applied. A value of 0% means no change to the distress while a value of 100% implies that the distress is reset to a like-new condition.
  • Service Life Extensions. The service life extension table provides the post-improvement extension to the RSL (years) as a result of the application of a maintenance treatment. Additional extensions to the service life are provided to take into account the effect of climate and traffic conditions and pavement construction.
  • Treatment Costs. The treatment cost table provides the estimated cost of applying a maintenance treatment as measured in current dollars per lane-mile.
RESULTS

The results of the PHT maintenance model analysis provide the following information:

  • Maintenance Option. Recommended maintenance treatment for the highway section.
  • Service Life Extension. The extension in service life of the pavement as a result of applying the recommended maintenance treatment.
  • Maintenance Cost. Overall total cost of applying the recommended maintenance treatment taking into account the length of the highway section and the number of lanes treated.
  • Overall Benefit. Benefit, quantified in terms of the value added to the pavement infrastructure due to the application of a given maintenance treatment.
  • Benefit/Cost Ratio. Ratio of the overall benefit and total maintenance cost.
  • Revised Distresses. The revised post-maintenance distress values for IRI, rutting, cracking, and faulting as a result of applying the recommended maintenance treatment.
LOG

The Log tab in the vertical panel is only available if a log file has been captured during the analysis and is available for display as shown in Figure 40. The content of the log file is determined by the logging properties that are set in the Log tab of the Properties window. It displays the log entries created in the log file for the highway data record selected in the table. The log entries are useful to track the analysis process to aid in understanding the results.

Each log entry is identified as an error, warning, or informational message.

A screen shot shows the window associated with the Log tab of the PHT analysis tool. It is available only when the user has specified that a log file is to be captured during analysis. The log contains brief descriptions of stages completed in the course of the analysis routine. Each entry is identified as an error, warning, or informational message.
Figure 40. PHT Log Window

PHT Report Wizard

To activate the Report Wizard, click the Generate icon Generate Report button on the toolbar of the PHT Results tab of the analysis window. This wizard provides an automated process to generate statistical charts and thematic maps useful to visualize the results of the analysis.

The Report Wizard window is shown in Figure 41.

A screen shot shows the window associated with the PHT Report Wizard, where the user can provide a report title, select analysis results, and select themes and number of thresholds for the desired report. The window also allows the user to select between individual value and value range options for the report.
Figure 41. Report Wizard

A title must be provided for the report. To avoid confusion later, the report title should be both descriptive and unique. A set of PHT analysis results must also be selected to provide the basis for the report content.

A list of theme options is provided that determines the purpose of the report. When a theme option is selected, a suggested list of threshold values is automatically provided that defines groupings for the reports information. This is only a suggested list and can be edited by the user as necessary. Each threshold must specify a limit value for its range, followed by a textual description of the data group that the threshold is defining. The limit values can have two meanings as follows:

  • Individual Value. The data in this grouping must equal the limit value. This setting is useful when the theme is based on an enumerated value, such as the function system.
  • Value Range. The data in this grouping must lie within the range defined by the upper limit value inclusively and the previous threshold's upper limit value exclusively; for the first threshold, the range is defined as less-than limit value inclusively. When using this setting, the limit values for each subsequent threshold must always increment in value.

The Report Wizard can generate a statistical chart, a thematic map, or both together using the same settings. When the report is generated, it is automatically added to the document library and the current Study. Clicking the GIS Maps or Charts icon at the left of the Study window will display a list of reports that have been created by the report wizard and added to the Study.

CHARTS

Statistical charts are used to create complex graphs that illustrate quantitative information generated by the PHT analysis. Extensive formatting features are available to create many types and styles of charts that can be saved to a template library for reuse. Check the Statistical Chart checkbox to instruct the wizard to generate a chart report.

A number of options are available when generating a statistical chart report:

  • Multiply section length by the expansion factor. This option will instruct the wizard to multiply the length of the highway section by its expansion factor when determining its overall total length. If no expansion factor is provided in the data, then the unmodified section length will be used. This option is useful when you have a small number of samples that represent a large number of miles and you want the report to more accurately represent the actual highway miles in the theme group.
  • Show mileage as a percent. This option will instruct the wizard to determine the total number of miles in the data set and calculate the overall percent of miles included in the theme group to be used in the chart rather than actual miles.
  • Disaggregate by surface type. This option will instruct the wizard to disaggregate the data for each theme group into sub-groups by the pavement surface type. This option in not available for thematic maps.
  • Disaggregate by function system. This option will instruct the wizard to disaggregate the data for each theme group into sub-groups by the function system. This option in not available for thematic maps.

An example of a statistical chart is shown in Figure 42.

A screen shot shows the window associated with the Chart option of the Report Wizard. A vertical bar chart with statistical data is shown as an example.
Figure 42. Statistical Chart

When displaying multiple charts you have the option to display them as Tabbed icon Tabbed Display or Stacked icon Stacked Display by clicking the corresponding button on the toolbar. The tabbed feature has the advantage of maximizing the amount of screen space available to display each chart, but only displays one chart at a time. While the stacked feature allows you to view all the charts at once, it limits the amount of space available to display each chart.

The chart appearance can be customized using the chart's Properties window; simply RIGHT-click anywhere in the chart area window to activate the properties dialog for the chart. Settings include color and shading, 3D effects, chart types, legend appearance, plot types, grids, axis scales and annotations, and chart labels.

You can apply a common Y-axis scale for all the charts by clicking the Synchronize Y-axis icon Synchronize Y-axis button on the charts toolbar. This is useful to visualize the relative values among multiple charts that show similar information with a common unit of measurement.

The Synchronize X-axis icon Synchronize X-axis button on the toolbar will visually align the axis positions of several charts together. This is required when using the Zoom feature while using the stacked page layout.

The Zoom icon Zoom button on the toolbar toggles the X-axis zoom mode for the chart. When zooming is active, a zoom bar appears at the bottom of the chart window. You can adjust the amount of zoom and pan by dragging the beginning and ending markers to the left or right as desired. When zooming is deactivated, all zooming will be removed from the charts.

You can use the Add icon Add and Remove icon Remove buttons to manually add and remove charts from the display.

The Print icon Print button on the toolbar will activate a dialog window that provides printing options for the chart. The print destination can be a printer, Windows clipboard, or a bitmap file. You have options to set the position and scaling of the chart image as desired. A preview of the printed chart is provided.

The following four controls in the chart toolbar are exclusively for working with chart templates and the template library, and are only active immediately after the report wizard has generated the statistical chart. Once the chart window has been closed, the template controls will not be available the next time the chart window is opened from the document library.

icon PHT Analysis Results PHT Analysis Results. Identify the analysis results displayed in the chart.
icon Refresh

Refresh. Refresh the chart after a different set of results are selected.

icon Load

Load. Load a chart from the chart template library.

icon Save

Save. Save the chart to the chart template library.

The Chart Data window, shown in Figure 43, is displayed by clicking the Data Sheet icon Data Sheet button on the toolbar. This window is where you enter or query the data that you want to display in the chart. All data that will be graphed in the chart are specified in this window. The table contains columns of data for the X and Y axis of the chart and is an active spreadsheet that allows for both manual data entry and formula calculations.

A screen shot shows the window associated with the Chart Data feature of the Report Wizard, where the user can view a table of the data used and make adjustments to what is charted and not charted.
Figure 43. Chart Data Window

When you click on a cell, information about the selected cell is displayed and can be edited using the fields and toolbar above the table. Chart data can also be retrieved automatically from the database using the options available through a given chart's popup menus. The left most column of the table contains the data for the X-Axis while the other columns contain the Y-Axis data for each plot on the chart.

  • X-Axis Column. All plots in the chart share a common X-axis. The chart table always has an X-Axis column displayed in its left-most position. No holes are permitted in the X-Axis, so every row of the X-Axis column must be provided with a value.
  • Y-Axis Columns. There are two types of Y-Axis columns available, designated as the primary Y-Left axis and the secondary Y-Right axis. One or more columns can be added to the table with each column corresponding to a separate plot on the chart. Each data column for each plot is designated as a Y-Left or Y-Right plot. Holes are permitted in the plots if no data corresponding to the X-Axis are available. To create a hole, skip a row in a plot column, leaving the unwanted cell blank. The Y-axis columns can also be designated as OFF, in which case the data are still saved, but are not plotted in the chart.
  • Other Columns. Not all columns in the table need to be plotted onto the chart. The data in columns that are not directly plotted can be used as source data or as intermediate steps for formula calculations. These columns can be hidden in the table for clarity.

You can add any number of Y-axis columns of data to the design grid and have each column correspond to a separate plot on the chart. To add a plot column, simply increase the number of columns in the table and select the axis that you want the data to be plotted on.

Though normally the design data will represent the information for a single chart, you also have the option to separate the data onto up to five different charts. Plots are arranged onto different charts by selecting the chart designator A, B, C, D, or E. You can also specify the ALL option to indicate that you want the plot to appear on all charts. When using multiple charts, they will each use a common X-axis scale.

By RIGHT-clicking on the column headers of the data table, you will activate a popup menu, shown in Figure 44, which allows you to manipulate the column data and properties.

A screen shot shows the window associated with the chart data window where the user can perform operations that affect the data or perform a query.

Copy. Copy the contents of the selected column into the windows clipboard.

Paste. Paste the contents of the Windows clipboard into the selected column.

Clear Contents. Clear all data from the selected column.

Show All. Show any column that has been previously hidden from view in the table.

Hide. Hide the selected column.

Column Formula. Display the expression builder to write a mathematical formula to calculate the data for the column.

Format. Enter a formatting string that formats the numbers displayed in the column.

Rename. Rename the column. The column name is used in the legend of the chart when the data are plotted.

Column Settings. Display the property settings for the selected column that control the appearance of data in the chart and access trend-line options.

Query. Display the query wizard to retrieve PHT analysis result data from the database.

Figure 44. Chart Data Column Popup Menu

One of the features of the chart data window is the ability to use mathematical formulas to calculate the data for individual cells or for the entire column. Formulas are equations that perform calculations on values. A cell formula must always start with an equal sign followed by an equation as show in the example formula below. Formulas may contain numerical values, mathematical operators and functions, and references to other cells in the table. Cells are referenced by their address in the table, which is always their column letter (A-Z) followed by their row number.

=INT((B1/C1)*10000)/100

Column formulas apply to the entire column. The syntax used by column formulas is identical to that used by cell formulas except that in addition to cell references, column formulas may also use column references. Columns are referenced by their column letter (A-Z) only and are NOT followed by a row number. The column reference is essentially a partial cell address that is completed by the row number when it is applied. For example, a reference to column B would become B3 when applied to a cell in the third row of the table.

Cell formulas supersede column formulas and column formulas supersede manually entered data. Data retrieved from the database are treated by the data table as manually entered data. As such, data retrieved from the database will be superseded by both cell and column formulas.

The PHT analysis results can be queried directly from the result tables in the database using the query wizard to select a data table, data field, and filter clause. The data filter represents the WHERE clause of a SQL statement and must comply with all SQL syntax rules.

MAPS

Maps are used to create complex geographical information system (GIS) maps. Check the Thematic Map checkbox to instruct the wizard to generate a map report. To generate a thematic map, you must choose a GIS selection from the drop-down list for the wizard to use as the source for the map.

There is one option available when generating a thematic map report.

  • Apply theme only to selected sections. This option will instruct the wizard to apply the map theme only to the highway sections that are selected in the GIS selection. This option is useful when you want the map theme to be highlighted only on a sub-section of the map such as a corridor, type of functional class, or a geographical region such as a county or urban area.

An example of a thematic map is shown in Figure 45.

A screen shot shows the window associated with the My Map tab of the Report Wizard, where the user can select the surface types of the highways as well as map features that are plotted.
Figure 45. Thematic Map

The map layer is the basic component of a map. A map can have multiple layers with each layer displaying the contents of a different shape file. The order in which the layers are displayed is shown in the legend with the layer at the top appearing above all layers beneath it.

To add a new layer to the map, click the Add Layer icon Add Layer button on the toolbar. Browse to the GIS file that you want to add to the map and select it. The new layer is added to the map and placed as the top layer. To delete a layer, select it in the legend and press the Delete key. The style properties of the layer define its appearance in the map including color, line weight, and line and fill styles. To view and edit a layer's style properties, double-click the layer entry in the legend.

To create a selection of items from the map, click the Selection icon Selection button on the toolbar and a new selection is added to the currently selected layer and displayed in the legend. The selection is highlighted with a user-defined color, line thickness and style. The drop-down menu provides three methods available to add items to the selection.

  • Select by Attributes. This option will display the Query Dialog where you can build a SQL query statement to select items based on their attributes. The query wizard allows you to define selection criteria to add items to the selection. The syntax of the selection criteria represents the WHERE clause of a SQL statement and must comply with all SQL syntax rules. To assist in building the selection criteria, the selection builder provides a list of attribute fields and their respective unique values.
  • Manual Selection. This option allows you to manually add items to the selection by clicking on them in the GIS map. Only items that are in the currently selected map layer can be added.
  • Select by Shortest Path. This option applies to line-layers only and allows you to automatically select a map corridor between two points. If no unbroken path between the two points can be found, then no items will be added to the selection.

To clear the entire map, click the New Map icon New Map button on the toolbar.

To view the attributes of any item in the map, click the Identify icon Identify button on the toolbar and then click the item on the map. Items on any layer of the GIS map may have many attributes that describe them. These attributes are useful to create map selections and themes. The attributes for the item appear in a table under the legend.

The legend of the map is displayed in a hierarchal tree. You can turn individual items in the map on and off using the check boxes on the left side of the legend pane. Double-click items in the legend to display a dialog window to edit the settings for that item.

TEMPLATES

Charts generated by the report wizard can be saved to a template library for reuse with other PHT analysis result sets. The report wizard can generate charts from templates stored in the template library as shown in Figure 46. To select a chart template, click the Templates tab in the report wizard window. All of the chart templates in the template library are displayed in the list. Click on a chart template in the list to select it and click the Generate button to create a new chart based on the selected template.

A screen shot shows the window associated with the charts panel of the Report Wizard, where the user can select the specific chart desired for the report.
Figure 46. Report Wizard - Chart Templates

Non-HPMS Data Mapping

You can import highway data directly from a non-HPMS data source using a one-to-one field map to control how the data are loaded. Data can be read from an Access database, a flat comma-delimited file, a dBase file, or any predefined ODBC connected data source.

To activate the import wizard, click the Open Non-HPMS icon Open Non-HPMS button on the Settings toolbar. The window shown in Figure 47 will appear. This first tab allows you to select the data source to read the highway data.

A screen shot shows the window associated with the Import Wizard that permits the user to access data from a non-HPMS data source. The interface displays paths that can be accessed for various types of data files.
Figure 47. Import Wizard - Datasource

There are four options to select from when importing an external non-HPMS formatted data source:

  • The first option is to import data stored in a Microsoft® Access database. Using this option will also require you to select a source table within the Access database. Data cannot be read from multiple tables; therefore if the data reside in multiple tables, it will be necessary to design a query to combine all the data into a single table prior to importing it into the PHT analysis tool.
  • The second option is to import data from a dBase file.
  • The third option is to import data from a comma-delimited text file. When using this option, you will need to indicate if the first line of the source file contains field names. It is easier to create the field map if descriptive field names are provided. An alternate delimiting character can also be specified if other than a comma.
  • The fourth option is to import data from any defined ODBC data source such as Oracle, FoxPro, Paradox, or even spreadsheets such as Excel.

The next tab, shown in Figure 48, allows you to select the source table (if applicable) and define a field map between the data fields in the source data and those of the PHT data table. For each PHT field, select a matching field that provides the data. You can also directly enter a hard-coded value or choose to leave a field blank if the source table has no matching item. The mapped field must have a compatible data type with the PHT field.

A screen shot shows the window associated with the Import Wizard that permits the user to select data with compatible data types for import from external field to destination field.
Figure 48. Import Wizard - Field Map
APPLYING FORMULAS IN THE FIELD MAP

In addition to one-to-one field mapping, the import wizard also provides formulas to calculate a required value when it is not directly available in the source data. To create a formula for a field, activate the formula wizard by selecting the field and then clicking the Formula option at the top of the dropdown list, as shown in Figure 49.

A screen shot shows the window associated with the Import Wizard that permits the user to generate a formula for a field to calculate a required value that is not directly available in source data.
Figure 49. Import Wizard - Formulas

The formula wizard provides a list of all of the data fields that are available in the source data. The formula expression can use simple math, functions, and the values of the other fields in the record to calculate the new value as shown in Figure 50. The math and string function prototypes are available by clicking the Functions button in the formula builder.

A screen shot shows the window associated with the Import Wizard that permits the user to select from a list of all data fields to generate expressions using simple math, functions, and values from other fields to calculate a required value. A button labeled Functions provides the user with a set of math and string function prototypes.
Figure 50. Formula Builder
MATH AND STRING FUNCTIONS

The supported math and string functions are described in Table 4.

Table 4. Math and String Functions
Math Functions Trig Functions String Functions Decision Functions
ABS
EXP
LOG
LOG10
CEILING
RAND
ROUND
SIGN
SQRT
SIN
COS
TAN
ASIN
ACOS
ATAN
SINH
COSH
TANH
LEFT
RIGHT
SUBSTRING
CHARINDEX
LEN
CASE

The final tab, shown in Figure 51, provides an advanced option to filter the records in the source table prior to importing the data to the PHT table. This is useful if you only want to read a sub-set of the records that are in the source table. Use the filter wizard to create the SQL clause to filter the data, or use the SQL Text window to enter the filter clause directly.

A screen shot shows the window under the Filter Wizard tab associated with the Import Wizard. It shows data in table format and permits permits the user to perform filtering operations on the record set in the source table prior to importing values to the PHT table. A screen shot shows the window under the SQL Text tab associated with the Import Wizard. It shows selectable options under Fields, Operators, Functions, and Values.
Figure 51. Import Wizard - Advanced Filtering

Click the Import button to import the source data into the PHT analysis tool. When you import data, the import wizard will remember all of your selections and field mapping design for reuse in the future. If you cancel the import wizard, any selections or field mapping changes will be lost.

Updated: 11/22/2013