Columns tab options

Use the Columns tab to select which columns to include in the query results.

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.

• SourceTag: The source tag of the tag.

• SourceServer: The source server of the tag.

• StartDateTime: The start time of the retrieval cycle.

• EndDateTime: The end time of the retrieval cycle.

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

• State Count: The number of times the state occurred within the retrieval cycle.

• Contained State Count: The number of times the state occurred fully contained within the retrieval cycle.

• Minimum: The minimum time in the current state amongst all its occurrences during the current retrieval cycle, including state occurrences that fall partially within the period.

• MinContained: The minimum time in the current state amongst all its occurrences during the current retrieval cycle, excluding state occurrences that fall partially within the period.

• Maximum: The maximum time in the current state amongst all its occurrences during the current retrieval cycle, including state occurrences that fall partially within the period.

• MaxContained: The maximum time in the current state amongst all its occurrences during the current retrieval cycle, excluding state occurrences that fall partially within the period.

• Average: The average time in the current state amongst all its occurrences during the current retrieval cycle, including state occurrences that fall partially within the period.

• AverageContained: The average time in the current state amongst all its occurrences during the current retrieval cycle, excluding state occurrences that fall partially within the period.

• Total: The total time in the current state during the current retrieval cycle, including state occurrences that fall partially within the period.

• TotalContained: The total time in the current state during the current retrieval cycle, excluding state occurrences that fall partially within the period.

• Percent: The percentage of time during the current retrieval cycle that the tag was in the current state, including state occurrences that fall partially within the period.

• PercentContained: The percentage ratio between StateTimeTotalContained and StateTimeTotal.

• wwMaxState:The maximum number of states allowed in the same reporting period. The default number of maximum states is 10.

• wwCycleCount: The number of retrieval cycles (sub-interavls) for the specified time period.

• wwResolution: The sampling rate, in milliseconds, for retrieving the data in cyclic mode.

• wwTimeZone: The time zone for retrieval is specified.

• wwRetrievalMode: The processing of retrieved data is specified before it is returned to the client.

• wwVersion: The version of data to be used if the original data value is changed