Table Columns Tab

The Table Columns tab is used to specify which columns from database tables are displayed on the data tabs, and the default order that columns are displayed in from left to right.

It can also be used to specify whether or not, when the values in a column change due to an import, this will result in the record status of the rows containing the changed data being updated.

Select the table to be edited from the list in the Select Table field. The columns in the selected table are then displayed under the Column Name heading.

• The order that the columns are displayed in from top to bottom is that the same order that the columns are displayed on the data tab from left to right.

• To change the default order in which columns are displayed, select a column from the list and press the up or down arrow button as appropriate. Multiple columns can be selected and moved.

• If a column is to be visible on the data view tab, make sure that the Visibility checkbox is checked.

• If, when the values in a column change due to an import, this is to result in the record status of the rows containing the changed data being updated, check the Impact checkbox.

  Note: This option is not available for some columns as a change to the values in these columns must always result in the record status being updated.

• If required, in the Alias fields, enter more user-friendly or project-relevant names for columns. These will be displayed in the column headers in the data tabs. The original names will be displayed as tooltips when the mouse cursor is hovered over the column headings.

  Note: The aliases for Pipe Project Definable, Instrument Dialog Label, Instrument Panel Dialog Label, and Equipment Dialog Box Labels fields are set in the AVEVA P&ID Project Administrator program. They can be viewed in this tab, but they cannot be changed.

• To delete a column, select the column from the list and click . Multiple columns may be selected for deletion.

• To add a new column, select the column type (for example, the data type it will contain, such as Text, Memo, Number, Boolean etc) from the Column Type field in the Add Column area.

  Enter the name of the column in the Column Name field and click Add. The new column is then added to the bottom of the list of columns.

• To edit a column name, select the column data type from the Select Data Type list in the Update Column Name area, and the name from the Column Name list. Enter the new name of the column in the New Column Name field and click OK.