The "HPMS Help & Workflow Articles" page is the culmination of all articles in the HPMS and Workflow categories. This page eliminates the need to click between articles.

HPMS Help Articles

Screen Overview

The HPMS Manager interface has 3 functional areas upon first entering the application: (1) Map Frame, (2) Legend Menu, and (3) Tabs and Control Ribbon. Each of these are shown in the image below, with corresponding numbers to the list above.

(1) Map Frame

The Map Frame is used to display the route network, HPMS data, validation results, and query results in visual form. When the user initially opens the application, a map with state and parish boundaries is shown. A variety of controls for the Map Frame permit the user to zoom to an area of interest if desired.

(2) Legend Menu

The Legend Menu displays a list of available map layers that can be turned on/off by clicking the appropriate checkbox. The legend menu is displayed or hidden by clicking the arrow control (carat) to its immediate right.

(3) Tabs and Controls Ribbon

The HPMS Manager interface has 8 tabs: Map, Edit, Validations, Sample Adequacy, Submittals, Reports, System Administration, and Help. Each tab contains a set of controls displayed in ribbon format. When a tab is selected, the corresponding set of controls is displayed. These controls are sectioned on the tab's ribbon by general function. For example, the Edit tab hosts thirteen controls that are categorized into four sections: Data Editing, Management, Data Cleaning, and Route Info. Similarly, the other seven tabs have controls which are categorized into sections. The image below shows the Edit tab and its format.

Status Types

There are three status icons that can appear throughout the application. These icons are:

Icon	Type	Description
	Success	Indicates that no errors were encountered while importing data for the item.
	Warning	Indicates that a non-fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.
	Fatal Error	Indicates that a fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.

Map Display

The map display can be changed using a range of controls on the Map Tab and specific mouse interactions with the map. The mouse, whether attached to a laptop or an independent object, can be used to navigate the Map interface. There are four ways a user can utilize the mouse for this function:

Mouse Action	Description
Pan	Click, hold, and drag the map to re-center.
Trackwheel Zoom	Zoom in by rolling the mouse wheel forward and zoom out by rolling the mouse wheel backward.
button	Zoom in by selecting this button beside the Legend.
button	Zoom out by selecting this button beside the Legend.

There are also five sections on the Map Tab ribbon that control the map display: Navigate, Identify, Find Segments, Basemap, and iVision. Each section is easily identifiable by its title on the menu bar. The image below shows the sections in red boxes.

(1) Navigate

PMG makes the map experience easy for users by providing familiar icons on the Map tab to aid their navigation. There are eight icons on this section of the tab:

-- Full Extent: Zooms the Map to the initial, full extent of the application
-- Zoom In: Zooms the Map in one level
-- Zoom Out: Zooms the Map out one level
-- Zoom Area: Zooms the Map to a user drawn extent
-- Previous Extent: Zooms the Map to the previous map extent
-- Next Extent: Zooms the Map to the next map extent
-- Zoom to Query Results: Zooms the Map to the extent of a user query
-- Clear Map: Clears the results displayed on the map

Each icon listed is designed to work directly with the map, giving users a spacial experience with the HPMS data. Users can reference this list as a reminder of the functionality of the icons, but they can also simply hover their mouse over the unknown icon to display its given name.

(2) Identify

The second section on the Map tab helps users identify important information while navigating the map. The application hosts two icons in this section:

-- Identify Feature: A tool that can be used to click on any of the GIS features displayed on the map and retrieve basic information.
-- Identify Route: A tool that can be used to provide a list of routes near a selected location on the map.

Just as with the Navigate section, both icons here are designed to work directly with the map, giving users a spacial experience with the HPMS data. Users can reference this list as a reminder of the functionality of the icons, but they can also simply hover their mouse over the unknown icon to display its given name.

(3) Find Segments

The third section on the Map tab hosts search tools that allow the user to select information to find specific segments on the map. These tools provided vary from those in the other Map tab sections, for they include picklists or are linked to pop-up interfaces. The five tools on the Find Segments section are described below.

Icons	Names	Type	Description
	Data Dropdown	Picklist	Specifies the HPMS Overlay data for finding route segments.
	Map Color Dropdown	Picklist	Specifies the color when mapping route segments.
	Route	Pop-Up	Changes the Find Segments function to Route Search mode, enabling selections and filtering.
	Sample	Pop-Up	Changes the Find Segments function to Samples Search mode, permitting the user to search for a specific HPMS Sample Section.
	More Filters	Pop-Up	Changes the Find Segments function to More Filters Search mode, permitting the user to search for Segments using various filters.

Route

The Route pop-up menu hosts two lookup options: Statewide Route and LRS ID Route. All filters in Statewide Route are picklists, and the sole filter in LRS ID Route is in textbox format. By selecting filters under one of these options, the other lookup option (Statewide Route/LRS ID Route) will automatically become disabled. Once the user enters the desired information and selects the "Find" button, the HPMS Segments along the selected route will be mapped.

Sample

The Sample pop-up menu hosts a singular picklist for filtering. The user can select a Sample Section from this picklist and click the "Find" button to show a specific HPMS Sample on the map. The user can also hold their mouse over the mapped segment which will display Sample data in a pop-up menu.

More Filters

The More Filters pop-up will give the user access to some of the same filters as on the Route pop-up. However, there will be an extra option beyond Statewide Route Lookup and LRS ID Route Lookup: Other Filters. There is also an extra picklist available under Statewide Route Lookup-- System Type-- which designates route searches as On-System or Off-System. Just as in the Route pop-up, selecting either Statewide Route Lookup or LRS ID Route Lookup will disable the other. When the user has filled the desired filters, they can select the "Find" button to map HPMS Segments based on the selected filters and open a report containing data for the mapped segments.

(4) Basemap

Selecting the Basemap control button () opens a picklist of available basemaps that can be used as a backdrop to the GIS layers and business data. The available basemaps on the current HPMS application are Imagery, Imagery with Labels, National Geographic, Oceans, OpenStreetMap, Terrain with Labels, and Streets.

(5) iVision

The iVision control button () is enabled once a Route and location are identified. Clicking on this tool will open a new browser tab that will link to LADOTD’s “iVision” application and display images at the selected location.

Edit Tab

The Edit tab provides controls for editing data, viewing data, and saving edits previously applied to the HPMS data. There are 4 sections for the Edit ribbon: Data Editing, Management, Data Cleaning, and Route Info.

Icons

Each icon on this tab, except for the Select from Map icon, leads to an editing interface. These icons and their specific roles are listed below by section.

Data Editing

The following tools are provided under the Data Editing group:

-- Select from Map: Used to interactively click on a route and begin editing.
-- Basic Editor: Opens the interface to search, create, and edit HPMS Data.

Management

The following tools are provided under the Management group:

-- Edit Log: Opens the interface to view recorded edits to Data Tables.
-- Save Data to Source: Opens the interface to view edits to Data Tables and to update source data.
-- Edit Groups: Opens the interface to manage columns (Edit Groups) displayed in Basic Editor.
-- Edit Rules: Opens the interface to view and edit validation rules.

Data Cleaning

The following tools are provided under the Data Cleaning group:

-- Fix Events Gaps: Opens the interface to find and fix gaps in Roads and Highways events.
-- Snap Events to Route: Opens the interface to find and fix measure offsets between routes and events.
-- Fix Event Offsets: Opens the interface to find and fix measure offsets between events.
-- Fix Events Overlaps: Opens the interface to find and fix overlapping events.
-- Check Event IDs Report: Opens the interface to generate reports of duplicate or missing event IDs.

Route Info

The following tools are provided under the Route Info group:

-- View Concurrencies: Opens the window which displays all locations where there are overlaps in the route network.
-- View Translations: Opens the window which displays all locations where there are translations in the route network.

Select From Map

This is a tool that is located on the Data Editing section of the Edit tab. When Select from Map () is chosen, the user can click anywhere on the map to open a picklist of routes near the selected location. After selecting a route from this list, the user can open the Basic Editor tool by clicking the "Basic Editor" link at the bottom of the "Identity Route Results" pop-up.

Basic Editor

This is a tool that is located on the Data Editing section of the Edit tab. While the Basic Editor can be accessed through the Select from Map pop-up, it can also be accessed directly through the Basic Editor icon (). The Basic Editor interface is used to search, create, and update data in the HPMS Data Tables. The interface is divided into 4 sections: (1) Required Information, (2) Data Items, (3) Button Controls, and (4) Expand and Collapse Controls.

(1) Required Information

The Required Information section of the interface is used to specify which HPMS Overlay data and data items will be displayed in the table. There are some controls offered in this section.

Controls	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Edit Group Dropdown	Select which columns will appear in the table.
Enter Route Button	Open the Enter Route interface to input route information.
Find Button	Select the route and return to the Basic Editor.
Reset Button	Clear the fields.

(2) Data Items

The Data Items table will display data for the full extent of the selected route. This table is used for viewing and editing these data items. It consists of four static columns (Parish, Route ID, From Measure, and To Measure) and additional columns characteristic of the chosen Edit Group. The Data Table connects to the Map interface through the table rows. When a row in the table is clicked, the map will zoom in and highlight the corresponding segment in the Map Frame. When the segment is clicked, the map will zoom to the feature and highlight the corresponding row in the table.

The Data Table also indicates where gaps exist in the selected route in its effort to display the full extent of a route. Records will be inserted into the table indicating where gaps begin and end; these will not be editable.

Data Items can be edited by clicking in the desired cell in the table, prompting picklists or textboxes to appear. After performing edits, the row will be checked for validation errors. If a new value fails a validation check, an Error icon () will appear in the Error icon column (second column). Hovering over an error icon will display a description of the error.

Rows can be deleted by clicking the checkboxes in the first column of the table and selecting the “Delete Selected Rows” link. Changes to the table cannot be saved if new gaps or overlaps are created by deleting or adding a new row.

(3) Button Controls

The following controls are provided in this section of the Basic Editor:

Icons	Name	Used To...
	Save to Source	Commit changes to original source data items.
	Add Row	Insert a row into the table. New rows will appear at the top of the table.
	Delete Selected Rows	Delete a row or rows from the table. The records that will be deleted must be selected in the first column of the table.
	Save Changes	Save changes to the HPMS Overlay.
	Discard Changes	Discard changes since the last save operation.
	Status Log	Display a log of changes, errors, or updates during the edit session.

(4) Expand and Collapse Controls

The Basic Editor can be expanded and collapsed using the Maximize and Minimize buttons in the top right corner of the data table. If the Basic Editor is expanded (), it will fill the entire screen. If it is collapsed (), the only trace of the Basic Editor will be displayed in a singular bar at the bottom of the screen, with the Required Information portion shown.

Edit Log

This is a tool that is located on the Management section of the Edit tab. The Edit Log interface () provides a viewable history of changes made to each HPMS Data table. Results can be filtered based on a user, data item, county, system code, or route name. The table below lists these filter controls' function, alongside the other controls in this interface.

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Refresh Date Dropdown	Specify whether all edits, or only edits performed after a selected refresh date, are displayed in the Edit Log data.
User Dropdown	Select a user when filtering the results.
Data Item Dropdown	Select a data item when filtering the results.
Parish Dropdown	Select a Parish when filtering the results.
System Code Dropdown	Select a System Code when filtering the results.
Route Name Dropdown	Select a Route Name when filtering the results; this picklist is only populated after a System Code is chosen.
Filter Button	Filter the results based on the selected filter items.
Open as PDF Button	Open a copy of the Edit Log table in a PDF format.
Open in Excel Button	Open a copy of the Edit Log table in an Excel format or save a copy of the Edit Log table in a local Excel file.
Clear Historical Data Link	Open a pop-up menu to clear data from the Edit Log.
Navigation Dropdown	Increase/decrease the number of records to display.
Retrieve Previous 20,000 Records/Retrieve Next 20,000 Records	Enable links for users to view the edits in batches of 20,000 records.

Clear Historical Data

The pop-up window that results from selecting the Clear Historical Data link allows the user to delete all historical data edits or to delete historical data within a specific date range. If the user selects "All," all historical data edits will be deleted. If the user selects "Date Range," a Begin Date and an End Date must be specified. The textboxes or calendar icons next to these dates can be utilized to enter the necessary dates. After the desired options have been selected, the Delete button can be used to delete the data. The Cancel button can be used to exit out of the interface without deleting any data.

NOTE: When selecting a date range, it is important to note that the From Date is inclusive while the To Date is exclusive. For example, if the user has selected 10/01/2018 as the From Date and 10/31/2018 as the To Date, all log entries from 10/01/2018 to 10/30/2018 will be deleted. Any log entries recorded on 10/31/2018 will not be deleted.

Save Data to Source

This is a tool that is located on the Management section of the Edit tab. The Save Data to Source interface () provides the option to save data edits stored in HPMS Manager back to the source data from which the HPMS overlay originates. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
User Dropdown	Select a user when filtering the results.
Data Item Dropdown	Select a data item when filtering the results.
Parish Dropdown	Select a parish when filtering the results.
System Code Dropdown	Select a system code when filtering the results.
Route Name Dropdown	Select a route name when filtering the results; this picklist is only populated after a System Code is chosen.
Show Import Edits Checkbox	Give the option to show edits created during the populate/refresh process.
Only show edits user can save to source Checkbox	Filter out edits that cannot be saved to source.
R&H Radio Buttons	Filter by either R&H data items, Non-R&H data items, or all items.
Filter Button	Filter the results based on the selected filter items.
Open as PDF Button	Open a copy of the Edit Log table in a PDF format.
Open in Excel Button	Open a copy of the Edit Log table in an Excel format or save a copy of the Edit Log table in a local Excel file.
Save to Data Source Button	Save the selected edits back to the source data.
Navigation Dropdown	Increase/decrease the number of records to display.
Retrieve Previous 20,000 Records/Retrieve Next 20,000 Records	View the edits in batches of 20,000 records.

Edit Groups

This is a tool that is located on the Management section of the Edit tab. The Edit Groups interface () is used to create, save, or delete groupings of columns designated for editing. The Edit Groups interface specifies which columns will be shown in Basic Editor. There are some controls offered in this interface:

Control	Used To...
Edit Group Dropdown	Select an existing Edit Group to view, edit, or delete.
Add New Button	Create a new Edit Group.
Add Button	Select and add an Available Column to Selected Columns.
Remove Button	Select and remove one column from Selected Columns.
Remove All Button	Remove all Selected Columns.
Up and Down Arrow Buttons	Select and reorder columns within an Edit Group. The column order in the "Selected Columns" box will reflect the display order in Basic Editor.
Group Name Textbox	Edit, view, or input the unique Edit Group name. The group name can be changed by clicking in the textbox, editing the name, and clicking the Save Changes button.
Select/Deselect TOPS Link	Add/remove the TOPS items in Selected Columns.
Delete Button	Delete the currently selected Edit Group.
Save Changes Button	Save changes made to the selected Edit Group.
Discard Changes Button	Discard changes made to the selected Edit Group.
Plus and Minus Buttons	Modify the Selected Columns and customize the output of Basic Editor. Data items are categorized by functional area and can be expanded and collapsed using these buttons.

Edit Rules

This is a tool that is located on the Management section of the Edit tab. The Edit Rules menu option () opens the Validation Rules Maintenance interface which is used to view and modify the FHWA HPMS validation rules used for validation reports. The Validation Rules interface consists of 6 components: (1) Rule Type Control, (2) Reset Controls, (3) Rule List, (4) Rule Definition Table, (5) Condition Definition Tables, and (6) Save/Discard Controls.

The designated numbers for the component descriptions below correspond to the numbers on the image above.

Rule Type Control: This control picklist is used to switch between different rule type categories.
Reset Controls: There are two control buttons provided for resetting rules in the interface.
- Reset Selected Rule to Default -- Used to reset the failure message, rule definition, and condition definitions for a selected rule to the default FHWA value.
- Reset All Rules to Defaults -- Used to reset the failure message, rule definition, and condition definitions for all rules to the default FHWA values.
Rule List: This table provides a list of all HPMS Data Items and failure messages for the selected Rule Type.
Rule Definition Table: This table is used for adding rule criteria to a selected HPMS Data Item and rule type. The user can specify any combination of available data items to create a rule.
- The Logical column provides query operators (equal, not equal, greater than, less than, etc.).
- The Condition column can be filled using the Condition Definition Table.
- The "+" button will appear under the "+/-" column on the next available row, allowing additional criteria to be added to the rule.
- The "X" button will appear under the "+/-" column on filled rows to allow their removal.
- The Join and Parentheses columns allow the user to group or create condition rule criteria.
Condition Definition Tables: These tables are used for adding condition criteria to a selected rule criterion and for specifying the condition type, value, and arithmetic operator.
Save/Discard Controls: There are two control buttons provided in the Validation Rules Maintenance for saving or discarding data.
- Save Changes -- Used to save changes to a selected rule.
- Discard Changes -- Used to discard the changes to a selected rule.

Fix Event Gaps

This is a tool that is located on the Data Cleaning section of the Edit tab. The Fix Event Gaps interface () is used to find and correct gaps that exist in the source data for a Roads and Highways event. This interface hosts these controls:

Controls	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Event Dropdown	Select the data item that will be used to check for gaps.
Statewide/Parish Radio Button	Choose between retrieving all segments or a subset of segments that are within a specified parish boundary.
System Types Checkboxes	Select which route systems will be used when checking for event gaps. If none are selected, all route system types will be used. The Select All button can also be used to select all categories.
Route Types Checkboxes	Select which route types will be used when checking for event gaps. If none are selected, all route types will be used. The Select All button can also be used to select all categories.
Exclude Non-Inventory Routes Checkbox	Specify if non-inventory routes will be excluded when checking for event gaps.
Find Gaps Button	Find all segments where gaps exist according to the selected filters.
Save Changes Button	Update the gaps found for the selected rows.
Discard Changes Button	Discard any changes made to the interface.
Save Data to Source? Checkbox	Save the selected edits back to source events.
Export to Excel Link	Export the gaps found to an Excel file.

Snap Events to Route

This is a tool that is located on the Data Cleaning section of the Edit tab. The Snap Events to Route interface () is used to find and fix micro gaps or overlaps that exist between a Roads and Highways event and the end of routes. This interface hosts these controls:

