Columns tab options

Use the Columns tab to configure the columns to show in the results. The Value (numeric value) and vValue (string value) columns are always shown.

Note: Some of the columns are not available when you select Wide query format on the Format tab.

The column options are:

• Tag name: The name of the tag within the AVEVA Historian server. If the data values are coming from Application Server, the attribute reference is shown as the tag name. You can also choose to show the hierarchical name along with the attribute reference. For more information, see ArchestrA Naming Conventions.

• Description: The description of the tag.

• Decimal places: The number of decimal places to show for the data value of the currently selected tag. This applies only to analog tags.

• Date and time: The time stamp for the returned value. For delta retrieval, this is the time at which the value was acquired by the AVEVA Historian. For cyclic retrieval, this is the specific time requested or calculated (using a SQL function).

• Include milliseconds: The time period used to include milliseconds in the timestamp.

• Raw value range: The minimum value of the raw acquired value. Also, the maximum value of the raw acquired value.

• Engineering units: The unit of measure.For example mph, grams, and pounds.

• Engineering units range: The minimum value of the tag, measured in engineering units. Also, the maximum value of the tag, measured in engineering units.

• Quality: The basic data quality indicator associated with the data value.

• Quality description: A text string that describes the quality detail value.

• OPC Quality: The quality value received from the data source.

• State time: The time that the tag remains in the specified value state (when using ValueState retrieval).

• wwStateCalc: The state calculation type used to calculate the state time when using ValueState retrieval (for example, average time or total time). For more information, see State Calculation (wwStateCalc).

• SourceTag: The source tag of the tag.

• SourceServer: The source server of the tag.

• wwRetrievalMode: The processing of retrieved data is specified before it is returned to the client.For more information, see Understanding Retrieval Modes.

• wwCycleCount: The number of retrieval cycles (sub-interavls) for the specified time period. For more information, see Cycle Count (X Values over Equal Time Intervals) (wwCycleCount).

• wwTimeDeadband: The time deadband used in data retrieval. For more information, see Time Deadband (wwTimeDeadband).

• wwTimeStampRule: The time stamp rule used in data retrieval. For more information, see Timestamp Rule (wwTimestampRule).

• wwVersion: The version of data to be used if the original data value is changed. For more information, see History Version (wwVersion).

• wwEdgeDetection: The type of edge detection used in the query.

• wwTagKey: The unique identifier of the tag in the AVEVA Historian server.

• InterpolationType: The interpolation type used to calculate the value. For more information, see Interpolation Type (wwInterpolationType).

• wwResolution: The sampling rate, in milliseconds, for retrieving the data in cyclic mode. For more information, see Resolution (Values Spaced Every X ms) (wwResolution).

• wwValueDeadband: The value deadband used in data retrieval. For more information, see Value Deadband (wwValueDeadband).

• wwQualityRule: The quality rule used in data retrieval. For more information, see Quality Rule (wwQualityRule).

• wwTimeZone: The time zone for retrieval is specified.

• PercentGood: The percentage of rows with good quality in relation to the total number of rows in the retrieval cycle.

• wwFilter: The analog filter used to filter data during retrieval. For more information, see Analog Value Filtering (wwFilter).