There are three optional validation checks on the Validations tab: Missing Full Extent Coverage, Validation Report, and Modify Editor Columns. While these are not required as part of the workflow, they are optional tools which are beneficial to the user.
Missing Full Extent Coverage
The Missing Full Extent Coverage validation check () allows DOTs to check and confirm the completeness of data items beyond HPMS requirements. The check will identify where specified data items do not have full coverage, null values, or dangles against routes.
Steps
To check the completeness of data items, follow these steps:
- Select a radio button option in the "Select the location(s) to check" section: Statewide or Specific Location.
- If the "Specific Location" radio button is selected, fill out one or more of the associated picklists to run the validation checks on a subset of locations.
- If the "Statewide" radio button is selected, the validation will run the checks on the full extent of data.
- Select one or more checkboxes in the "Data Items" section. This can be done manually (selecting checkboxes) or through the "Select All" link.
- Select an output type button: Open as PDF, Open as Excel, or Open Report Window.
Report Columns
If a Missing Full Extent Coverage validation check is opened in a Report Window, it will contain the following columns:
Column | Description |
Row | The row number on the table. |
County | The County 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. |
Data Items Missing Values | The missing data item. The only data item values that could appear in this column are those selected in the Data Items checkboxes before running the validation check. |
|
The icon that leads to the Validation Edit menu. |
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. |
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. |
Validation Report
The Validation Report interface () is used to run all validations and generate a summary report. The summary report provides a count of all the validations performed and links to run individual reports in the Report window.
Steps
To run validations and generate a summary report, follow these steps:
- Select one or more checkboxes in the "Validations" section. This can be done manually (selecting checkboxes) or through the "Select All" link.
- Select the "Run Validation Summary" button.
Report
The resulting report will be organized by validation (Sample and TOPS, Import, Cross, Coverage, and/or Missing Full Extent). Then, the errors that occurred in the validation check for that validation will be listed in its table. The "Records" column will host a hyperlinked number for each error row. These links will allow the user to run individual reports and edit the errors as needed (Validation Edit Menu).
Modify Editor Columns
The Modify Editor Columns tool () is used to add informational or decision-making columns to the HPMS Validation rules. The selections on this interface determine the columns displayed on the table in the Validation Editor.
Add Columns
To add columns to the HPMS Validation rules, follow these steps:
- Select an option in the "Validation Type" picklist.
- Select an option in the "Data Item" picklist which is populated with the HPMS Items that have rules in the selected Validation Type category. This selection will display the required columns in the table.
- Select the "Add New Row" link to create additional columns.
- Click into the blank "DataItem" field in the new row to select a value from the picklist. The "Required?" column will automatically be set to "No".
- Select the "Save Changes" button to store the columns and display them in the Validation Editor once the rule is validated.
Delete Columns
To delete non-required columns, follow these steps:
- Select the checkbox in a non-required column's row.
- Select the "Delete Selected Rows" link to delete the column.
- Select the "Save Changes" button to solidify the deletion.
Comments
0 comments
Please sign in to leave a comment.