Controls	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Event Dropdown	Select the data item that will be used to check for event/route offsets.
System Types Checkboxes	Select which route systems will be used when checking for offsets. If none are selected, all route system types will be used. The Select All button can also be used to select all categories.
Route Types Checkboxes	Select which route types will be used when checking for offsets. If none are selected, all route types will be used. The Select All button can also be used to select all categories.
Exclude Non-Inventory Routes Checkbox	Specify if non-inventory routes will be excluded in the results.
Find Events Button	Find all segments where offsets exist according to the selected filters.
Save Changes Button	Update the offsets found for the selected rows.
Discard Changes Button	Discard any changes made to the interface.
Export to Excel Link	Export the offsets found to an Excel file.

Fix Events Offsets

This is a tool that is located on the Data Cleaning section of the Edit tab. The Fix Event Offsets interface () is used to find measure offsets that exist between data items. Measures of a data item can be updated to match the measures of another data item. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Statewide/Parish Radio Button	Choose between retrieving all segments or a subset of segments that are within a specified parish boundary.
Event to Fix Dropdown	Choose which Event to update.
Event to Compare Dropdown	Choose which Event will be used as the control for measure comparisons.
Tolerance Textbox	Set a tolerance value for finding offsets.
Find Offsets Button	Find all segments where the measures of the Event to Fix item does not match the Event to Compare item.
Save Changes Button	Update the measures of the selected rows.
Discard Changes Button	Discard any changes made to the interface.

Fix Event Overlaps

This is a tool that is located on the Data Cleaning section of the Edit tab. The Fix Event Overlaps interface () is used to find and correct overlaps that exist within a Roads and Highways event. This interface hosts these controls:

Controls	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Event Dropdown	Select the data item that will be used to check for overlaps.
System Types Checkboxes	Select which route systems will be used when checking for event overlaps. If none are selected, all route system types will be used. The Select All button can also be used to select all categories.
Route Types Checkboxes	Select which route types will be used when checking for event overlaps. If none are selected, all route types will be used. The Select All button can also be used to select all categories.
Exclude Non-Inventory Routes Checkbox	Specify if non-inventory routes will be excluded when checking for event gaps.
Find Overlaps Button	Find all segments where overlaps exist according to the selected filters.
Save Changes Button	Resolve the overlaps found for the selected rows.
Discard Changes Button	Discard any changes made to the interface.
Export to Excel Link	Export the overlaps found to an Excel file.
Edit Source Link	Open the source event data for the selected segment to resolve overlaps in a given row.

Check Event IDs Report

This is a tool that is located on the Data Cleaning section of the Edit tab. Having a unique identifier-- Event ID-- for each event in the Roads and Highways (R&H) environment is important for temporality and data integrity within an R&H database. There should be no duplicate or missing Event IDs in any R&H event. The Check Event IDs Report interface () is used to check for these conditions. This interface hosts these controls:

Control	Used To...
Data Table	Select the HPMS Data Table to use when viewing the selected interface.
Event ID Check Radio Button	Choose between checking for Missing or Duplicate Event IDs.
Report Type Radio Button	Choose between Summary and Detail report formats.
Events Checkboxes	Select which events will be checked for invalid Event IDs. If none are selected, all events will be used. The Select All button can also be used to select all categories.
Select All Link	Select all checkboxes in the Events section.
Open as PDF Button	Open a copy of the table in a PDF format.
Open in Excel Button	Open a copy of the table in an Excel format or save a copy of the table in a local Excel file.

View Concurrencies

This is a tool that is located on the Route Info section of the Edit tab. The View Concurrencies interface () presents a list of route overlaps with related measures of the subordinate and dominant routes. As indicated by the name, the user will have view-only access to the data presented on this interface. This interface has one dropdown box which allows the user some control over its content.

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.

View Translations

This is a tool that is located on the Route Info section of the Edit tab. The View Translations interface () presents a list of route translations with related measures for both route networks. As indicated by the name, the user will have view-only access to the data presented on this interface. This interface has one dropdown box which allows the user some control over its content.

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.

Validation Tab

The Validations tab is used to execute and view HPMS validation reports before submitting data. There are four sections on this ribbon: HPMS Validations, Completeness, Summaries, and Management.

Validation

Icons

Each icon on this tab leads to an interface. These icons and the specific roles of their interfaces are listed below by section.

HPMS Validations

The following tools are provided under the HPMS Validations group:

-- Route/LRS: Opens the interface to run route ID, geometry, and measure validations.
-- Sample Sections and TOPS: Opens the interface to run validations for Sample Sections and TOPS items.
-- Import: Opens the interface to run import validations for the HPMS Data Items.
-- Cross: Opens the interface to run cross validations for the HPMS Data Items.
-- Coverage: Opens the interface to run coverage validations for the HPMS Data Items.

Completeness

The following tools are provided under the Completeness group:

-- Missing Full Extent Coverage: Opens the interface to run validations for data item completeness.

Summaries

The following tools are provided under the Summaries group:

-- Validation Report: Opens the interface to run all validations.

Management

The following tools are provided under the Management group:

-- Modify Editor Columns: Opens the interface to configure the display of the Validation Editor.

Route/LRS

This is a tool that is located on the HPMS Validations section of the Validations tab. The Route/LRS interface () provides options to validate route ID, geometry, and measure conformity. These tools run the source R&H route data and are useful in identifying Route ID and LRS data quality issues, such as duplicate Route IDs and measures out of range. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Network Name Dropdown	Select the Route Network (Statewide or LRS ID) to validate.
"Select the validation to run" Checkboxes	Select and run validations individually or all at once.
Open as PDF Button	Open a copy of the Edit Log table in a PDF format.
Open in Excel Button	Open a copy of the Edit Log table in an Excel format or save a copy of the Edit Log table in a local Excel file.

Validations

There are four types of Route/LRS Validations the user can run. These options will be located under the "Select the validation to run" section and will be recognizable in their checkbox form.

Route is Empty -- Checks to see if all route records contain a Route ID value.
Invalid Geometry Type -- Checks to see if all route geometries meet the route geometry requirements.
Duplicate Route ID -- Checks to see if all route records contain a unique Route ID value.
Invalid Measure -- Checks to see if all route record measures meet the route measure requirements.

To the right of each validation option is a question mark. This symbol will provide reference information on FHWA validations in a pop-up window.

Sample Sections and TOPs

This is a tool that is located on the HPMS Validations section of the Validations tab. The Sample Sections and TOPS Validations interface () provides options to validate samples and TOPS items (Functional System, Urban Code, Facility Type, Through Lanes, and AADT). This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
"Select the locations to check" Radio Button	Create a statewide report or a report for results at a specific location. If the user selects the Specific Location option, the Parish, System Code, Route Name, Direction, Feature Type, and Sequence # picklists become available. The LRS ID textbox also becomes available. The user can choose to select options from the picklists OR fill the LRS ID textbox.
"Select the validation to run" Options	Provide options for 5 different Sample Sections and TOPS validation reports.
Output Controls	Open the report in a PDF format or in a new pop-up window.
Columns Missing Link	Display a list of columns that are missing which prevent the reports from running. If all necessary columns are present in the selected Data table, this message will not appear. NOTE: The Verify Sample Coverage report is the only report that can be processed without all necessary columns.

Report Types

There are five report types found under the "Select the validation to run" section.

Verify Sample Length: Validates if sample sections meet the suggested length guidelines.
Verify Sample Coverage: Validates if sample sections contain the required data items for reporting. The report can also include data items that are optional for reporting if the user selects the "Include Optional Sample Panel Data Items" checkbox.
Check for Homogenous TOPS: Validates that the five TOPS items are homogeneous across entire sample sections.
Invalid Sample Location: Validates if sample sections are on valid route segments.
Verify TOPS Coverage: Validates if the five TOPS items are present on sample sections.

To the right of each validation option is a question mark. This symbol will provide an explanation of the function of each report directly in the interface. Users can consult this pop-up or the help guide for a reminder of each type's function.

Validation Edit Menu

The Sample Sections and TOPs validation checks have the Validation Edit Menu capability on each row of their reports. The Validation Edit Menu provides the user with the ability to correct validation errors. The interface will be populated with HPMS Data Items along the route corresponding to the selected record in the validation report. This interface provides four types of controls:

Control	Used To...
Validation Information	Display general information about the selected validation report (Sample Sections & TOPS, Import, Cross, or Coverage).
Edit Controls Table	View and edit Data Items along a given route; automatically scrolls to the record corresponding to the selected record in the validation report. Data Items are editable by clicking in the desired cell. Seven static columns are displayed in the Edit Controls table: Checkbox Selector, Error Icon (), County, Route ID, From Measure, To Measure, Sample ID. Other columns are based on Data Items.
Status Log	Keep a log of the changes made in the current instance and alert the user if a change corrected an issue or caused a validation error.
Save Controls (Save Changes/Discard Changes/Save to Source)	Save pending changes, discard changes made in the current session, or commit changes to original source data items.

Import, Cross, and Coverage

These are tools that are located on the HPMS Validations section of the Validations tab. The Import, Cross, and Coverage Validation interfaces (, , ) are used to run validation reports for one or more Data Items. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Location Controls	Create a statewide report or a report for results at a specific location. If the user selects the Specific Location option, the Parish, System Code, Route Name, Direction, Feature Type, and Sequence # picklists become available. The LRS ID textbox also becomes available. The user can choose to select options from the picklists OR fill the LRS ID textbox.
"Select the validation to run" Options	Provide the Data Items to include in the validation report; users can click the individual checkboxes, the "Select TOPS Data Items" link, or the "Select All" link.
Output Controls	Open the report in a PDF format or in a new pop-up window.

Validation Edit Menu

The Import, Cross, and Coverage validation checks have the Validation Edit Menu capability on each row of their reports. The Validation Edit Menu provides the user with the ability to correct validation errors. The interface will be populated with HPMS Data Items along the route corresponding to the selected record in the validation report. This interface provides four types of controls:

Control	Used To...
Validation Information	Display general information about the selected validation report (Sample Sections & TOPS, Import, Cross, or Coverage).
Edit Controls Table	View and edit Data Items along a given route; automatically scrolls to the record corresponding to the selected record in the validation report. Data Items are editable by clicking in the desired cell. Seven static columns are displayed in the Edit Controls table: Checkbox Selector, Error Icon (), County, Route ID, From Measure, To Measure, Sample ID. Other columns are based on Data Items.
Status Log	Keep a log of the changes made in the current instance and alert the user if a change corrected an issue or caused a validation error.
Save Controls (Save Changes/Discard Changes/Save to Source)	Save pending changes, discard changes made in the current session, or commit changes to original source data items.

Missing Full Extent Coverage

This is a tool that is located on the Completeness section of the Validations tab. The Missing Full Extent Coverage validation check () allows DOTs to check and confirm the completeness of data items beyond HPMS & FHWA requirements. The check will identify where specified data items do not have full coverage, null values, or dangles against routes. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
"Select the locations to check" Radio Button	Create a statewide report or a report for results at a specific location. If the user selects the Specific Location option, the Parish, System Code, Route Name, Direction, Feature Type, and Sequence # picklists become available. The LRS ID textbox also becomes available. The user can choose to select options from the picklists OR fill the textbox.
Data Items	Select the Data Items to validate by checking the checkboxes; the "Select All" link can also be used.
Output Controls	Open the report in a PDF format or in a new pop-up window.

Validation Report

This is a tool that is located on the Summaries section of the Validations tab. The Validation Report interface () is used to run all validations and generate a summary report. The summary report provides counts of all validations performed and hyperlinks to run individual reports in the Report window. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Network Name Dropdown	Select the Route Network to validate.
Validations Checkboxes	Include validation categories in the summary report.
Run Validation Summary Button	Run the selected validation categories and present the results in a Summary Report Window.

Modify Editor Columns

This is a tool that is located on the Management section of the Validations tab. The Modify Editor Columns tool () is used to add informational or decision-making columns to the HPMS Validation rules. These columns appear in conjunction with the columns used in executing the rule when editing data in the Validation Editor.

To add additional columns, the user must first select a Validation Type category from the picklist at the top of the interface. Then, the "Data Item" picklist below will be populated with the HPMS Items that have rules in the selected category. After selecting a Data Item, the required columns will be displayed, and additional columns can be added. While new columns can be added, the required columns cannot be deleted.

Informational columns are associated to a rule by clicking the “Add New Row” link and selecting the column to be associated. To delete a column, the user can select the checkbox by the desired row and click the “Delete Selected Rows” link.

Once columns are associated to the validation rule, the user can click the "Save Changes" button to store the columns. These columns will be displayed in the Validation Editor once the rule is validated.

Sample Adequacy Tab

The Sample Adequacy tab is used to create and manage sample data and to review TOPS data items. There are only two sections on this tab: Sample Adequacy and Maintenance.

Icons

Each icon on the tab leads to an interface. These icons/interfaces and their specific roles are listed below by section.

Sample Adequacy

The following tools are provided under the Sample Adequacy group:

-- Create TOPS: Opens the interface which is used to create a Table of Potential Samples (TOPS) data table based on the data in a HPMS Data Table. All other interfaces cannot be used until this step is performed.
-- Adjust TOPS: Opens the interface which is used to merge small segments together based on TOPS items.
-- Split Sample by TOPS: Opens the interface which is used to split a sample based on breaks in any of the TOPS data items (AADT, Facility Type, Functional Class, Through Lanes, and Urban Code).
-- Check Adequacy: Opens the interface which is used to view the number of unsampled TOPS sections, required samples, and current samples for each Sample Panel (Functional System, Volume Group, and Urban Area stratum).
-- Potential Samples: Opens the interface which is used to identify and add samples.
-- Expansion Factors: Opens the interface which is used to calculate and view expansion factors for Sample Panels.
-- Sample Risk Analysis: Opens the interface which is used to review current Samples Panels for samples that are at risk of moving to a higher or lower volume group.
-- Delete Samples: Open the interface which is used to review samples from the sample panel.

Maintenance

The following tools are provided under the Maintenance group:

-- Precision Level: Open the interface which is used to edit the Confidence Level and Precision Rate values used in the Check Adequacy interface.

Create TOPs

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Create TOPS interface () allows the user to generate a Table of Potential Samples (TOPS) data set. This is a necessary action that must occur before TOPS data can be reviewed. The output data set from this interface will include all TOPS items. This interface hosts the Data Table and Year dropdown controls, alongside the Create TOPS instigation button. If edits have occurred to the HPMS Data Table since the last creation of TOPS, the TOPS dataset will need to be recreated.

Control	Used To...
"using Data" Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Create TOPs for Year Dropdown	Select the year to use when viewing the selected interface.
Create TOPs Button	Instigates the creation of the new TOPs.

Adjust TOPs

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Adjust TOPS interface () is used to find small segments where the five TOPS data items do not align at exact measures. This interface is divided into three tabs: Summary, Detail, and Changes.

The Summary Tab is used to identify segments where TOPS data items do not align at exact measures. The Details Tab is used to compare the number of TOPS locations and number of required samples from the original TOPS set against the number of TOPS locations and number of required samples from the modified TOPS set per Functional System, Urban Code, and Volume Group stratum. The Changes tab is used to identify where the five TOPS data items do not align at exact measures and what their new values will be if the modified data set is saved. All three tabs (Summary, Detail, and Changes) host similar sections on their interfaces. Those sections are:

(1) Data Table Information

The Data Table Information section contains general information about the currently selected Data Table. This section hosts two controls.

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.

(2) Data To Adjust

The Data To Adjust section is used to define how segments will be merged. It has some important controls:

Control	Used To...
Statewide/Parish Radio Buttons	Adjust the data for the entire state or by individual parish.
Parent TOPS Data Item Precedence List	Specify the order for obtaining attribute values that will determine how small segments will be merged into adjacent segments (up/down arrows).
Measure Tolerance Textbox	Specify the maximum segment length to merge; includes feet/miles picklist.
View TOPS Changes Button (Summary Section ONLY)	Process the selected TOPS dataset by assessing which segments will merge based on the measure tolerance and precedence set.

(3) TOPS Changes Summary

This portion hosts a table, or a visual representation of the data generated from the Data Table and Data To Adjust inputs. Each table is slightly different depending on the chosen tab.

(4) Button Controls

The bottom of the interface hosts two button controls:

Control	Used To...
Update TOPS	Update the selected HPMS Data Table and TOPS table with the modified TOPS set.
Cancel	Exit out of Adjust TOPS without committing changes.

Adjust

Split Sample by TOPs

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Split Sample by TOPS interface () is used to find samples where the TOPS data items change along the sample. In this interface, sample sections can be split into multiple samples based on changes in the TOPS items. The interface also provides the ability to disassociate a section of sample based on the changes in TOPS items. The interface is divided into 3 sections: Data Table Information, Sample Data Grid, and Button Controls.

(1) Data Table Information

The Data Table Information section contains general information about the selected Data Table. This section hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
Break on AADT Change Checkbox	Determine whether AADT will be used as a criteria for splitting samples.
Check Samples Button	Execute the Split Sample by TOPS function and populate the Data Grid based on the Data Year, Data Table, and Break on AADT options.

(2) Sample Data Grid

The Sample Data Grid shows the results of the Check Samples function, indicating where TOPS item changes occur across a sample length. Segments then can be disassociated with a sample by using the checkboxes in the left-hand column. There are some controls found here:

Control	Used To...
Save To Source Checkbox	Enforce that changes to the HPMS Data Tables are also applied to the HPMS Samples data source.
Export to Excel Link	Export the current table to Excel format.

(3) Button Controls

There are two button controls that help users determine the saved/unsaved state of their inputted data. These controls are:

Control	Used To...
Save Changes	Disassociate marked segments and update the TOPS table.
Discard Changes	Exit out of Split Sample by TOPS without committing changes.

Check Adequacy

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Check Sample Adequacy interface () is used to view the number of unsampled TOPS, required samples, and current samples for each stratum (Functional System, Volume Group, and Urban Code grouping). This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
View Adequacy Button	Display the Check Sample Adequacy data for the selected HPMS Data Table.
Carets	Allow users to expand or collapse the stratum data.

Potential Samples

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Potential Samples interface () is used to identify locations where additional samples can be added to meet HPMS sample requirements. The interface provides a reviewable list of sections that includes unsampled TOPS sections and existing sample sections. The Potential Samples interface is divided into 5 sections: Data Table Information and Stratum Information, Data Completeness, Potential Sample Table, Sample Table, and Button Controls.

Potential

(1) Data Table Information and Stratum Information

The Data Table Information and Stratum Information section contains general information about the currently selected HPMS Data Table and the selected stratum. This section hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
Volume Group Dropdown	Select from which volume group to view samples.*
Functional System Dropdown	Select from which functional system to view samples.*
Urban Code Dropdown	Select from which Urban Code to view samples.*
Find Now Button	Find TOPS sections based on the Functional System, Urban Code, Volume Group, and HPMS Data Table selected.

