Data Table Definition: Required Items

The Data Table Definition functionality is concentrated in the Required Items and Attributes tabs in the Data Tables interface. This article focuses on the first tab, Required Items.

Required Items Tab

The Required Items tab is used to enter data for items required for all Data tables. These 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. Both of these items have their own internal tabs on the interface.

Statuses

Once the user runs the populate process using the Populate Button, an icon will appear next to the title of the internal tabs, 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. The available statuses-- Success, Warning, and Fatal Error-- are described here.

Routes Tab

This interface is used to specify which route network to use when retrieving route data. It hosts these controls:

Control	Used To...
Data Source Dropdown	Select the data source for route network data; required.
Table Name Dropdown	Select the table where the route data is located.
Route ID Dropdown	Choose which column will be used for the Route ID field for the route data.
From Measure Dropdown	Choose which column will be used for the From Measure field for the route data.
To Measure Dropdown	Choose which column will be used for the To Measure field for the route data.
From Date Dropdown	Choose which column will be used as the From Date field when applying temporal data filters (if the selected data table contains temporal data).
To Date Dropdown	Choose which column will be used as the To Date field when applying temporal data filters (if the selected data table contains temporal data).
Filters Textbox	Enter a valid SQL filter that will be used to filter data retrieved from the selected table.

Sample Section Locations Tab

This interface is used to enter information on sample data for the data source.

Control	Used To...
Data Source Dropdown	Select the data source for the sample data; required.
Table Name Dropdown	Select the table that contains sample data; required.
Column Dropdown	Choose which column will be used for the Sample ID field in the HPMS Data table; required.
Route ID Dropdown	Choose which column will be used for the Route ID field for the sample data; required.
From Measure Dropdown	Choose which column will be used for the From Measure field for the sample data; required.
To Measure Dropdown	Choose which column will be used for the To Measure field for the sample data; required.
From Date Dropdown	Choose which column will be used as the From Date field when applying temporal data filters (if the selected data table contains temporal data).
To Date Dropdown	Choose which column will be used as the To Date field when applying temporal data filters (if the selected data table contains temporal data).
Filters Textbox	Enter a valid SQL filter that will be used to filter data retrieved from the selected table.
Allow Save to Source Checkbox	Permit the update of sample section source data for database source types.

Search

Welcome to PMG Support

Required Items Tab

Statuses

Routes Tab

Sample Section Locations Tab

Comments