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
Functions
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.
Add 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
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.
User Guide
For more general information on this tab, visit the User Guide equivalent article on the Attributes tab.
Comments
0 comments
Please sign in to leave a comment.