*Auto-populated if redirected to this screen from Check Adequacy or Expansion Factors.

(2) Data Completeness

Beyond the filtering dropdowns, the interface also allows segments to be returned and ordered by the completeness of data. There are some controls provided here:

Control	Used To...
Percentage of Data Items with Values Checkbox	Order the segments by the completeness of the data.
AADT not within [#]% of Volume Group Upper/Lower Bounds Checkbox	Provide the option to show which segments do not meet an AADT value within a specified percentage.
Prioritize/Weight Data Items Link	Open the “Prioritize/Weight” interface where the user can specify the order of priority for data items.
Select Priority Method Radio Button	Allow users to set the priority method to "By Ordering" or "By Weighting."*
Double Arrows ()	Move data items to the top/end of the list.*
Single Arrow ()	Move data items up/down one row.*
Set Priority Button	Confirm the priority order of the data items.*

*All controls listed here are located on the Prioritize/Weight Data Items interface which is accessible through the Data Completeness section.

(3) Potential Sample Table

The Potential Sample Table will be populated with TOPS sections within the specified Volume Group, Functional System, and Urban Code selected. There is one control offered in this section:

Control	Used To...
Row Checkboxes	Add segments as a sample.

(4) Sample Table

The Sample Table displays the number of required samples, existing samples, samples that are needed to meet requirements (calculated by number of existing minus the number of required), and total amount of samples. This section will only be populated after the "Find Now" button is clicked. The "Selected" and "Total" Samples will increase or decrease as segments are selected as samples.

(5) Button Controls

The final section of this interface consists of four buttons. These buttons are:

Control	Used To...
Save to Source Checkbox	Enforce that changes applied to the HPMS Data Tables are also applied to the HPMS Samples data source.
Random Select	Open the Select Random Samples interface which will select segments at random based on user specifications.
Add Samples	Add samples to the stratum.
Cancel	Exit the Potential Samples interface without adding samples.

Number Colors

The Potential Sample Table hosts various numbers in its columns which can appear in different colors. The table below lists each color and its associated meaning.

Color	Indicates that...
Green	Segments are current samples.
Orange	Segments do not meet segment length requirements.
Red	Segments do not meet AADT criteria.
Blue	A link is present. This is only available in the Completeness column which shows how many data items exist along the sample section of the total data items collected. The link leads to a pop-up list showing which data items exist for the sample.

Expansion Factors

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Expansion Factors interface () is used to calculate expansion factors for each Functional System, Urban Code, and Volume Group stratum. This interface hosts these controls:

Controls	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
View Expansion Factors Button	View expansion factors previously calculated for the selected HPMS Data Table.
Calculate Expansion Factors Button	Calculate expansion factors for the selected HPMS Data Table.
Show Problematic Factors Only Checkbox	Filter expansion factors that do not exceed a maximum of 100.000, the FHWA recommended value.

Sample Risk Analysis

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Sample Risk Analysis interface () is used to review Functional System, Urban Code, and Volume Group stratums to locate samples that are near the upper or lower ranges of a volume group. The Sample Risk Analysis interface is divided into 4 sections: Data Table Information, Risk Analysis Parameters, Sample Risk Stratum Table, and Sample Risk Detail Table.

Sample

(1) Data Table Information

The Data Table Information section contains general information about the currently selected HPMS Data Table. This section hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.

(2) Risk Analysis Parameters

The Risk Analysis Parameters section provides the user with three search options, or controls:

Control	Used To...
At Risk Samples have AADT within % of Volume Group Upper/Lower Bounds	Identify AADT values within a range of the limits of a volume group that are at risk of moving to a different volume group; required.
Show Stratums with At Risk Samples comprising % of the Number of Required Samples	Filter stratums that do not have a certain percentage of at-risk samples; select a symbol from the picklist, then specify a percentage in the textbox.
Show Stratums with At Risk Samples	Filter stratums that do not have a certain number of at-risk samples; select a symbol from the picklist, then specify an amount in the textbox.
Perform Analysis Button	Instigate the HPMS data analysis; the Sample Risk Stratum Table will be populated with information based on the parameters specified.

(3) Sample Risk Stratum Table

The Sample Risk Stratum Table displays the number of required samples, provided samples, at-risk samples, and the percentage of at-risk samples to provided samples for each stratum based on the parameters set in the Risk Analysis Parameters. There are some important elements in this section:

Element	Used To...
Export to Excel Link	Display the information as a report.
Rows Returned Count	Display the number of rows in the table.

By clicking on a row in the Sample Risk Stratum Table, the row will highlight, and the Sample Risk Detail Table section will be populated with data.

(4) Sample Risk Detail Table

The Sample Risk Detail Table will remain blank until one of the rows in the Sample Risk Stratum Table is selected. When a row is selected, the Sample Risk Detail heading will change to reflect that selection, and the Sample Risk Detail Table will be populated with samples that can be found in the selected HPMS Data Table. Users can also opt to select the "Only Show At Risk Samples" checkbox which will exclude samples that are not at risk.

Delete Samples

This is a tool that is located on the Sample Adequacy section of the Sample Adequacy tab. The Delete Samples interface () will allow users to delete existing samples from the selected overlay table and source data. This interface hosts these controls:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
Find Samples Button	Populate the sample list based on the data table selected.
Samples Grid	Show a checkbox list of available samples associated with the current data table.
Save to Source Checkbox	Delete checked samples from the source when used in conjunction with the Save Changes button.
Save Changes Button	Delete checked samples from the overlay data table and from the source data when the Save to Source checkbox is checked.
Discard Changes Button	Discard changes to the sample list without saving.

Precision Level

This is a tool that is located on the Maintenance section of the Sample Adequacy tab. The Precision Level interface () is used to adjust confidence levels and precision rates for each Functional Class and Urban code combination. These values will then be used in the Check Adequacy interface when checking for adequate sampling among the Functional Class and Urban Code groupings. This interface hosts these controls:

Control	Used To...
Year Dropdown	Select the year to use when viewing the selected interface.
Editable Precision Grid	Modify confidence levels and precision rates.
Save Changes	Apply changes set in the Precision Grid to the HPMS Data Tables.
Discard Changes	Discard changes to the Precision Grid without saving.

Submittals Tab

The Submittals tab provides controls to create files for submittal to FHWA. There are four sections on this tab: Section Files, Summary Files, Catalog Files, and Maintenance.

Icons

Each icon on the tab leads to an interface. These icons/interfaces and their specific roles are listed below by section.

Section Files

The following tools are provided under the Section Files group:

-- ARNOLD Segments: Opens the interface which is used to generate route network output.
-- Road Segments: Opens the interface which is used to create files for the HPMS Submittal process.
-- Sample Limits: Opens the interface which is used to generate a text file of Samples Locations.

Summary Files

The following tools are provided under the Summary Files group:

-- County: Opens the interface which is used to edit and export county summary data.
-- Non-Federal Aid: Opens the interface which is used to edit and export non-federal aid summary data.

Catalog Files

The following tools are provided under the Catalog Files group:

-- Road Event Collection: Opens the interface which is used to update and create files for the HPMS Submittal process.
-- Road Estimates: Opens the interface which is used to view and edit estimate values.

Maintenance

The following tools are provided under the Maintenance group:

-- Population: Opens the interface which is used to view and edit estimated population values for urban areas.
-- Land: Opens the interface which is used to view and edit Land Area for urban areas.

ARONLD Segments

This is a tool that is located on the Section Files portion of the Submittals tab. The Arnold Segments interface () provides options to generate Route outputs in Shapefile, File Geodatabase, or text file format directly from the HPMS Manager product. This interface hosts these controls:

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Version Textbox	Show the selected version; cannot be edited.
File Type Dropdown	Select Shapefile, File Geodatabase, or text file as the output format.
Reference Network Radio Button	Choose between Statewide or LRS ID Routes.
Generate Files By Radio Button	Choose between outputting all routes or a certain route type.
Route Types Checkboxes	Select a specific route type (Interstate, US Route, State Route, or Local); only made available after the "Route Type" radio button is selected.

There are three file types that can be selected on this interface: Shapefile, File Geodatabase, and text file. Each file type produces specific fields in its outputs. The table below outlines the characteristic fields of the file types.

File Type	Fields
Shapefile and File Geodatabase	For R&H route data sources, the output will include routes from the selected R&H source network modified to include additional fields required by FHWA: BeginDate and StateID.
Text File	For file data sources, the output will include the following fields required by FHWA: BeginDate, StateID, RouteID, BeginPoint, EndPoint, and IsDiv.

Road Segments

This is a tool that is located on the Section Files portion of the Submittals tab. The Road Segments interface () provides options to create one or more section files for the various HPMS Data Items. The Road Segments interface is divided into 3 sections: Data Table Information, File Creation Options, and Tab Options.

(1) Data Table Information

The Data Table Information section contains general information about the currently selected Data Table. This section hosts one control.

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.

(2) File Creation Options

The File Creation section contains multiple options to specify how the Road Segment files are created. This section hosts these controls:

Control	Used To...
Create Individual Files Radio Button	Create individual section files based on grouping specified in the Group Files picklist.
Create One File Radio Button	Create one section file, instead of multiple, for all selected data.
Group Files By Dropdown	Group output files by Route Type, Date Item, or Route Type and Data Item.
Reference Network Radio Buttons	Output files using either the Statewide Routes or LRS ID Routes for reference.
Exclude Nulls Checkbox	Exclude sections where an HPMS Data Item does not exist from the generated section file.
Break on Sample Sections Checkbox	Split output segment data where samples exist.

(3) Tab Options

The Road Designations, Road Events, and Road Identifications internal tabs specify which routes/route types and data elements are to be included in the Road Segments output files. Each tab hosts these controls:

Control	Used To...
Route Box	Select one or more routes/route types to be included in the generated section file. To do this, the user must first select an option in the picklist: Route Type or Select Route(s). If Route Type is Chosen: Select one or more route type checkboxes manually or through the "Select All" link. If Select Route(s) is Chosen: Select routes by entering a complete Route LRS (Parish, System Code, Route Name, Direction, and Feature Type picklists), then clicking "Add Route >". Multiple routes can be added before generating the section files by following this pattern.
Data Items Box	Select one or more data items to be included in the generated section file.
Select All Link	Under Routes: Select all available Route Types for segment file creation. Under Data Items: Select all available HPMS Data Items for segment file creation.
Select TOPS Data Items Link	Select all TOPS data items for section file creation.
Create Section Files Button	Generate the section files based on selected criteria.

Sample Limits

This is a tool that is located on the Section Files portion of the Submittals tab. The Sample Limits interface () provides options to generate a text file of Sample Locations. This interface hosts these controls:

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Reference Network	Output files using either the Statewide Routes or LRS ID Routes for reference.
Generate Files By Radio Buttons and Route Type Checkboxes	Select which Samples will be included in the output table. Files can be generated for All Samples or for a subset of samples based on the selected Route Types.
Create Files Button	Generate the sample file based on selected criteria.

County

This is a tool that is located on the Summary Files section of the Submittals tab. The County Summaries interface () provides options to import, edit, and export county summary data. This interface hosts these controls:

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
Recalculate Button	Calculate the summary data using data from the HPMS overlay rather than a text file; rows selected for Override will not be recalculated.
Choose File Button	Import county summary data from a selected file.
Export to Pipe Delimited File Link	Export the county summary data to a pipe delimited file.
Save Changes Button	Save changes made to the county summary data.
Discard Changes Button	Discard changes made to the county summary data.

Non-Federal Aid

This is a tool that is located on the Summary Files section of the Submittals tab. The Non-Federal Aid Summaries interface () provides options to import, edit, and export non-federal aid summary data. This interface hosts these controls:

Control	Used To...
Data Table Dropdown	Select the HPMS Data Table to use when viewing the selected interface.
Year Dropdown	Select the year to use when viewing the selected interface.
Growth Rate % Textbox	Specify the growth rate percent to be applied to the non-federal aid summary data.
Apply Growth Button	Apply the specified growth rate to the non-federal aid summary data.
Recalculate Button	Calculate the summary data using data from the HPMS overlay rather than a text file; rows selected for Override will not be recalculated.
Rural - Local AADT Textbox	Enter the appropriate AADT values.
Rural - Minor Collector AADT Textbox	Enter the appropriate AADT values.
Small Urban - Local AADT Textbox	Enter the appropriate AADT values.
Choose File Button	Import non-federal aid summary data from a selected file.
Export to Pipe Delimited File Link	Export the non-federal aid summary data to a pipe delimited file.
Save Changes Button	Save changes applied to the non-federal aid summary data.
Discard Changes Button	Discard changes applied to the non-federal aid summary data.

Road Event Collection

This is a tool that is located on the Catalog Files section of the Submittals tab. The Road Event Collection interface () provides options to view and edit data collection metadata. This interface hosts these controls:

Control	Used To...
Year Dropdown	Select the year to use when viewing the selected interface.
Choose File Button	Import road event collection metadata from a selected file.
Export to Pipe Delimited File Link	Export the road event collection metadata to pipe delimited file.
Save Changes Button	Save changes to road event collection metadata.
Discard Changes Button	Discard changes to temporarily applied to road event collection metadata.

Road Estimates

This is a tool that is located on the Catalog Files section of the Submittals tab. The Road Estimates interface () provides options to view and edit estimate values. This interface hosts these controls:

Control	Used To...
Year Dropdown	Select the year to use when viewing the selected interface.
Choose File Button	Import estimate data from a file.
Export to Pipe Delimited File Link	Export estimate data to a pipe delimited file.
Save Changes Button	Save changes applied to estimate data.
Discard Changes Button	Discard changes temporarily applied to estimate data.

Population

This is a tool that is located on the Maintenance section of the Submittals tab. The Population interface () provides options to view and edit estimated population values for urban areas. This interface hosts these controls:

Control	Used To...
Year Dropdown	Select the year to use when viewing the selected interface.
State Population Textbox	Enter a Total State Population value.
Save Changes Button	Save changes applied to the estimated population data.
Discard Changes Button	Discard changes applied to the estimated population data.
Total Percent Textbox	View an automatically calculated sum of all Percent Distribution values.
Total Estimated Population Textbox	View an automatically calculated sum of all Estimated Population values for each urban area.

The Estimated Population data-- the information displayed on the table in the interface-- can be edited by selecting a Year and entering a State Population value. The data in the Percent Distribution column is used to calculate the Estimated Population for each urban area. If the user wishes to edit the Percent Distribution, they can select the cell in the desired row which will enable user updates.

Land

This is a tool that is located on the Maintenance section of the Submittals tab. The Land interface () provides options to view and edit Land Area for urban areas. This interface hosts five controls:

Control	Used To...
Year Dropdown	Select the year to use when viewing the selected interface.
Land Area (Sq. Miles) Column	Enter a new land area value for an entry row.
Save Changes Button	Save any changes made to the interface.
Discard Changes Button	Discard any changes made to the interface since the last save.
Total Land Area Textbox	View an automatically calculated sum of all Land Area values.

The Land Area data--the information displayed on the table in the interface-- can be edited by selecting a Year to modify. Then, the user can locate and select the desired cell under the Land Area (Sq. Miles) column which will enable user updates.

Reports Tab

The Reports tab is used to run preconfigured reports or to create custom reports. There are two sections on this tab: Reports and Status.

Icons

Each icon on the tab leads to an interface. These icons/interfaces and their specific roles are listed below by section.

Reports

The following tools are provided under the Reports group:

-- HPMS (Standard Reports): Opens the interface providing access to several preconfigured reports.
-- Advanced: Opens the interface which is used to create custom reports.

Status

The following tools are provided under the Status group:

-- HPMS Report Status: Opens the interface used to view and update the progress of the HPMS report.

HPMS or Standard Reports

This is a tool that is located on the Reports section of the Reports tab. The HPMS or Standard Reports interface () provides a list of preconfigured reports that the user can open in either a PDF or Excel format. The Standard Reports interface consists of 4 components: HPMS Data Dropdown, Report Selection Control, Filter Controls, and Output Controls.

(1) HPMS Data Dropdown

This section hosts one control:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.

(2) Report Selection Control

There are several preconfigured reports that can be accessed in this interface. These reports and their functions can be viewed in the table below.

Report	Lists the...
Certified Mileage by County	Mileage for Interstate, State, Local, and other routes, grouped by County.
Certified Mileage by County - Detailed	Mileage for Interstate, State, Local, and other routes, grouped by County, along with each route that is included in the group and the associated mileage.
Consistency Report	Length (in miles) of AADT, Through Lanes, Ownership, and Control, grouped by F_System.
Extent and Travel – Interstate by Route Number	Miles, Lane Miles, and Vehicle Miles for each Interstate route.
Extent and Travel – Interstate by Route Number (Comparison)	Miles, Lane Miles, and Vehicle Miles for each Interstate route for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Extent and Travel – Statewide Summary	Miles, Lane Miles, and Vehicle Miles by Small Urban, Rural, All Urbanized, and All Urban areas, grouped by Urban Code and F_System.
Extent and Travel – Statewide Summary (Comparison)	Miles, Lane Miles, and Vehicle Miles by Small Urban, Rural, All Urbanized, and All Urban areas, grouped by Urban Code and F_System for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Extent and Travel – Urbanized Summary	Miles, Lane Miles, and Vehicle Miles for each Urban Code, grouped by Urban Code and F_System.
Extent and Travel – Urbanized Summary (Comparison)	Miles, Lane Miles, and Vehicle Miles for each Urban Code, grouped by Urban Code and F_System for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Extent and Travel on the NHS	Miles, Lane Miles, and Vehicle Miles for each NHS type, grouped by NHS and F_System.
Extent and Travel on the NHS (Comparison)	Miles, Lane Miles, and Vehicle Miles for each NHS type, grouped by NHS and F_System for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Ownership Report	Mileage for each Ownership value, grouped by Ownership and F_System.

Users should note that the four comparison reports calculate the percent change in data between the selected year and the year prior to the selected year. If no data exists for the prior year, the option to run the non-comparison version of the report will be disabled.

(3) Filter Controls

The Filter Controls are used to return a specific result set when running a Standard Report. There are three available filters that can be applied to the reports: Parish, Roadway Type, and Number of Lanes. However, not all filters are applicable for all preconfigured report types. Below is a list of reports and their applicable filters; these filters are optional when running reports.

Report Type	Applicable Filters
Certified Mileage by County	N/A
Consistency Report	County, Roadway Type, Number of Lanes
Extent and Travel – Interstate by Route Number	County, Number of Lanes
Extent and Travel – Interstate by Route Number (Comparison)	County, Number of Lanes
Extent and Travel – Statewide Summary	N/A
Extent and Travel – Statewide Summary (Comparison)	N/A
Extent and Travel – Urbanized Summary	N/A
Extent and Travel – Urbanized Summary (Comparison)	N/A
Extent and Travel on the NHS	County, Route Type, Number of Lanes
Extent and Travel on the NHS (Comparison)	County, Route Type, Number of Lanes
Ownership Report	County

(4) Output Controls

The user can choose to run and open a report as a PDF or Excel sheet by using the buttons in this section.

HPMS

Advanced Reports

This is a tool that is located on the Reports section of the Reports tab. The Advanced Reports interface () provides a set of tools to create user defined queries and reports. The Advanced Reports interface consists of 7 components: Report Title, Data Dropdown, Precision and Identity Column Controls, Query Builder, Available Output Columns, Output Field Controls, and Selected Output Columns.

Advanced

(1) Report Title

The Report Title section allows users to specify a name for a set of search criteria for future recall. The user can enter an appropriate name that characterizes the selected search elements in the provided textbox.

(2) Data Dropdown

This section host one control:

Control	Used To...
Data Dropdown	Select the HPMS Data Table to use when viewing the selected interface.

(3) Precision and Identity Column Controls

There are two controls in this section. These two controls apply general settings to the output report.

Control	Used To...
Decimal Places Textbox	Set the maximum number of decimal places displayed for numeric values in the output report. Data with higher precision will be rounded to this specified decimal place.
Identity Columns Button	Automatically add a preconfigured set of columns to the Selected Output Columns list at the bottom of the form. Parish, Route ID, From Measure, and To Measure are added when the Identity Columns button is pressed.

(4) Query Builder

The Query Builder section is used to specify a combination of available data elements for creating a custom query and report. Below are some of the controls that aid this process.

Control	Used To...
Category Dropdown	Select the Business data types.
Item Dropdown	Select an Item refined by the Category selection.
Logical Dropdown	Provide query operators (equal, not equal, greater than, less than, etc.).
Value Dropdown	Select valid values for the data column or type in where set values do not exist.
Add/Item (+ and X) Buttons	Add additional criteria to the query (+) or remove criteria from a query (X). The remove option is not presented in the first row since the Advanced Report must have at least one search criteria.
Join Dropdown	Group or create conditional queries; used in conjunction with the parentheses controls.
Parentheses Textboxes	Group or create conditional queries; used in conjunction with the join control.
Reset Criteria Button	Clear all criteria and reset the form.
Enter SQL Button	Switch the query criteria window to a SQL entry window. In this mode, the Enter SQL button will change to “Enter Criteria” which can be used to switch back to the traditional query builder mode.
Verify SQL Button	Validate the entered SQL statement when in SQL entry mode.
Run Report Button	Execute the query based on the selected criteria. At least one output column must be selected to enable the Run Report button.

(5) Available Output Columns

The Available Output Columns list is used to select the data items to include in reports. Data items are categorized by functional area and can be expanded and collapsed using the "+" and "-" buttons. This list can be used in conjunction with the Output Field Controls and Selected Output Columns to customize the output of reports.

(6) Output Field Controls

The following controls are used in conjunction with the Available Output Columns list and Selected Output Columns list to customize report outputs.

Control	Used To...
Add Button	Add fields from the Available Output Columns list to the Selected Output Columns list.
Remove Button	Remove a field from the Selected Output Columns list.
Remove All Button	Remove all fields from the Selected Output Columns list.

(7) Selected Output Columns

The Selected Output Columns box is used to specify the data columns to be included in the output report. The box will be initially blank until columns are loaded using the Identity Column Control or the Output Field Controls. There are some controls offered in this section:

Control	Used To...
Sort Order Up/Down Arrows	Indicates that the currently selected item is in ascending (up arrow) or descending (down arrow) sort mode. This arrow is located in the actual table, and its current direction can be changed by clicking the arrow.
Reorder the Report Column Sequence: Double Up Arrows	Move a selected item to the top of the list.
Reorder the Report Column Sequence: Up Arrow	Move a selected item up one row in the list.
Reorder the Report Column Sequence: Down Arrow	Move a selected item down one row in the list.
Reorder the Report Column Sequence: Double Down Arrows	Move a selected item to the bottom of the list.
Save Query Button	Open a popup form used to save the query to the database.
Load Query Button	Reload previously saved queries from a pickable list.

Output

Once an Advanced Report query is executed, the results are displayed in a separate pop-up window. The Report Name, Search Criteria, Run Date, and Number of Records will be displayed at the top of the report. There are also some controls included at the top of the report. These are:

Control	Used To...
Map Symbol Color	Select from a picklist of colors to display results on a map.
Map	Toggle to the Map Frame and highlight the selected records in the desired map symbol color.
Print	Open the Windows Print Dialog to customize and print the results.
View in Excel	Prompt the user to open the file in Excel or save the results locally in Excel format.

HPMS Report Status

This is a tool that is located on the Status section of the Reports tab. The HPMS Report Status interface () provides options for tracking and updating the progress of the HPMS Submittal process. There are controls offered at the top of the interface.

Control	Used To...
Completion Status Dropdown	Select the intended Data Table.
Section File Submittal Status Link	Open the Section File Submittal Status interface.
Progress Bar	Show the percentage of complete items; this will update as items are as marked complete/incomplete.

Sections

The HPMS Report Status section contains 3 sections: Section Validations, Sample Validations, and Submittal Files.

(1) Section Validations

The Section Validations section is used to view the progress of the Route Import, Event Import, Coverage, and Cross Check validations. This section displays the number of invalidations found, along with the latest date each validation was performed.

(2) Sample Validations

The Sample Validations section is used to view the progress of the Sample Validations. This section displays the number of invalidations found for each Sample validation report, along with the latest date each validation was performed.

(3) Submittal Files

The Submittal Files section is used to view the progress of the various files required for HPMS Submittals. This section also contains a link to open the Section File Submittal Status interface.

Section File Submittal Status Interface

The user can click on the Section File Submittal Status link to open the Section File Submittal Status interface. This interface is used to track which Section Files have been created through the Section Files interfaces.

System Administration Tab

The System Administration tab is used to manage and maintain system administration functions for HPMS Manager. There are 3 sections on this tab: Maintenance, Configuration, and Utilities.

Icons

Each icon on the tab, except Flush Cache, leads to an interface. These icons/interfaces and their specific roles are listed below by section.

Maintenance

The following tools are provided under the Maintenance group:

-- Code Lists: Opens the interface which is used to edit application code lists.
-- Users: Opens the interface which is used to add and edit user information and privileges.
-- Versions: Opens the interface which is used to remove hanging locks and delete versions not properly deleted when saved to source.
-- Flush Cache: Removes the data on the cache and refreshes the page.

Configuration

The following tools are provided under the Configuration group:

-- Data Sources: Opens the interface which is used to create and manage data sources.
-- Data Tables: Opens the interface which is used to create and manage data tables.
-- System: Opens the interface which is used to edit configuration values used throughout HPMS Manager.

Utilities

The following tools are provided under the Utilities group:

-- Merge Files: Opens the interface which is used to merge multiple files into one output file.
-- Export Data: Opens the interface which is used to extract data from the HPMS Overlay table to a variety of other formats.

Code Lists

This is a tool that is located on the Maintenance section of the System Administration tab. The Code List interface () is used to edit the various code lists used throughout the HPMS Manager application. System Administration permissions are required to view this interface. The Code List interface consists of 3 components: Code List Controls, Editor Fields, and Button Controls.

Code

(1) Code List Controls

There are some controls offered in the Code List Maintenance interface.

Control	Used To...
Code List Dropdown	Select the code list to view and edit.
Code List Table	Display all valid values in the currently selected code list and edit codes and their display order.
Reorder the code items: Double Up Arrows	Move a selected code item to the top of the list.
Reorder the code items: Up Arrow	Move a selected code item up one row in the list.
Reorder the code items: Down Arrow	Move a selected code item down one row in the list.
Reorder the code items: Double Down Arrows	Move a selected code item to the bottom of the list.

(2) Editor Fields

The Editor Fields provide options to edit the value and name of a selected code item. Selected items will also have additional fields available in this section which are specific to the item. If a user wishes to mark a code as obsolete, they can click the Obsolete Code checkbox which will prevent the code item from appearing in picklists throughout the application.

(3) Button Controls

The following button controls are provided in the Code List Maintenance interface:

Control	Used To...
Add New Code Button	Add a new code to the selected code list.
Sort Codes A-Z Button	Alphabetically sort the codes for the selected code list.
Save Changes Button	Save the changes for the selected code list.
Discard Changes Button	Discard the changes applied to the selected code list.

Users

This is a tool that is located on the Maintenance section of the System Administration tab. The User Maintenance interface () provides options to add new users, edit user information, and edit data privileges. System Administration permissions are required to view this interface. The User Maintenance interface consists of 4 components: User Type Control, User Table, Edit Fields, and Button Controls.

LA HPMS Users.png

(1) User Type Control

The User Type Control is used to switch the view of user types in the user table. There are three view types:

Active -- Only view active users in the user table.
Inactive -- Only view inactive users in the user table.
All -- View both active and inactive users in the user table.

(2) User Table

The User Table provides a list of users included in the selected User Type (active, inactive, or all). The last name search box can be used to jump to a given user. To delete a user, select the checkbox on the first column of the table for the desired row/entry, then click the “Delete Selected” link.

(3) Edit Fields

The Edit Fields section provides options to edit general information about the currently selected user. There are eight fields in this section:

Field	Used To...
Last Name Textbox	Edit the last name of the selected user; required.
First Name Textbox	Edit the first name of the selected user; required.
Username Textbox	Edit the username of the selected user; required.
Email Address Textbox	Edit the email address of the selected user.
User Status Dropdown	Edit the status of the selected user.
Edit Permissions Link	Open a pop-up menu to edit the permissions of the currently selected user.
Permissions Table	View the list of permissions assigned to the selected user.
Data Privileges Link	Open a pop-up menu to edit the data privileges of the currently selected user. A summary of settings is shown in the data privileges table, listed as Yes or No respectively for Save to Overlay and Save to Source options.

(4) Button Controls

The following button controls are provided in the User Maintenance interface:

Control	Used To...
Add New User Button	Add a new user to the application.
Save Changes Button	Save changes applied to the selected user.
Discard Changes Button	Discard changes applied in the current session.

Edit Permissions/Data Privileges Pop-ups

The Edit Permissions pop-up allows user permissions, or the allocated abilities of the user, to be added or removed. The Data Privileges pop-up lists the HPMS items and measures privileges that can be assigned to a user.

Edit Permissions

There are two tables on this pop-up interface: Available and Current. The Available table lists the permissions that can be assigned to a user while the Current table lists the permissions already assigned to a user. This interface also hosts some controls.

Control	Used To...
Add (>) Button	Add permissions from the Available permissions list to the Current permissions list.
Remove (<) Button	Remove permissions from the Current permissions list.

All permissions listed in the two tables have titles which indicate their role. For example, the Advanced Reports permission gives access to the Advanced Reports interface found in the Reports tab.

Data Privileges

This interface consists of a table with three columns: Data Item, Can Save to Overlay, and Can Save to Source. It also hosts some controls.

Control	Used To...
Save to Overlay Checkbox	Edit and save items to an HPMS Overlay table.
Save to Source Checkbox	Edit and save items to source data layers.
Select All Overlay/Deselect All Overlay Link	Select or deselect all save to overlay privileges for the selected user.
Select All Source/Deselect All Source Link	Select or deselect all save to source privileges for the selected user.

Versions

This is a tool that is located on the Maintenance section of the System Administration tab. The Versions interface () is used to manage temporary versions and file locks obtained by the HPMS Manager application. System Administration permissions are required to view this interface. This interface hosts three controls.

Control	Used To...
Versions Table	Display a list of temporary versions created by HPMS Manager that have not been posted.
Locks Table	Feature class locks that are currently held by the temporary versions.
Delete Selected Button	Delete versions checked in the Version display list and release associated locks.

Data Sources

This is a tool that is located on the Configuration section of the System Administration tab. The Data Source interface () is used to edit data sources using the dropdown control and to add data sources using the Add New button. HPMS Manager supports multiple data source types. The Connection Parameters section of the interface will reflect relevant information for the selected data source type (File, Database (SQL Server or Oracle), Map Service, and Access Database).

File Data Source

In the File Data Source Type, the user can load or delete files. To take these actions, the interface provides these controls.

Control	Used To...
Data Source Type Dropdown	Select the data source type.
Show/Add Files Button	View the files located in the selected file share. Clicking this button will open the Files Found interface.
Select All to Delete Link	Select all files for deletion.
Select All to Load/Reload Link	Select all files to be loaded/reloaded into the database.
View Log Link	View details from the last files loaded for the selected data source.
Shortcut Dropdown	Enter a shortcut for the data source.
Delete Source Button	Delete the selected data source.
Save Changes Button	Save changes to the selected data source and loaded or reloaded files.
Discard Changes Button	Discard changes temporarily applied to the selected data source.
Verify Source Button	Verify the database entry.
Files Found Interface	Select the files to add to the data source, upload more files to the file share, or open existing files in the file share; appears when clicking the “Show/Add Files” button.

Data Tables

This is a tool that is located on the Configuration section of the System Administration tab. The Data Tables interface () is used to create and manage the HPMS overlay data tables that will be used throughout the application. This interface serves 3 core purposes:

Data Table Creation -- Used to create new Data Tables.
Data Table Management -- Used to edit and delete previously created Data Tables.
Data Table Definition -- Used to alter the definition of a selected Data Table.

Data Table Creation

To create a new data table, the user can select the "Create New" button in the Data Tables interface. The resulting pop-up is divided into four sections:

Basic Information Fields -- Used to enter general information needed to create a Data Table.
Temporal Information Controls -- Used to specify if the Data Table will retrieve temporal data.
Setup Information Controls -- Used to copy a Data table definition from a previously created Data Table.
Button Controls -- Used to create or cancel the creation of a Data Table.

There are some controls hosted on the "Create New" interface.

Control	Section	Used To...
Name Textbox	Basic Information Fields	Enter a name for the Data Table; required.
Description Textbox	Basic Information Fields	Enter a description for the Data Table.
Year Textbox	Basic Information Fields	Specify the year of the Data Table; required.
Type Dropdown	Basic Information Fields	Specify that the Type for the Data Table is HPMS Manager.
Get Latest Data Radio Button	Temporal Information Controls	Only retrieve the latest data for the Data Table.
Filter Date Radio Button	Temporal Information Controls	Apply a date filter to the Data Table.
Create New Radio Button	Setup Information Controls	Create a new Data table definition.
Copy From Radio Button	Setup Information Controls	Copy the Data Table definition from a previously created Data Table. Use the dropdown provided to select the desired Data table.
Create Button	Button Controls	Create a new Data table based on the information provided.
Cancel Button	Button Controls	Close the Create New interface without creating a new Data table.

Data Tables Management

The Data Table Management functionality is concentrated in the static controls and the Data Table Information tab controls. All controls are described below.

Controls	Location	Used To...
Data Table Dropdown	Static Controls	Select the Data table to view/edit.
Set Official Button	Static Controls	Set the Data Table as Official; opens the Set Official Data Table window.
Populate/Refresh Data Table Button	Static Controls	Populate/refresh the Data table information.
Delete Data Table Button	Static Controls	Delete the Data Table displayed.
Save Changes Button	Static Controls	Save changes applied in the Data Table configuration interface.
Discard Changes Button	Static Controls	Discard changes temporarily applied in the Data Table configuration interface.
Save Data Table as Source Button	Static Controls	Save the current Data Table as a data source table for new overlays. This is useful for creating new overlays where a previous overlay may be the most current representation of specific data items.
Name Textbox	Data Table Information (Information box)	Enter a name for the data table; required.
Year Textbox	Data Table Information (Information box)	Specify the year of the data table; required.
Description Textbox	Data Table Information (Information box)	Enter a description for the data table.
Filtered as of Date Textbox	Data Table Information (Information box)	Specify a date filter for the data table; calendar selection also available.
Data Table Type Dropdown	Data Table Information (Information box)	Specify a HPMS Data Table Type.
Created On Message	Data Table Information (Statistics box)	Show the creation date of the selected data table; automatically filled.
Refreshed On Message	Data Table Information (Statistics box)	Show the date the selected data table was last populated/refreshed; automatically filled.
Approved for Guest Checkbox	Data Table Information (Statistics box)	Determine if guest users can use the selected data table throughout the application.
Is Locked Checkbox	Data Table Information (Statistics box)	Restrict or “lock” other users from editing or deleting a data table.
Locked By Message	Data Table Information (Statistics box)	Show which user has locked the data table.
Email Locked Users Link	Data Table Information (Statistics box)	Send an email to the “Locked By” users.

Data Table Definition

The Data Table Definition functionality is concentrated in the Required Items and Attributes tabs.

Required Items Tab

The Required Items must be defined before an overlay can be populated or refreshed. There are two mandatory items required by HPMS Manager: Routes and Sample Section Locations. Each of these items have their own internal tabs on the Required Items tab. Once an overlay is populated, an icon will appear next to the title of the tab, indicating the status of the imported data. Each time the overlay is populated or refreshed, this icon will be updated to reflect the import status. There are three possible statuses:

Icon	Type	Description
	Success	Indicates that no errors were encountered while importing data for the item.
	Warning	Indicates that a non-fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.
	Fatal Error	Indicates that a fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.

This Route internal tab is used to specify the route network to use when retrieving route data. There are two data source types in this tab: R&H or Non-R&H. The table below outlines the controls provided for each data source option.

Control	Data Source Type	Used To...
"Is R&H" Checkbox	N/A	Specify whether the Route data is a Roads and Highways (R&H) data source.
Map Service Dropdown	R&H	Select the map service that the route network data is located in.
Network Name Dropdown	R&H	Select the route network; auto-filled after selecting a Map Service.
Version Dropdown	R&H	Select the Geodatabase version; auto-filled after selecting a Map Service.
Filters Textbox	R&H	Enter a valid SQL filter the Populate process uses to filter a subset of data from the selected route network.
Data Source Dropdown	Non-R&H	Select the data source for route network data; required.
Table Name Dropdown	Non-R&H	Select the table where the route data is located; auto-filled once a data source is selected.
Route ID Dropdown	Non-R&H	Specify the Route ID field for the route data.
From Measure Dropdown	Non-R&H	Specify the From Measure field for the route data.
To Measure Dropdown	Non-R&H	Specify the To Measure field for the route data.
From Date Dropdown	Non-R&H	Specify the From Date field when applying temporal data filters. This field is only required if the selected data table contains temporal data.
To Date Dropdown	Non-R&H	Specify the To Date field when applying temporal data filters. This field is only required if the selected data table contains temporal data.
Filters Textbox	Non-R&H	Enter a valid SQL filter the Populate process uses to filter a subset of data from the selected table.

The Sample Section Locations internal tab is used to enter the data source for sample data. Both data source types (R&H or Non-R&H) are on this interface as well. The table below outlines the controls provided for each data source option.

Control	Data Source Type	Used To...
"Is R&H" Checkbox	N/A	Specify whether the Route data is a Roads and Highways (R&H) data source.
Version Dropdown	R&H	Specify which Geodatabase version to use for the sample data; required.
Event Name Dropdown	R&H	Specify which event contains the sample data information; required.
Source Column Dropdown	R&H	Specify which column to use for the Sample ID field in the HPMS Data table; required.*
Filters Textbox	R&H	Enter a SQL filter that can be used to filter a subset of data from the selected event table.
Data Source Dropdown	Non-R&H	Select the data source for the sample data; required.
Table Name Dropdown	Non-R&H	Specify the table that contains sample data; required.*
Column Dropdown	Non-R&H	Specify the Sample ID field in the HPMS Data table; required.*
Route ID Dropdown	Non-R&H	Specify the Route ID field for the sample data; required.*
From Measure Dropdown	Non-R&H	Specify the From Measure field for the sample data; required.*
To Measure Dropdown	Non-R&H	Specify the To Measure field for the sample data; required.*
From Date Dropdown	Non-R&H	Specify the From Date field when applying temporal data filters.*
To Date Dropdown	Non-R&H	Specify To Date field when applying temporal data filters.*
Filters Textbox	Non-R&H	Enter a valid SQL filter that can be used to retrieve a subset of data from the selected table.
Allow Save to Source Checkbox	Non-R&H	Permit the update of sample section source data for database source types.

*Once a table is selected, the dropdown will be filled with a list of columns found in the selected table.

Attributes Tab

The Attributes tab is used to define the sources and parameters for each of the HPMS data items. There are four internal tabs on this interface:

R&H Events -- Used to add HPMS Data Items to the selected HPMS Data table using a registered Roads and Highways event as the source data.
Non-R&H Events -- Used to add HPMS Data Items to the selected HPMS Data table from a file or database table source.
Parent/Child Events -- Used to add data items where the source data has a parent data item.
Derived Events -- Used to add derived data items.

There are some static controls on the Attributes tab.

Control	Used To...
Version Dropdown	Specify the Geodatabase version to use when retrieving event data; required.
Delete Selected Rows Link	Delete all selected items from the data items table.
Copy Selected Rows Link	Copy the selected items from the data items table.
Add New Row Link	Add a new row to the data items table.
Attributes Complete Message	Track the number of HPMS Data items added to the selected HPMS Data table.

Similar to the other Data Table Definitions tab, Required Items, the Attributes tab hosts status columns in each of their internal tabs. Once an overlay is populated, an icon will appear beside the associated data item, indicating the status of the imported data. Each time the overlay is populated or refreshed, this icon will be updated to reflect the import status of the tab data. There are three possible statuses:

Icon	Type	Description
	Success	Indicates that no errors were encountered while importing data for the item.
	Warning	Indicates that a non-fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.
	Fatal Error	Indicates that a fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.

Data items can be deleted from any table on the Attributes tab by clicking the checkbox to the left of each desired item or using the checkbox in the table header to select all data items for deletion. Once items are selected, the user can click the “Delete All Selected” link to permanently delete the items from the Data table definition.

System

This is a tool that is located on the Configuration section of the System Administration tab. The System interface () provides options to change configuration values used by HPMS Manager. Parameters-- items under the "Name" column-- are editable by clicking in the desired row in the Value column. Once a row has been selected, the value field will become editable. Then, the user can edit the desired parameter by typing into the given textbox. The save and discard changes buttons are made available in this interface to confirm or deny the changes to the configuration parameters. The following parameters are modifiable:

Parameter	Description
Advanced Reports Show Statistics	Displays the report statistics for Advanced Reports.
Advanced Reports Table Length	Number of rows displayed in an Advanced Reports table.
Excel Format	Format to use when creating Excel files (XLSX or XLS).
Max Invalid Records Displayed	Maximum number of invalid records to be displayed in the Invalid Data Report interface.
Report Cell Background Color 1	Background color for the table cells of HPMS Validation and Standard Report tables.
Report Cell Background Color 2	Background color for the table cells of HPMS Validation and Standard Report tables.
Report Header Background Color	Background color for the header of HPMS Validation and Standard Report tables.
Report Header Text Color	Text color for the header of HPMS Validation and Standard Report tables.
Report Left Column Text Color	Left column text color of the table cells of HPMS Validation and Standard Report tables.
Report Subheader Text Color	Sub-header text color of the table cells of HPMS Validation and Standard Report tables.

Merge Files

This is a tool that is located on the Utilities section of the System Administration tab. The Merge Files tool () allows users to import and merge multiple files into one file. Files must have the same header information to be merged. If the user selects the Merge Files icon, a new form will open that will allow users to browse to a folder location and select multiple files to merge. The user can specify the output file name in the Merged File Name textbox. When the Merge Files button is pressed, the application will check that all files have the same header information, including column names and separating characters. Once validated, the output will be downloaded in the browser where the user can either open the file or save it to a location.

Export Data

This is a tool that is located on the Utilities section of the System Administration tab. The Export Data interface () provides a menu and parameters to extract data from the HPMS Overlay table and convert them into a variety of formats for use in other applications. The following controls are provided in the Export Data interface:

Control	Used To...
Data Table Dropdown	Select the HPMS Data table to be used when creating the Export Files.
Precision Textbox	Specify the decimal precision that will be used to export measure data.
File Type Dropdown	Specify the output file format.
Exclude Nulls Checkbox	Specify whether records with NULL values for the specified data item will be included in the output file.
Reference Network Radio Button	Specify the route network on which all output files will be based.
Create Individual Files Radio Button (File Grouping Option)	Create individual export files for each selected HPMS Data Item. Files will be saved in a downloadable zip file.
Create One File Radio Button (File Grouping Option)	Create one export file containing the data for all selected HPMS Data Items.
Data Items Checkboxes	Select individual or groups of files for export.
Select/Deselect All Link	Select/deselect all available HPMS Data Items for export file creation.
Export Data Button	Generate the export files based on selected criteria.

HPMS Workflow Articles

Workflow

The workflow is the steps taken in the HPMS Manager application for actions-based processes. These steps help the user understand the progression of the application, essential tasks, and covered actions on the software. There are seven steps in the HPMS Manager workflow. It is very common for this workflow, or its particular steps, to be executed many times during the submittal process for any given year.

Build a Data Table -- HPMS Manager combines and segments all necessary data into a single table with direction from the user for processing validations, edits, and reporting.
Populate Report -- This report allows users to identify issues with the source data used in the Data Table creation prior to use in other systems and processes.
Validations -- This functionality allows the user to validate data in a Data Table according to very specific and detailed FHWA requirements.
Edit Data -- This functionality allows the user to address and correct data issues found as a result of Validations.
Sample Adequacy -- HPMS Manager’s Sample Adequacy module allows the user to verify that the data is adequately sampled and to address issues of over or under sampling.
Standard Reports -- This functionality allows the user to verify and report certified public road mileage through preconfigured reports.
Submittals and Summaries -- This functionality allows the user to create submittal and summary files to submit to the FHWA.

The LADOTD workflow portion of the Help Guide has a section dedicated to each step above. However, the Populate Report step will be combined with the Build a Data Table step due to their close association; articles for both steps will be located under the "Build a Data Table" section.

Build a Data Table

Data Source Configuration

In order to begin the first step in the workflow-- Build a Data Table-- the user must initiate a Data Source Configuration. The Data Source Configuration interface allows the user to tackle three actions: adding new data sources, editing previously created data sources, and deleting data sources that no longer exist or are no longer relevant. To initialize the Data Source Configuration, the user can follow these general steps.

First, open the Data Source Configuration interface by selecting the Data Sources menu item in the System Administration tab.

Next, select the "Add New" button. This will trigger the picklist beneath the button to become available for selection.

Then, select a data source type in the Data Source Type picklist. The user can choose between File, Database (SQL Server or Oracle), Map Service, and Access Database here. The content in the connection parameters section, or the information underneath this picklist, is dependent upon the selected data source type.

Finally, fill out the connection parameters.

As indicated above, each Data Source Type has different connection parameters. The breakdown of these parameters and the specific steps toward Data Source Configuration is outlined in other articles which are identifiable by the Data Source Type (File, Database (SQL Server or Oracle), Map Service, and Access Database).

Managing Data Sources

File Data Sources

All information found here occurs in the Data Sources interface on the System Administration tab.

When a user is trying to initiate a Data Source Configuration, they can select the “File” option from the Data Source Type picklist. This selection will cause the interface to resemble the image below if files exist in the system; if not, the table containing the Delete, File Name, Type, Separation Chart, and Load/Reload columns will be empty.

To load files into the data source, follow these steps:

Click the “Show/Add Files” button to open up the “Files Found” interface. If the desired files already exist in the file share, skip steps 2-4.
Click the “Choose Files” button. A file manager will open prompting the user to add files from the local computer.
Select one or more files to add. Hold down the control (Ctrl) key while clicking on a file to select multiple files.
After selecting all the desired files, click the “Open” button. HPMS Manager will then add the selected files to the application’s file share.
To finish uploading the files to the data source, check the checkbox to the left of the file and click the “Add Files to Source” button.
For files that require separating characters, such as CSV files or pipe delimited files, edit the Separating Characters column by clicking into the cell to change the value to ensure proper file parsing and loading. Skip this step if the file does not require a separating character.
Select which files to load/reload into the data source by selecting the checkbox located in the “Load/Reload” column.
After selecting the desired file(s), click the “Save Changes” button to load/reload files.

The images below visually display this process.

To delete a file from the data source, follow these steps:

Select which files to delete by checking the checkbox in the “Delete” column. If you would like to delete all files in the data source, click the “Select All to Delete” link instead.
After selecting the desired files, click the “Save Changes” button.

Database Data Sources

All information found here occurs in the Data Sources interface on the System Administration tab.

When a user is trying to initiate a Data Source Configuration, they can select one of the Database options from the Data Source Type picklist. The Database options are “SQL Server” and “Oracle.” Below is an example of how the interface would look if the user selected the "SQL Server" option. However, the "Oracle" option has the same fields available.

LADOTD Data Source Configuration (2).png

To create a Database data source, follow these steps:

Fill out the database connection fields. The Server, User Name, Password, Database, and Shortcut parameters are required for managing a database source type.
- Server -- Name of the server.
- User Name -- Username for the database.
- Password -- Password used to connect to the database.
- Database -- Name of the database.
- Shortcut -- Name of the data source. This is the name that will appear in all data source picklists.
After all parameters have a value, click the “Verify Source” button in the lower left corner of the interface to verify the connection to the specified database.
If the connection is valid, click the “Save Changes” button.

Here is a visual of these steps:

LA HPMS Workflow Image Update (1).png

Map Server Data Sources

All information found here occurs in the Data Sources interface on the System Administration tab.

When a user is trying to initiate a Data Source Configuration, they can select the "Map Server" option from the Data Source Type picklist. This will trigger the following interface to appear:

LADOTD Data Source Configuration (4).png

To create a map service data source, follow these steps:

Fill out the map service parameter fields. The Service Directory, Service, Service Type, Include in Map Legend, and Shortcut parameters are required when managing a map service data source type.
- Service Directory -- URL of the map server.
- Service -- Name of the map service.
- Service Type -- Type of service (MapServer, FeatureServer, etc.).
- Include in Map Legend -- Include events in the selected map service in the map legend.
- Shortcut -- Name of the data source. This is the name that will appear in all data source picklists.
After all parameters have a value, click the “Verify Source” button to verify the connection to the map service.
If the connection is valid, click the “Save Changes” button.

Here is a visual of these steps:

LA HPMS Workflow Image Update (2).png

Access Data Sources

All information found here occurs in the Data Sources interface on the System Administration tab.

When a user is trying to initiate a Data Source Configuration, they can select the "Access" option from the Data Source Type picklist. Then, the following interface will appear:

LADOTD Data Source Configuration (5).png

To create an "Access" data source, follow these steps:

Click the "Show/Add Files" to open the "Files Found" interface. If the desired file already exists in the file share, skip steps 2 & 3.
Click the "Choose Files" button. A file manager will open prompting the user to add files from the local computer. Only one Access file can be added to an Access data source.
After selecting the desired file, click on the "Open" button. The file will then appear in the file share.
To finish uploading the file to the data source, select the checkbox to the left of the file and click the "Add Files to Source" button.
Then, fill out the "Shortcut" parameter. Use the Shortcut field to specify a shortcut name for the data source. This shortcut will appear in all data source picklists.
After all parameters have a value, click the "Verify Source" button to verify the connection to the Access file.
If the connection is valid, click the "Save Changes" button.

Here is a visual of these steps:

Data Tables Configuration

After configuring data sources, the user can create a data table in the Data Table Configuration interface. In order to access this interface, the user must locate the System Administration tab and navigate to the Data Tables Configuration icon. The image below shows this icon in a red box.

Users can create and manage data tables used throughout the application in the Data Table Configuration interface. This interface provides the user with three core functions in the workflow:

Data Table Creation -- Used to create new data tables.
Data Table Definition – Used to edit the information and the definition of the selected data table; concentrated in the Data Table Information, Required Items, and Attributes tabs.
Data Table Population – Used to populate the selected data table with the data specified in Data Table Definition.

Data Table Creation

The Data Table Configuration interface allows the user to create data tables. To create a new data table, the user can follow these steps:

(1) First, click the "Create New" button on the Data Table Configuration interface to trigger the appearance of the Create New interface.

(2) Then, fill out the necessary and desired fields.

Field	Required? (Y/N)	Description
Name	Yes	Textbox used to enter a name for the data table.
Description	No	Textbox used to enter a description for the data table.
Year	Yes	Textbox used to specify the year of the data table.
Type	No	Picklist used to specify a HPMS Data Table Type.
Temporal Date	No	Single selection "bubble" used to specify if the data table will retrieve temporal data.
Setup Table	No	Single selection "bubble" used to copy a data table definition from a previously created data table.

(3) Finally, click the “Create” button at the bottom of the interface after all desired fields have a value.

Data Table Definition

The Data Table Configuration interface provides options to edit or manage general information and the definition of the selected data table using the three tabs provided: Data Table Information, Required Items, and Attributes.

Data Table Information

The first tab, Data Table Information, is used to edit the general information of the selected data table. This tab will be initially displayed when the user selects the Data Table Configuration icon, and it contains many fields, such as the Name and Year textboxes.

Required Items

The second tab on the Data Tables Configuration interface, Required Items, allows the user to specify the location of the source data for routes and sample data. In order to accomplish this goal, the user can select the desired Data Table in the top left picklist on the interface. This tab also possesses its own internal tabs-- Routes and Sample Section Locations-- to enter the appropriate information.

Required Items Tab

Users can utilize the Routes tab to enter in the source of the route network. There are two options for sources here: R&H and Non-R&H.

Required Items -- R&H Source

To add a R&H route source, the user must follow these steps.

Check the “Is R&H” checkbox at the top left of the interface, under the internal tabs. The fields will then change to support R&H route sources.
Fill out the Map Service, Network Name, Version, and Filters fields.
After filling in the desired fields, click the “Save Changes” button at the bottom of the interface.

Required Items -- Non-R&H Source

To add a Non-R&H route source, the user must follow these steps.

Uncheck the “Is R&H” checkbox at the top left of the interface, under the internal tabs. The fields will then change to support Non-R&H route sources.
Fill out the Data Source Dropdown, Table Name, Route ID, From Measure, To Measure, From Date, To Date, and Filters fields.
After filling in the desired fields, click the “Save Changes” button at the bottom of the interface.

Sample Section Locations Tab

The Sample Section Tab can be used to specify the source data for samples. Similar to the Routes tab, the fields on this tab change based on the R&H or Non-R&H status.

Sample Section Locations -- R&H Source

To add a R&H sample source, the user must follow these steps.

Check the “Is R&H” checkbox at the top left of the interface, under the internal tabs. The fields will then change to support a R&H registered event.
Fill out the Map Service, Version, Event Name, Source, HPMS Data Table, and Filters fields.
After filling in the desired fields, click the “Save Changes” button at the bottom of the interface.

Sample Section Locations -- Non-R&H Source

To add a Non-R&H sample source, the user must follow these steps.

Uncheck the “Is R&H” checkbox at the top left of the interface, under the internal tabs. The fields will change to support a Non-R&H event.
Fill out the Data Source, Table Name, Column, Route ID, From Measure, To Measure, From Date, To Date, and Filters fields. The user can select the Allow Save to Source checkbox if desired.
After filling in the desired fields, click the “Save Changes” button at the bottom of the interface.

Attributes

The third tab on the Data Tables Configuration interface, Attributes, can be used to define the sources and parameters for each of the HPMS data items. Similar to the Required Items tab, the Attributes Tab also has internal tabs; these four tabs are R&H Events, Non-R&H Events, Parent/Child Events, and Derived Events. Each of these tabs has specific guidelines attached to them on how to properly add data items.

R&H Events, Non-R&H Events, Parent/Child Events Tabs

The R&H Events tab is used to add data items from a registered Roads and Highways event, the Non-R&H Events tab from a file or database table source, and the Parent/Child Events tab from a parent data item. In order to add a R&H, Non-R&H, or Parent/Child data item, users must follow the steps below.

Click the “Add New Row” hyperlink to add a blank row. To copy an existing row, check the checkbox located to the left of the data item. After selecting the desired rows, click the “Copy Selected Rows” link. All fields are populated except the Item Name column.
Fill out the parameters. Edit a parameter by clicking into the desired cell. A picklist or textbox will appear relative to the column being edited.
After adding the desired data items, click the “Save Changes” button at the bottom of the interface.

Parameters

The second step on adding a data item from the R&H, Non-R&H, Parent/Child Events tabs includes either editing or adding certain parameters. Those parameters, and which tab they are listed under, are outlined in the table.

Parameter	Internal Tab	Description
Item Name	R&H, Non-R&H, Parent/Child	Used to specify a data item.
Map Service	R&H	Used to specify which map service the R&H event is located in.
Version	R&H	Used to specify which geodatabase version to use for the data item.
Event	R&H	Used to specify which R&H event to use for the selected data item.
Column	R&H, Non-R&H, Parent/Child	Used to specify the source column to use for the selected data item.
Filters	R&H, Non-R&H, Parent/Child	Used to enter a SQL filter the Populate/Population process uses to retrieve a subset of data from the from the selected event, table, or file.
Comment	R&H, Non-R&H, Parent/Child	Used to specify a field to use for comments in submittal files for the selected data item.
Data Source	Non-R&H, Parent/Child	Used to specify the data source containing the table or file for the selected data item.

Table/File Name	Non-R&H, Parent/Child	Used to specify the table or file containing the data for the selected data item. Populated once a data source is selected.
Route ID	Non-R&H	Used to specify the Route ID field when importing data.
From Measure	Non-R&H	Used to specify the From Measure field when importing data.
To Measure	Non-R&H	Used to specify the To Measure field when importing data.
From Date	Non-R&H	Used to specify the From Date field when importing data.
To Date	Non-R&H	Used to specify the To Date field when importing data.
Parent Item	Parent/Child	Used to specify which data item is the parent item.
Parent Column	Parent/Child	Used to specify the parent column to use for the selected data item.

Derived Events Tabs

The Derived Events tab is used to add derived data items. For users to add a Derived Events data item, they must follow the steps below.

Click the “Add New Row” link to add a blank row. To copy an existing row, check the checkbox located to the left of the data item. After selecting the desired rows, click the “Copy Selected Rows” link. All fields are populated except the Item Name column.
Select the desired data item by clicking into Item Name column. Use this column to specify which derived data item to add to the data table. The Description column is auto populated with the Item Description of a data item.
After adding the desired data items, click the “Save Changes” button at the bottom of the interface.

Delete Data Item

If a user wishes to delete a data item from any of the four tabs, they can follow these steps:

Select the checkbox located in the first column of each desired item or use the checkbox in the table header to select all data items for deletion.
After selecting the desired items, click the “Delete All Selected” hyperlink to permanently delete the items from the data table definition.

Data Table Population

Once the user has configured all the routes, samples, and desired HPMS data items, they can populate the data table by clicking the "Populate Data Table" button found on the Data Table Information, Required Items, or Attributes tab. These tabs are located under the Data Tables Configuration icon on the System Administration ribbon. After the populate process is complete, the button will change to display the message, "Refresh Data Table."

At any point, the user can reload the data in the table with the latest updates by clicking the "Refresh Data Table" button. This population process only adds data items that are complete (i.e., all required fields have values on the data table). The "Attributes Complete Message/Count" will appear below the Attributes tab's table to display the number of data items that are complete, and it will appear in the data table after the populate/refresh process.

In the image below, the Refresh Data Table button and the Attributes Complete Message/Count are indicated in red boxes to show their position and format on the interface.

After populating the data table, the user should check the Required Items and Attributes tabs to see if an error occurred during the populate process. On the Required Items tab, an icon will appear in the tab header. On the Attributes tab, an icon will appear in the "Status" column (shown above). The three statuses and their icons are described below.

Icon	Type	Description
	Success	Indicates that no errors were encountered while importing data for the item.
	Warning	Indicates that a non-fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.
	Fatal Error	Indicates that a fatal error occurred while importing data for the item. Hovering over the icon will display details of the error.

Populate Report

After the successful completion of the Data Table Population, the user can access the populate report by clicking the "View Populate Report" hyperlink. This link can be accessed by following these steps:

LA HPMS Check Populate Report.png

The Populate Report interface shows all warnings and errors found while populating. The populate process attempts to correct warnings and remove errors on import if possible. However, the user can also review and resolve warnings in the Edit Log/Save to Source interfaces under the Edit module. Any errors found during the populate process will need to be fixed in the source data (Data Table Configuration), and the data table will need to be repopulated. The user can repeat this process until the data in this report is at an acceptable level.

Validations

After Building a Data Table, the user can move on to the Validations step in the workflow. The Validations tab provides tools to run a series of different validation checks on routes and HPMS data items before submitting data. These checks could indicate where incorrect or missing values are located or if a route has an invalid geometry. Five Validation Checks are embedded into the LADOTD HPMS application to aid with the validation step of the workflow. These can be located by going to the Validations module and selecting any of the icons contained within the "HPMS Validations" section.

Validation Rules Maintenance

The Validation Rules Maintenance interface is an important element of the validations step of the HPMS workflow. This interface outlines the parameters of certain data items, implementing rules that will trigger errors if these item types do not comply. Users can locate this interface by following the steps below. The user can confirm that they are in the correct location by looking at the top of the interface (on the last step) to view the title.

LA HPMS Validation Rules Maintenance.png

The rules for Import, Cross, and Coverage validations are found in this interface. To fill the interface with information from a specific rule, the user can select the desired category in the “Validation Rules Type” picklist at the top of the interface. Then, the Validation Rules List table will be populated with the rules pertaining to that type.

Edit a Rule

In order to edit a rule, the user must locate the "Edit Rules" interface on the Edit tab. In this interface, the user must first select the rule type they wish to edit (Import, Coverage, or Cross) from the picklist at the top of the Validation Rules Maintenance Interface. Then, the user can follow the steps below. Most steps will be associated with a table number (first, second, third, or fourth) which corresponds to the table placement as it is listed on the interface.

(1) Select a data item in the Data Item column (First Table).

(2) Edit the failure message by clicking into the textbox and adding a message. If an HPMS Data Item does not have a rule for the selected Rule Type, the failure message will appear blank (First Table).

(3) After selecting a data item, use the Validation Rules Definition table to add a criterion by clicking the “+” button on the lefthand side of the table. The plus sign will be located on the "+/-" column on the last, empty row (Second Table).

(4) Use the Left Condition table to edit the Left Condition column in the Validation Rule Definition table (Third Table).

NOTE: The user can utilize the Left Condition table to select a Condition Type in the Type column (Data Item, Value, and Overlay Column), edit a Condition Value (picklist or textbox), add an arithmetic operation in the Arithmetic column (operation between 2+ conditions), add a condition (left “+” button), and remove a condition (left “X“ button).

(5) Use the Right Condition table to edit the Right Condition column in the Validation Rule Definition table (Fourth Table).

NOTE: The user can utilize the Right Condition table to select a Condition Type in the Type column (Data Item, Value, Code list, and Overlay Column), edit a Condition Value (picklist or textbox), add an arithmetic operation in the Arithmetic column (operation between 2+ conditions), add a condition (left “+” button), and remove a condition (left “X“ button).

(6) Use the Join and Parentheses options to group or create condition rule criteria (Second Table).

(7) Use the Validation Rule Definition table to delete a criterion if desired (Second Table).

NOTE: The user can delete a criterion by clicking the “X” button on the lefthand side of the table.

(8) After editing the desired rule, click the “Save Changes” button.

Add New & Delete Rules

To add a new validation rule, click the “Add Rule” link, then follow the steps above to edit the new rule. To delete a validation rule, check the checkbox to the left of the desired rule. After selecting the desired rules, click the “Delete All Selected” link. Click the “Save Changes” button to save changes.

Validation Checks

As specified on the Validations article, users can find missing and/or invalid values for a selected data table by utilizing Validation Checks. There are five Validation Checks in the LADOTD HPMS application:

Icon	Name	Description
	Route/LRS	Use this interface to run route ID, geometry, and measure validations.
	Sample Sections and TOPS	Use this interface to run validations for Sample Sections and TOPS items.
	Import	Use this interface to run import validations for the HPMS Data Items.
	Cross	Use this interface to run cross validations for the HPMS Data Items.
	Coverage	Use this interface to run coverage validations for the HPMS Data Items.

Route/LRS Validation Check

The Route/LRS interface provides options to validate route ID, geometry, and measure conformity. These validations use the R&H data source defined in the data table to identify Route ID and LRS data quality issues, such as duplicate Route IDs and measures. To access the Route/LRS Validations interface, users can select the Route/LRS icon in the Validations tab. To run a Route/LRS validation report:

Click the Validations tab on the main interface, then select the first icon on this ribbon, "Route/LRS." This leads to a pop-up window.
Select a “Reference Network” by clicking the designated circle, either Statewide Routes or LRS ID Routes, to use to perform the validation checks.
Select "Validations to Run" by checking the checkboxes to the left of the desired validation or by clicking the “Select All” hyperlink if the user wishes to view all validations.
Click the “Open as PDF” button to open the report in PDF format or the “Open as Excel” button to open the report in Excel format.

Each resulting report will contain the following columns:

Column	Description
Route ID	The route location of the segment.
From Measure	The beginning point of the segment.
To Measure	The ending point of the segment.
Data Values	The data values for the failed validation checks.
Failed Validation	The validation type that failed.

Sample Sections and TOPS Validation Check

The Sample Sections and TOPS Validations interface provides options to validate samples and TOPS items (Functional System, Urban Code, Facility Type, Through Lanes, and AADT). To access this interface, users can select the Sample Sections and TOPS menu item in the Validations tab. To run a Samples Sections and TOPS validation report:

Select the “Specific Location” bubble under the "Select the location(s) to check" header and fill out the associated filters (picklists/textbox) to run the validation checks on a subset of locations; the user can also select the “Statewide” bubble instead to run the checks on the full extent of data.
Select the desired validation by clicking on its name in the “Select the validation to run” section. Only one validation can be run at a time.
Click the “Open as PDF” button to open the report in PDF format or the “Open Report Window” button to open the report in a new pop-up window. Report Windows offer additional functionality, such as mapping the results or opening the results in Excel Format.

Each report will contain the following columns:

Column	Description
Sample ID	The Sample Section ID of the segment.
Parish	The Parish location of the segment.
Route ID	The route location of the segment.
From Measure	The beginning point of the segment.
To Measure	The ending point of the segment.
Problem Feature	The feature that failed the validation check.
Data Values	The values of the feature that failed the validation check.
Failed Validation	The failure message of the validation check (configured in the Edit Rules interface).
(Pencil Icon)	The Validation Editing menu icon.

Additional functions are also included at the top of the report:

Function	Description
Map Symbol Color	Picklist of colors to display the results on a map.
Map	Toggles to the Map Frame and highlights the selected records in the selected map symbol color.
Print	Opens the Windows Print Dialog to customize and print the results.
View in Excel	Prompts the user to open the file in Excel or save the results locally in Excel format.

Import/Cross/Coverage Validation Check

While the Import, Cross, and Coverage validation checks are separate checks the user can run, they follow the same pattern for instigation and possess the same report columns; therefore, all three can be discussed simultaneously. The Import, Cross, and Coverage Validation interfaces are used to run the corresponding validations for one or more data items. To access this interface, users can select the Import, Cross, or Coverage Validation icon on the ribbon in the Validation tab. To run an Import, Cross, or Coverage validation report:

Select the “Specific Location” bubble under the "Select the location(s) to check" header and fill out the associated filters (picklists/textbox) to run the validation checks on a subset of locations; the user can also select the “Statewide” bubble instead to run the checks on the full extent of data.
Select data items to include in the validation report. The user can do this by checking the checkboxes located to the left of each desired data item under the "Select the validation(s) to run" header. The “Select All” hyperlink can also be used to select all data items, or the “Select TOPS Data Items” hyperlink to select all TOPS data items if available.
Click the “Open as PDF” button to open the report in PDF format or the “Open Report Window” button to open the report in a new popup window. Report Windows offer additional functionality, such as mapping the results or opening the results in Excel Format.

All resulting Import, Cross, and Coverage validation reports will contain the following columns:

Column	Description
Parish	The Parish location of the segment.
Route ID	The route location of the segment.
From Measure	The beginning point of the segment.
To Measure	The ending point of the segment.
Problem Feature	The feature that failed the validation check.
Data Values	The value(s) of the feature that failed the validation check.
Failed Validation	The failure message of the validation check (configured in the Edit Rules interface).
(Pencil Icon)	The Validation Editing menu icon.

Additional functions are also included at the top of the report:

Function	Description
Map Symbol Color	Picklist of colors to display the results on a map.
Map	Toggles to the Map Frame and highlights the selected records in the selected map symbol color.
Print	Opens the Windows Print Dialog to customize and print the results.
View in Excel	Prompts the user to open the file in Excel or save the results locally in Excel format.

Edit Data

One of the main abilities HPMS Manager provides is the ability to edit data in order to address and correct data issues found as a result of Validations. Users can take on this ability through the Validation Edit Menu and Basic Editor. Users can also view and save edits previously applied to the data table through the application. More detailed information is given below in a table format which summarizes the function and icons of both editing interfaces.

Icon	Name	Description
	Validation Edit Menu	Edit data and correct validation errors.
	Basic Editor	Search, create, and update data in the data table.

Validation Edit Menu

During the validation process, the user can edit data and correct validation errors using the Validation Edit Menu. When the user opens the Validation Edit Menu, a window similar to the below will appear.

Open the Interface

In order to open the Validation Edit Menu, the user must follow these steps:

Fill out the appropriate validations check interface (Sample Sections & TOPS, Import, Cross, or Coverage) and select the "Open Report Window" button.
Select the pencil icon () on the desired data item row in the resulting pop-up. Once selected, a window will appear with a table of data items along the route corresponding to the selected rule in the validation report.

There are seven static columns displayed in the Validation Edit Menu table: checkbox selector, validation error (), Parish, Route ID, From Measure, To Measure, Section Length, and Sample ID. The table also contains additional columns for other data items; these columns are determined by the validation report from which the Validation Edit Menu was opened.

Correct Errors

The user can correct validation errors in the Validation Edit Menu table. The steps below will guide you through the correcting process.

Find a row where a caution icon () appears in the Validation Error column or use the “Next” and “Previous” links above the table to navigate to the next or previous validation error.
Hover the cursor over the caution icon () to view a description of the validation error.
Edit data items by clicking into the desired cell. Depending on the item, a picklist or a text field will appear. As updates occur, rows will be checked again for validation errors. If no errors exist for the row, the error icon will be removed. If an error is created for a row, an error icon will appear in the Error Icon column.
After fixing the validation errors, click the “Save Changes” button. To commit changes to the source data, check the “Save data to source” checkbox before saving changes.

NOTE: Currently, the Route ID, From Measure, and To Measure fields are not editable through the Validation Edit Menu. Additionally, adding and deleting a row is disabled at this time.

Basic Editor

The Basic Editor tool, an essential part of the Edit Data step of the workflow, can be accessed through the Edit tab. The user can search for a route using the Select from Map or Enter Route options. After finding the desired route, the user can implement these actions:

Select an Edit Group. Basic Editor contains six static columns (checkbox selector, validation error, Parish, Route ID, From Measure, and To Measure). The Edit Groups picklist can be used to add additional columns to view and edit. If none of the groups listed have the desired columns to add, users can create a new Edit Group by opening the Edit Groups interface.
Map the desired route. On the Basic Editor interface, users can click the “Find” button near the top right of the window to retrieve and map the desired route.
Edit a data item. By clicking into the desired cell, users can edit data items. Depending on the data item, a picklist or textbox will appear in this editable cell. As updates occur, rows will be checked again for validation errors. If a new value fails a validation check, an Error icon will appear in the validation error column. Hovering over the error column will display a description of the error.
Add a row. Users can click the “Add Row” link to add a new row to the Basic Editor table. New rows will appear at the top of the table.
Delete a row. To delete a row, users can check the checkboxes to the left of the desired segments. After selecting the desired segments, the user can click the “Delete Selected Rows” link.

Changes cannot be saved if gaps or overlaps are created by deleting/adding a new row or if any validation errors were created during the editing process.

Query for a Route

There are two ways to query for a route in Basic Editor: (1) Select From Map and (2) Enter Route.

(1) Select From Map

The Select From Map option can be used to open the Basic Editor from a map-selected location. To query for a route using this option, the user can navigate to the Select From Map icon on the Edit module. This icon will be the first on the menu ribbon. Then, the user can use their mouse to zoom to the desired area on the map and click on that location. This will provide them with a list of routes near the clicked location. If the "Select From Map" icon becomes unclicked during this process, it is probably due to efforts to zoom on the map that occurred after clicking this icon; the user can simply reselect this icon to enable it once more. Finally, the user can select the intended route from the list and click the Basic Editor link at the base of the resulting location pop-up box.

(2) Enter Route

The user can also manually enter the desired route’s information. In order to accomplish this, the user must locate the Basic Editor icon on the Edit module. This is the second icon on the menu ribbon, and it rests beside the Select From Map icon. Once the Basic Editor icon is selected, a pop-up window will appear at the base of the map interface. From this pop-up window, the user can select the "Enter Route" button which will trigger the appearance of a new pop-up window. The user must fill the fields in the window that are listed in the table below. When all fields have a value, the user can click the "Select Route" button.

Field	Description
Parish	Used to specify a parish boundary.
System Code	Used to specify a route system.
Route Name	Used to specify a route name.
Direction	Used to specify inventory direction.
Feature Type	Used to specify feature type.
Sequence number	Used to specify sequence number.

Edit Groups

The Edit Groups interface is used to create, save, or delete groupings of columns designated for editing. The Basic Editor uses Edit Groups to add additional columns for viewing and editing in its interface. The Edit Groups interface can be accessed in two ways. For one, users can navigate to the Edit tab; under the Management section on the menu ribbon, the "Edit Groups" icon can be found and selected. Alternatively, users can click the “Select Columns…” option in the Edit Group picklist in the Basic Editor interface. To find the Basic Editor interface, the user can go to the Edit tab and select the "Basic Editor" icon under the Data Editing section.

To edit or create groups, users can follow these six steps once they are in the Edit Groups interface:

Select a value in the "Edit Group" picklist to edit an existing group or click the "Add New" button to create a new group.
Use the "+" and "-" buttons on the left side of the "Available Columns" box to find the desired data items. When the interface shows a plus sign, the data items for each major category are hidden; when the interface shows a minus sign, the data items are expanded on the interface.
To add data items to the "Selected Columns" table, click on a data item to select it. Then, click the "Add >" button. To quickly add TOPS items, click the "Select TOPS" link.
To remove data items from the “Selected Columns table, click on the data items to select them. Then, click the "< Remove" button. To remove all data items, click the "<< Remove All" button. To quickly remove TOPS Items, click the "Deselect TOPS" link.
Edit the name in the "Group Name" textbox if needed.
After adding the desired data items/columns, click the "Save Changes" button. The Edit Groups interface requires at least one column and a name in order to save.

Data Cleaning Icons

The Data Cleaning section of the Edit tab provides tools to fix issues found in the Roads and Highways events, such as gaps in the route segments or measure offsets that exist between data items. The following interfaces are provided to assist in fixing events:

Icon	Name	Used to Find and Fix...
	Fix Event Gaps	Roads and Highways events
	Snap Events to Route	Measure offsets between routes and events
	Fix Event Offsets	Measure offsets between events
	Fix Event Overlaps	Overlapping events

Fix Event Gaps

The Fix Event Gaps interface is used to find and fix gaps that exist in the source data of a Roads and Highways event. Users can open the Fix Event Gaps interface by selecting the icon on the Data Cleaning section of the Edit menu. Once the user has entered this interface, they will have the ability to locate and correct the apparent gaps by following these steps:

Fill in all filters (Event, Statewide/Parish, System Types, and Route Types) to find gaps within the specified parameters.
After filling all filters, click the “Find Gaps” button to the right of the filters. The table on the lower half of the interface will then update to reflect the gaps found in the event data.
Resolve gaps in the table by clicking into a cell under the event column and filling in an appropriate value.
After resolving the desired segments, click the “Save Changes” button at the bottom of the interface to update the data table. To update the source data, check the “Save data to source” before saving changes.

Snap Events to Route

The Snap Events to Route interface is used to find and fix micro gaps or overlaps that exist between a Roads and Highways event and the ends of routes. When changes are saved, edits are automatically applied to the R&H source event data defined by the information in the selected data table. Users can open the Snap Events to Route interface by selecting the icon in the Data Cleaning section on the Edit menu. Once the user has entered this interface, they will have the ability to locate and correct the apparent micro gaps/overlaps by following these steps:

Fill in all filters (Event, System Types, and Route Types) to find offsets within the specified parameters.
After filling all filters, click the “Find Events” button to the right of the filters. The table on the lower half of the interface will then update to reflect the offsets found between events and routes.
Snap events to the route endpoints by selecting the checkbox on the desired row.
After selecting the desired segments, click the “Save Changes” button at the bottom of the interface to update the data.

Fix Event Offsets

The Fix Event Offsets interface is used to find measure offsets that exist between data items. Users can open the Fix Event Offsets interface by selecting the icon in the Data Cleaning section on the Edit menu. Once the user has entered this interface, they will have the ability to locate and correct the measure offsets by following these steps:

Fill in all filters (Statewide/Parish, Event to Fix, Event to Compare, and Tolerance) to find offsets within the specified parameters.
After filling all filters, click the “Find Offsets” button to the right of the filters. The table on the lower half of the interface will then update to reflect measure differences between the selected event and the controlled event. The measures of the “Event to Fix” item will appear in bold if they do not match the “Event to Compare” measures.
Update measures by checking the checkbox in the first column of the table. By checking the checkbox, the "Event to Fix" measures will be updated to reflect the corresponding "Event to Compare" measures once Save Changes is selected.
After selecting the desired segments, click the “Save Changes” button at the bottom of the interface to update the measures. To save the updates to the source data, check the “Save data to source” checkbox before saving changes.

Fix Event Overlaps

The Fix Event Overlaps interface is used to find and fix overlaps that exist within a Roads and Highways event. When changes are saved, edits are automatically applied to the R&H source event data defined by the information in the selected data table. Users can open the Fix Event Overlaps interface by selecting the icon in the Data Cleaning section on the Edit menu. Once the user has entered this interface, they will have the ability to locate and correct the overlaps by following these steps:

Fill all filters (Event, System Types, and Route Types) to find gaps within the specified parameters.
After filling all filters, click the “Find Overlaps” button to the right of the filters. The table on the lower half of the interface will then update to reflect the overlaps found in the event data.
Resolve overlaps in the table by clicking on the “Edit Source” link on the desired row. This will open the source event data for the selected segment.
Edit the source by clicking into the desired cell. A picklist or textbox will appear relative to the column which will grant the user editing capabilities. Delete segments by checking the checkbox in the first column of the table, then click the “Delete Selected Rows” link.
After resolving the overlaps, click the “Save Changes” button at the bottom of the interface to update the source data.

Edit Log

The Edit Log interface provides a viewable history of the changes made to each data table. To open the Edit Log interface, the user must select the icon on the Management section of the Edit tab. Once the user has entered this interface, they can view the changes by following these steps:

Select the desired data table using the Data Table picklist. This picklist will simply be labeled "Data" on the interface.
Apply the desired filters (Refresh Date, User, Data Item, Parish, System Code, and Route Name).
Click the “Filter” button to the right of the filters to apply the chosen options. The table in the lower portion of the interface will then update to reflect the new filters.
Click the “Retrieve Next 20,000 Records” link to view the next 20,000 edits or click the “Retrieve Previous 20,000 Records” link to view the previous 20,000 edits.
Click the “Open as PDF” button at the base of the interface to view the results in PDF format or the “Open in Excel” button to view the results in Excel format.

Save Data to Source

The Save Data to Source interface provides the option to save data edits made to a data table back to the source data. If edits made in the Validation Edit Menu and Basic Editor failed to save to the source data, another attempt can be made in this interface. The user can open the Save Data to Source interface by selecting the icon in the Management section of the Edit tab. Once the user has entered this interface, they can locate and save edits by following these steps:

Select the desired data table in the Data Table picklist. This picklist will simply be labeled "Data" on the interface.
Apply the desired filters (User, Data Item, Parish, System Code, Route Name, Show Import Edits, Only show edits user can save to source, and R&H Radio Buttons).
Click the “Filter” button to the right of the filters to apply the chosen options.
To save edits to the source data, select the desired rows by clicking the checkbox in the first column or select all rows by clicking the checkbox in the table header.
After selecting the desired rows, click the “Save Data to Source” button at the base of the interface.

Sample Adequacy

The Sample Adequacy tab is used to identify and create potential samples, as well as manage existing ones. This tab is the sole focus of the fifth step of the workflow which allows the user to verify that the data is adequately sampled and to address issues of over or under sampling. HPMS Manager offers seven interfaces to assist in reporting samples.

Icon	Name	Used To...
	Create TOPS	Create a Table of Potential Samples (TOPS) based on the data in a HPMS Data Table. All other interfaces in the Sample Adequacy tab cannot be used until this step is performed.
	Adjust TOPS	Merge small segments together based on TOPS items.
	Check Adequacy	View the number of unsampled TOPS sections, required samples, and current samples for each Sample Panel (Functional System, Volume Group, & Urban Area stratum).
	Potential Samples	Identify and add samples to the Sample Panel.
	Expansion Factors	Calculate and view expansion factors for Sample Panels.
	Sample Risk Analysis	Review current Samples Panels for samples that are at risk of moving to a higher or lower volume group.
	Delete Samples	Review and remove samples from the Sample Panel.

There is one additional icon on the Sample Adequacy tab; this icon is the sole item in the Maintenance section. It is:

Icon	Name	Used To...
	Precision Level	View and update the confidence level and precision rate of each Functional System and Urban Code combination.

Create TOPs

The user must generate a Table of Potential Samples (TOPS) data set using the Create TOPS interface before creating and managing samples in other interfaces. This tab primarily functions as a means to break down records and categorize them into Sample Panels/Stratums, which are defined by Volume Group, Functional System, and Urban Code. The user can open this essential interface by selecting the icon in the Sample Adequacy tab. To Create a TOPS data set or sample table, the user can follow these steps:

Select the desired data table year in the “Create TOPS for Year” dropdown. After selecting a year, the “using Data” dropdown to its direct right will be populated with Data Tables related to that year.
Select the desired data table in the “using Data” dropdown.
After selecting both items, click the “Create TOPS” button.

The samples table that is generated will possess the TOPS data items, including Functional System, Facility Type, Urban Code, AADT, Through Lanes for all Federal-aid highways, and all other public roads not classified as local roads or rural minor collectors. If edits are made outside of the Sample Adequacy tab, such as in Basic Editor or the Validation Edit Menu, this process will need to be ran again to have the latest data present.

Adjust TOPs

After using the Create TOPS interface, the user can move on to utilize other interfaces in the Sample Adequacy tab. The Adjust TOPS icon () directly follows the Create TOPS icon on the menu ribbon. This interface is used to find small segments where TOPS data items do not align at exact measures and merge them. In order to accomplish this goal, the interface possesses three action tabs: Summary, Detail, and Changes.

Summary Tab

The Summary tab is used to identify small segments, with a maximum length specified by the user, where TOPS data items do not align at exact measures and merge them. To find the small segments, users can follow these steps:

Select an option in the "Data to Adjust" bubble selection area. Select “Statewide” to locate small segments in the full TOPS data set or “Parish” to locate small segments in a subset of data based on the selected Parish in the picklist.
Set the data item precedence by selecting the order for obtaining attribute values in the "Parent TOPS Data Item Precedence" list. This will determine how small segments will be merged into adjacent segments. To change the order, click the desired data item and use the up or down arrows.
Enter a maximum segment length, or measure tolerance, in the “Measure Tolerance” text box. The measure tolerance can be in units of feet or miles which is selected in the picklist.
After giving the desired options a value, click the “View TOPS Changes” button.

After running the changes, the “TOPS Changes Summary” section of the interface will display the overall number of required sample changes from the original TOPS data and the modified TOPS data based on the length. There are three view-only textboxes and a table in this portion. The “Total Samples Required Before Changes” textbox shows the original, overall number of samples. The “Total Samples Required After Changes” textbox shows the overall number of samples that would need to be reported if the small segments were merged. The “Difference in Samples Required” textbox shows the numerical difference in the original and modified TOPS data. The “Stratums with Required Sample Changes” table below the textboxes breaks down this difference value and shows which stratums would be affected by the changes. These numbers can appear negative, indicating less required samples, or positive, indicating the stratum grew to require more samples.

Detail Tab

The Details Tab is used to compare the number of TOPS locations and required samples from the original TOPS set against the modified TOPS set per Functional System, Urban Code, and Volume Group stratum.

Rows

When the rows of the table are collapsed ( caret), they will only show general information about the Functional Systems and their changes. In this state, the rows will simply state "[#] Urban Areas with changes to Number of TOPS/Required Samples" across from the associated Functional System title. However, the rows can expand to reveal the specific Urban Area entries and their changes if the user clicks the caret.

In the expanded state, the first row of numbers in the Urban Area entry contains the original TOPS set, and the second rows contains the modified TOPS set. If a number is shown in blue in the second row, this indicates that a change has occurred in the number of TOPS locations. If a number is shown in purple, this indicates that a change has occurred in the number of samples required per volume group.

Changes Tab

The Changes tab is used to identify where the five TOPS data items do not align at exact measures and what their new values will be if the modified data set is saved. The table contains the TOPS data item, Route ID, adjusted measures (from/to), original measures (from/to), old value, and adjusted value columns. The modified measures will appear in bold in either the “Adjust From Measure” or “Adjust To Measure” column depending on which measure needs to be updated.

Saving Adjust TOPS

The modified data set can be saved on any of the three tabs (Summary, Detail, or Changes). In order to save the updated data, the user must select the "Update TOPS" button at the base of the interface. This selection will update the data in the samples/TOPS tables and the selected data table. The user can also commit the modified data to the original source by selecting the "Save to Source" checkbox before clicking "Update TOPS."

Check Adequacy

After using the Create TOPS interface, the user can move on to utilize other interfaces in the Sample Adequacy tab. Check Adequacy () is one available sample interface. This interface is used to view the new number of unsampled TOPS, required samples, and current samples for each stratum (Functional System, Volume Group, and Urban Code grouping). This allows users to quickly identify stratums that do not meet the sample adequacy requirements. The table below describes the functions of the Table Elements in the Check Adequacy interface.

Table Element	Description
Second Column	Displays the precision level (confidence level – precision rate) used to calculate the number of required samples. These values can be edited in the Precision Level interface in the Sample Adequacy tab.
Third Column	Displays a caution symbol or green check mark.
Caution Symbol	Indicates that a stratum has an insufficient number of samples.
Adjacent Number (to Caution Symbol)	Denotes how many stratums are deficient.
Carets	Allows users to expand or collapse the stratum data.

Cell Information

Each cell under the Volume Group section contains three numbers:

The number of unsampled TOPS Sections -- the number of TOPS locations that do not have a Sample ID for the stratum.
The number of required samples -- the number of samples needed for this sample stratum, calculated using FHWA’s Sample Size Estimation equation.
The number of provided samples -- the number of TOPS locations that do have a Sample ID for the stratum.

The first number will appear as a link that opens the Potential Samples interface on the Sample Adequacy tab. This allows the users to easily add samples to a stratum with an insufficient number of samples (denoted by the third number in a cell being red). Below is a visual that shows each number type and style on a sample Volume Group cell.

Potential Samples

After using the Create TOPS interface, the user can move on to utilize other interfaces in the Sample Adequacy tab. Potential Samples () is one available sample interface. This interface is used to add samples to meet FHWA requirements.

Filters -- Top Filters

The user can search by stratum on the Potential Samples interface through the Volume Group, Functional System, and Urban Code filters at the top of the Potential Samples interface. After selecting values for the filters, the user can click the “Find Now” button to have a list of segments appear in the table. The resulting segments include unsampled TOPS locations and existing sample sections.

When accessing Potential Samples through Check Adequacy or Expansion Factors, the filters will be pre-populated to reflect the selected stratum. Check Adequacy will connect to this interface through the linked, first number on each cell.

Filters -- Data Completeness Filters

Data Completeness provides additional filters in this interface. This portion contains two checkboxes, a textbox, and a link that all help with narrowing the information on the table.

Filters -- Potential Sample Table

The Potential Sample Table will be populated with TOPS sections within the specified Volume Group, Functional System, and Urban Code selected. Users can add samples in two ways: manual and random selection.

Manually Add Samples

To manually add samples, follow the steps listed below:

Check the checkbox in the first column on the desired segment.
- Checkboxes will not be present for segments already designated as samples.
- Segments that appear red in the table do not meet AADT criteria specified in the Data Completeness section.
- Segments that appear orange in the table do not meet segment length restrictions set by the FHWA.
- The “Completeness” column can be used to find the segments with the most amount of data items that exist on a segment. The number in this column specifies how many data items exist (1st number) versus (/) the total amount of data items in the selected data table (2nd number). Clicking on the completeness field will display a popup showing a list of data items that exist.
Add a new sample ID by clicking the Samples column and entering a value in the textbox.
- If no sample ID is provided before saving, one will be generated automatically based on the current year and zero-padded to support a 12-digit format.
After selecting all desired segments, click the “Add Samples” button to add the new samples to the samples table and data table.
- To apply changes to the data source, check the “Save to Source” checkbox before clicking “Add Samples.”

Randomly Add Samples

To randomly select samples, follow the steps listed below:

Click the “Random Select” button to open the Random Samples interface.
Specify the number of samples to be created by entering a value in the “Number to Randomly Select” textbox.
Check the “Exclude Segments not meeting AADT criteria” and “Exclude Segments not meeting length restrictions” checkboxes if desired.
- Check the “Exclude Segments not meeting AADT criteria” checkbox to prevent from randomly selecting a sample that does meet the criteria specified in the Potential Samples Data Completeness section. The checkbox will be disabled in this interface if the “AADT not within…” checkbox is not checked in the Data Completeness section.
- Check the “Exclude Segments not meeting length restrictions” checkbox to prevent samples from being randomly selected that do not meet length restrictions set by the FHWA.
After all desired parameters have been set, click the “Select Samples” button to randomly select the provided number of samples.
- These samples will be given a generated sample ID based on the current year and zero-padded to support a 12-digit format.
Finish adding the samples to the sample table and data table by clicking the “Add Samples” button on the Potential Samples interface.
- To apply changes to the data source, check the “Save to Source” checkbox before clicking “Add Samples.”

Sample Table

Below the data table, in the "Sample Table" section, the number of required samples, existing samples, samples that are needed to meet requirements, and total samples can be found. The number of selected samples and total number of samples will increase or decrease by selecting segments to sample using either method above.

Expansion Factors

After using the Create TOPS interface, the user can move on to utilize other interfaces in the Sample Adequacy tab. Users can check if a stratum is under-sampled by using the Expansion Factors interface. The interface calculates this by dividing the total length of a particular stratum by the total length of sample segments in a stratum. If the number exceeds a maximum of one hundred, the number will appear red to show the stratum is under-sampled. In order to take these actions, the user can locate the icon on the Sample Adequacy tab and section.

The Expansion Factors interface has certain elements which allow actions and provide information to the user. These elements are:

Element	Function
Calculate Expansion Factors button	Generates the calculation of the expansion factors.
Caret ()	Expands or collapses stratums.
Caution icon ()	Notifies the user of any expansion factors that exceed the recommended upper bound; displayed in the second column of the table.
Links (ex. )	Indicates the expansion factors that exceed the recommended upper boundary; opens the Potential Samples interface.

Sample Risk Analysis

After using the Create TOPS interface, the user can move on to utilize other interfaces in the Sample Adequacy tab. The Sample Risk Analysis is one available interface. If a stratum is oversampled, retaining a surplus could be warranted if a stratum is at risk of losing multiple samples. The Sample Risk interface helps determine if a stratum has potential to lose samples by showing which samples are at risk of migrating to a lower or higher range volume group. In order to open this interface, the user can locate the icon on the Sample Adequacy tab and section.

Risk Analysis Parameters

In the Risk Analysis Parameters section, users can set a percentage to identify samples within a certain range of the upper or lower bounds of a Volume Group. This field is required to perform an analysis.

Optional Filters

Two optional filters are available to narrow the results. Both of these filters are located directly below the Risk Analysis Parameters.

The ability to filter stratums that do not have a certain percentage of at-risk samples. To apply this filter, check the “% of the Number of Required Samples” checkbox, select a query operator (>, <, >=, <=, or =) in the dropdown, and specify a percentage in the textbox.
The ability to filter stratums that do not have a certain number of at-risk samples. To apply this filter, check the “Show Stratums At Risk Samples” checkbox, select a query operator (>, <, >=, <=, or =) in the dropdown, and specify an amount in the textbox.

Tables

After the required Risk Analysis Parameter and optional filters are set, the user can select the "Perform Analysis" button. This will populate the table below the parameters and filters, called the Sample Risk Stratum Table, with information based on the parameters specified. Then, the user can select a row in this table to populate the Sample Risk Detail Table. This table will be titled, Sample [Urban Code/ FSystem/ Volume Group]. Any samples at risk of leaving will appear in red.

Delete Samples

The Delete Samples interface can be used to reduce over-populating or to relocate a sample by deleting it in this interface and adding it back in Potential Samples. After using Check Adequacy to check if a sample stratum is oversampled, the user can utilize the Delete Samples interface to delete such stratums. If the number of provided samples is significantly more than the number of required samples in the Check Adequacy table, the stratum may be oversampled, and samples might need to be deleted. The Delete Samples interface can be accessed by selecting the Sample Adequacy tab. This interface is marked by a purple trashcan icon (), and it is the last icon in the Sample Adequacy section. To delete a sample, follow these steps:

Select the desired data table year in the “Year” picklist.
Select the desired “Data” table to use in the Data picklist.
Click the “Find Samples” button to find all sampled segments in a data table.
Click the “Save Changes” button to save changes to the selected sample and data table. To save changes back to the source data, the “Save to Source” checkbox needs to be selected before clicking the “Save Changes” button.

If a stratum contains three segments or fewer, the FHWA requires all segments to be sampled. It is not advised to delete a sample in a stratum with three or less segments.

Precision Level

The Precision Level interface () is used to view and update the confidence level and precision rate of each Functional System and Urban Code combination. It plays a very important role, for its data is used to calculate the number of required samples per stratum on the Check Adequacy and Adjust TOPS interfaces. The Precision Level interface can be accessed on the Sample Adequacy tab; it is the only icon under the Maintenance section. To edit a confidence level or precision rate, the user can follow these steps:

Click into the desired cell.
Edit the resulting textbox.
Click the “Save Changes” button.

Standard Reports

One of the last items to check before submitting data to the FHWA is mileage. The LADOTD HPMS Manager aids this last check by constructing preconfigured reports that list mileage in different ways. These preconfigured reports can be accessed by selecting the Reports tab. Once selected, three icons will appear: HPMS, Advanced, and HPMS Report Status. To access the Standard Reports, or preconfigured reports, the user can select the HPMS icon (outlined in red below).

Then, the user will be able to select one of the available preconfigured reports:

Report	Lists the...
Certified Mileage by County	Mileage for Interstate, State, Local, and other routes, grouped by County.
Certified Mileage by County - Detailed	Mileage for Interstate, State, Local, and other routes, grouped by County, along with each route that is included in the group and the associated mileage.
Consistency Report	Length (in miles) of AADT, Through Lanes, Ownership, and Control, grouped by F_System.
Extent and Travel – Interstate by Route Number	Miles, Lane Miles, and Vehicle Miles for each Interstate route.
Extent and Travel – Interstate by Route Number (Comparison)	Miles, Lane Miles, and Vehicle Miles for each Interstate route for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Extent and Travel – Statewide Summary	Miles, Lane Miles, and Vehicle Miles by Small Urban, Rural, All Urbanized, and All Urban areas, grouped by Urban Code and F_System.
Extent and Travel – Statewide Summary (Comparison)	Miles, Lane Miles, and Vehicle Miles by Small Urban, Rural, All Urbanized, and All Urban areas, grouped by Urban Code and F_System for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Extent and Travel – Urbanized Summary	Miles, Lane Miles, and Vehicle Miles for each Urban Code, grouped by Urban Code and F_System.
Extent and Travel – Urbanized Summary (Comparison)	Miles, Lane Miles, and Vehicle Miles for each Urban Code, grouped by Urban Code and F_System for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Extent and Travel on the NHS	Miles, Lane Miles, and Vehicle Miles for each NHS type, grouped by NHS and F_System.
Extent and Travel on the NHS (Comparison)	Miles, Lane Miles, and Vehicle Miles for each NHS type, grouped by NHS and F_System for 2 years. Includes the percent change for Miles, Lane Miles, and Vehicle Miles.
Ownership Report	Mileage for each Ownership value, grouped by Ownership and F_System.

To create a Standard Report, the user can follow the steps below after entering the HPMS interface on the Reports tab.

Select a data table to retrieve mileage from the "Data" picklist.
Select the desired report by clicking on the report name in the "Select the Report" section.
Apply the desired filters: Parish, Roadway Type, and Number of Lanes (if applicable).
Click the “Open as PDF” button to open the report in PDF format or the “Open in Excel” button to open the report in Excel format.

Submittals

The last step of the HPMS process is submittals. After collecting and validating the data, the Submittals tab allows the user to generate submittal and summary files for submission to FHWA. The Submittal tab provides the following tools to create submittal and summary files:

Icon	Name	Use To...
	ARNOLD Segments	Generate route network output.
	Road Segments	Create files for the HPMS Submittal process.
	Sample Limits	Generate a text file of Samples Locations.
	County	Edit and export county summary data.
	Non-Federal Aid	Edit and export non-federal aid summary data.
	Road Event Collection	Update and create files for the HPMS Submittal process.
	Road Estimates	Generate a text file of Samples Locations.

ARNOLD Segments

The ARNOLD Segments interface provides options to generate Route outputs in Shapefile, File Geodatabase, or text file format. The ARNOLD Segments interface () can be located by selecting the Submittals tab and navigating to the first section-- Section Files. The ARNOLD Segments interface is the first icon in this section and the first on the Submittals menu. To create an ARNOLD Segments submittal file, follow these steps:

Select a data table in the "Data Table" picklist.
Select a file type: Shapefile, File Geodatabase, and Text File.
Select a route type in the "Generate Files By" section.
- If the user selects the “Route Type” option, they can choose from the four checkboxes-- Interstate, US Route, State Route, or Local-- to clarify the desired route (multi-select allowed).
After selecting the desired options, click the “Export Data” button.

Road Segments

The Road Segments interface provides options to create one or more section files for the various data items. The Road Segments interface () can be located by selecting the Submittals tab and navigating to the first section-- Section Files. The Road Segments interface is the second icon in this section and the second on the Submittals menu. To create section files, follow these steps:

Select a data table in the "Data Table" picklist.
Fill out the information in the "File Creation" section.
- Select an output File Type: CSV or Text.
- Select what type of files to generate: Create Individual Files or Create One File.
  - Create Individual Files (in zipped file) – Used to create individual section files based on the grouping specified in the "Group Files By" picklist (Route Type/Route, Data Item, or Route Type and Data Item).
  - Create One File – Used to create one section file containing the data for all selected data items.
- Select a Reference Network: Statewide Routes or LRS ID Routes.
- Select the optional checkboxes if desired.
  - Exclude Nulls – Used to exclude sections where a data item does not exist from the generated section file.
  - Break on sample sections – Used to split output segments data where samples exist.
Select either the Road Designations, Road Events, or Road Identifications tab.
- Road Designation tab – filter by route type and the five FHWA designated road designation data items.
- Road Events tab – filter by route type and the remaining FHWA designated data items.
- Road Identifications – filter by specific data items (Alternative Route Name, Route Number, Route Qualifier, and Route Signing).
Fill out either the Routes or Data Items section under the selected tab.
- If the user chooses to fill out the Route section, they must first select an option in the picklist: Route Type or Select Route(s).
  - If Route Type is selected, the user must then select one or more checkbox manually or by clicking the "Select All" link.
  - If Select Route(s) is selected, the user must enter a complete Route LRS (Parish, System Code, Route Name, Direction, and Feature Type), then select "Add Route >". Multiple routes can be added.
- If the user chooses to fill out the Data Items section, they must select one or more checkbox manually or through one of the "Select All" links.
  - The "Select All" link will check all checkboxes. The "Select All TOPS Data Items" link will only check the TOPS items.
  - If this section contains any grayed-out items, this indicates that those data items are not in the selected data table.
- While both sections can be filled to create section files, only one section is required to be filled. If a route/route type is selected with no specified data item, all data items will appear in the file. If a data item is selected with no specified route type, all route types will appear in the file.
Click the "Create Section File(s)" button to generate section files.

Sample Limits

The Sample Limits interface provides options to generate a text file of sample locations. This interface can be used to report all sample locations, or a subset based on the selected route type. The Sample Limits interface () can be located by selecting the Submittals tab and navigating to the first section-- Section Files. The Sample Limits interface is the third/last icon in this section and the third on the Submittals menu. To create a file in the interface, follow these steps:

Select a data table in the "Data Table" dropdown.
Select a Reference Network to use.
Select "All Samples" or a route type(s) in the "Generate Files By" section.
Select the "Create File(s)" button located at the bottom of the interface.

The resulting Sample Limits file will include the following header columns: BeginDate, StateID, RouteID, BeginPoint, EndPoint, SampleID, and Comments.

County

The County interface provides options to import, recalculate, edit, export, and generate county summary data. The County interface () can be located by selecting the Submittals tab and navigating to the second section-- Summary Files. The County interface is the first icon in this section and the fourth on the Submittals menu.

Import a File

The user can populate the County Summaries table by importing a file or recalculating the data. To import a county summary file, follow these steps:

Click the "Choose File" button at the bottom left of the interface.
Select a file to import.
- To import a file, it must have the following header columns: BeginDate, StateID, CountyID, FSystem, UrbanID, Ownership, SystemLength, and Comments.
After selecting the desired file, click the "Open" button.

Recalculate Data

The user can populate the County Summaries table by importing a file or recalculating the data. To recalculate the data, follow these steps:

Select a data table in the "Data Table" picklist.
- The recalculate process uses the data table to retrieve routes that classify as rural minor collectors and local roads for each urbanized area and rural areas.
Click the “Recalculate” button.
If the new values are sufficient, click the "Save Changes" button to save the new values.

Edit Data

The first column in the interface table-- Override-- is available to initiate the editing process for the desired record. To fully edit a record, follow these steps:

Select the checkbox in the "Override" column for the desired record or click on a record that has been previously overridden.
Once selected, a textbox will appear in the System_Length and Comments columns to allow edits.
After entering the desired changes, click the "Save Changes" button.

Overridden records will not be recalculated or be overwritten by the import process.

Export Data

To export the county summary table, the user can click the "Export to Pipe Delimited File" link located at the bottom right of the interface. The file will be in a text file in pipe delimited format and will contain the following header columns: BeginDate, StateID, CountyID, FSystem, UrbanID, Ownership, SystemLength, and Comments.

Non-Federal Aid

The Non-Federal Aid Summaries interface provides options to import, edit, export, and recalculate non-federal aid summary data. The Non-Federal Aid interface () can be located by selecting the Submittals tab and navigating to the second section-- Summary Files. The Non-Federal Aid interface is the second/last icon in this section and the fifth on the Submittals menu.

Import a File

The user can populate the Non-Federal Aid Summaries table by importing a file or recalculating the data. To import a non-federal aid summary file, follow these steps:

Click the "Choose File" button at the bottom left of the interface.
Select a file to import.
- To import the file, it must have the following header columns: BeginDate, StateID, FSystem, UrbanID, VMT, and Comments.
After selecting the desired file, click the "Open" button.

Recalculate Data

The user can populate the Non-Federal Aid Summaries table by importing a file or recalculating the data. To recalculate the data, follow these steps:

Select a data table in the "Data Table" picklist.
- The recalculate process uses the data table to retrieve routes that classify as rural minor collectors and local roads for each urbanized area and rural areas.
Click the "Recalculate" button.
If the new values are sufficient, click the "Save Changes" button to save the new values.

Edit Data

The first column in the interface table-- Override-- is available to initiate the editing process for the desired record. To fully edit a record, follow these steps:

Select the checkbox in the "Override" column for the desired record or click on a record that has been previously overridden.
Once selected, a textbox will appear in the Local VMT and Comments columns to allow edits.
After entering the desired changes, click the "Save Changes" button.

Overridden records will not be recalculated or be overridden by the import process. The user can also edit the Rural Local AADT, Rural Minor Collector AADT, and Small Urban Local AADT values in this interface by following these steps:

Click into the corresponding textbox located in the Summarized AADTs section (Rural Local AADT, Rural Minor Collector AADT, or Small Urban Local AADT).
Edit the value by typing into the textbox.
Click the "Save Changes" button.

Export

To export the non-federal aid summary table, the user can click the "Export to Pipe Delimited File" link located at the bottom right of the interface. The file will be in a text file in pipe delimited format and will contain the following headers: BeginDate, StateID, FSystem, UrbanID, VMT, and Comments.

Road Event Collection

The Road Event Collection interface provides options to view, import, export, and edit data collection metadata. The Road Event Collection interface () can be located by selecting the Submittals tab and navigating to the third section-- Catalog Files. The Road Event Collection interface is the first icon in this section and the sixth on the Submittals menu.

Import a File

To import a Road Event Collection Methods file, follow these steps:

Click the "Choose File" button at the bottom left of the interface.
Select a file to import.
- To import a file, it must have the following header columns: BeginDate, StateID, MetadataType, FSystem, IsUrban, IsStateOwned, ValueNumeric, and Comments.
After selecting the desired file, click the "Open" button.

Edit Data

The first column in the interface table-- Override-- is available to initiate the editing process for the desired record. To fully edit a record, follow these steps:

Select the checkbox in the "Override" column for the desired record or click on a record that has been previously overridden.
Depending on the Metadata Type for the selected record, a picklist or textbox will appear, and the Value and Comments columns will become editable.
After entering the desired changes, click the “Save Changes” button.

Export

To export the Road Event Collection Methods table, the user can click the “Export to Pipe Delimited File” link located at the bottom right of the interface. The exported file will be in pipe delimited format and will contain the following header columns: BeginDate, StateID, MetadataType, FSystem, IsUrban, IsStateOwned, ValueNumeric, and Comments.

Road Estimates

The Road Estimates interface provides options to view and edit estimate values. The Road Estimates interface () can be located by selecting the Submittals tab and navigating to the third section-- Catalog Files. The Road Estimates interface is the second/last icon in this section and the seventh on the Submittals menu.

Import a File

To import a Road Estimates file, follow these steps:

Click the "Choose File" button at the bottom left of the interface.
Select a file to import.
- To import a file, it must have the following header columns: BeginDate, StateID, EstimateType, FSystem, IsUrban, IsStateOwned, ValueNumeric, and Comments.
After selecting the desired file, click the "Open" button.

Edit

The first column in the interface table-- Override-- is available to initiate the editing process for the desired record. To fully edit a record, follow these steps:

Select the checkbox in the "Override" column for the desired record or click on a record that has been previously overridden.
Depending on the Estimate Type for the selected record, a picklist or textbox will appear, and the Value and Comments columns will become editable.
After entering in the desired changes, click the "Save Changes" button.

Export

To export the Road Estimates table, the user can click the "Export to Pipe Delimited File" link located at the bottom right of the interface. The exported file will be in pipe delimited format and will contain the following header columns: BeginDate, StateID, EstimateType, FSystem, IsUrban, IsStateOwned, ValueNumeric, and Comments.

HPMS Report Status

The HPMS Report Status interface can be used to check on the HPMS submittal progress. This interface helps keep track of the number of validation errors that still exist and submittal files that have yet to be created. The HPMS Report Status interface () can be located by selecting the Reports tab and navigating to the second section-- Status. The HPMS Report Status interface is the only icon in this section and the third on the Reports menu.

Item Complete Status

To mark a Report Status item as complete, the user can select the checkbox to the left of the item. The progress bar will update after marking items as complete or incomplete.

Section Validations

The Section Validations portion of the HPMS Report Status interface is used to view the progress of the Route Import, Event Import, Coverage Validations, and Cross Check Validations. This section displays the number of invalidations found, along with the latest date each validation was performed.

Sample Validations

The Sample Validations portion of the HPMS Report Status interface is used to view the progress of the Sample and TOPS validations. This section displays the number of invalidations found for each Sample and TOPS validation report, along with the latest date each validation was performed.

Submittal Files

The Submittal Files portion of the HPMS Report Status interface is used to view the progress of the various files required for HPMS submittals. If a file is created in HPMS Manager, a last created date will appear beside the item. This section also contains a link to open the Section File Submittal Status interface.

Section File Submittal Status Link

The sole link in the Submittal Files portion-- the Section File Submittal Status link-- opens the Section File Submittal Status interface. This interface is used to track which data items had a section file created.

The Section File Submittal Status interface is divided into ten tabs based on the different FHWA categories according to HPMS 9.0 specifications (Designations, Identifications, Inventory, Lanes, Intersections, Traffic, Control, Pavement, Terrain, and Travel Time). Marking items as complete here will update the progress bar on the HPMS Report Status interface. The text for the Section File Submittal Status link will also change to reflect the number of items marked as complete.

Search

Welcome to PMG Support

HPMS Help Articles

Screen Overview

(1) Map Frame

(2) Legend Menu

(3) Tabs and Controls Ribbon

Status Types

Map Display

(1) Navigate

(2) Identify

(3) Find Segments

Route

Sample

More Filters

(4) Basemap

(5) iVision

Edit Tab

Icons

Data Editing

Management

Data Cleaning

Route Info

Select From Map

Basic Editor

(1) Required Information

(2) Data Items

(3) Button Controls

(4) Expand and Collapse Controls

Edit Log

Clear Historical Data

Save Data to Source

Edit Groups

Edit Rules

Fix Event Gaps

Snap Events to Route

Fix Events Offsets

Fix Event Overlaps

Check Event IDs Report

View Concurrencies

View Translations

Validation Tab

Icons

HPMS Validations

Completeness

Summaries

Management

Route/LRS

Validations

Sample Sections and TOPs

Report Types

Validation Edit Menu

Import, Cross, and Coverage

Validation Edit Menu

Missing Full Extent Coverage

Validation Report

Modify Editor Columns

Sample Adequacy Tab

Icons

Sample Adequacy

Maintenance

Create TOPs

Adjust TOPs

(1) Data Table Information

(2) Data To Adjust

(3) TOPS Changes Summary

(4) Button Controls

Split Sample by TOPs

(1) Data Table Information

(2) Sample Data Grid

(3) Button Controls

Check Adequacy

Potential Samples

(1) Data Table Information and Stratum Information

(2) Data Completeness

(3) Potential Sample Table

(4) Sample Table

(5) Button Controls

Number Colors

Expansion Factors