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.
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 all 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, Missing Full Extent, and/or Route Import). Then, the errors that occurred in the validation check for that validation will be listed in its table. The "Record" 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.