The Data Table Configuration interface allows the user to define data tables. All information found here occurs in the Data Tables interface, accessible from the System Administration tab. Specifically, this can be accomplished on the second and third tabs of the Data Tables interface: Required Items and Attributes.

Required Items Tab

Required Items is the second tab on the Data Tables Configuration interface, and it allows the user to specify the location of the source data for routes and sample data. To do this, the user can select the desired Data Table in the picklist, then select an internal tab-- Routes or Sample Section Locations-- to enter the appropriate information.

Internal Tab: Routes

The Routes tab can be used to enter the source of the route network. To add a route source, the user must follow these steps:

1. Fill out the Data Source, Table Name, Route ID, From Measure, To Measure, From Date, To Date, and Filters fields.
2. After filling in the desired fields, click the "Save Changes" button at the bottom of the interface.

Internal Tab: Sample Section Locations

The Sample Section Tab can be used to specify the source data for samples. To add a sample source, the user must follow these steps:

• 1. Fill out the Data Source, Table Name, Column, Route ID, From Measure, To Measure, From Date, To Date, and Filters fields. The user can also select the "Allow Save to Source" checkbox if desired.
  2. After filling in the desired fields, click the "Save Changes" button at the bottom of the interface.

NOTE: For more general information on the Required Items tab, visit this article.

Attributes Tab

Attributes is the third tab on the Data Tables Configuration interface, and it can be used to define the sources and parameters for each of the HPMS data items. To do this, the user can select the desired Data Table in the picklist, then select an internal tab-- Events, Parent/Child Events, and Derived Events-- to enter the appropriate information. Each of these tabs has specific guidelines attached to them on how to properly add data items.

Internal Tabs: R&H, Non-R&H, and Parent/Child Events

The Events tab and Parent/Child Events tab follow the same steps for adding a data item. Therefore, we have grouped them together.

Add Data Item

To add an Event or Parent/Child data item, follow these steps:

1. Add a new row or copy an existing row by using the links.
   • 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. This will populate all fields except the Item Name column.
2. Fill out the blank parameters by clicking into a cell and utilizing the resulting picklist or textbox.
3. 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 Events and 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.

Internal Tab: Derived Event

The Derived Events tab is used to add derived data items. To add a Derived Events data item, follow these steps:

1. Add a new row or copy an existing row by using the links.
   • 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. This will populate all fields except the Item Name column.
2. Enter an Item Name 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.
3. After adding the desired data items, click the "Save Changes" button at the bottom of the interface.

NOTE: For more general information on the Attributes tab, visit this article.

Delete Data Item

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

1. 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.
2. After selecting the desired items, click the "Delete Selected Rows" link to permanently delete the items from the data table definition.