TimeSeries month table

tagId

tagIDType

This field displays the ID of the collect point.

time

datetime2(7)

This field displays the server time of data summary This field displays the server time of the collected point (Coordinated Universal Time [UTC]).

value

doubleType

This field displays the value at the end of the period.

dataQuality

bigint

This field displays the data quality at the end of the period.

minTime

datetime2(7)

This field displays the server timestamp for the minimum value.

minValue

doubleType

This field displays the minimum data value over the period.

minDataQuality

bigint

This field displays the data quality for minimum value.

maxTime

datetime2(7)

This field displays the server timestamp for maximum value.

maxValue

doubleType

This field displays the maximum value over the period.

maxDataQuality

bigint

This field displays the data quality for maximum value.

averageValue

doubleType

This field displays the average value over the period.

ownSysId

tagIDtype

This field displays the System ID of the system that owns the point.

datasetId

tagIDType

This field displays the ID associated with dataset.

minDqFlags

bigint

This field represents all the data qualities present at the time of the minimum value in the month.

For more information, refer to TimeSeries data quality attributes.

maxDqFlags

bigint

This field represents all the data qualities present at the time of the maximum value in the month.

For more information, refer to TimeSeries data quality attributes.

avgDqFlags

bigint

This field represents a bit-wise, logical "OR" of all the data qualities that were active during the month.

For more information, refer to TimeSeries data quality attributes.

dqFlags

bigint

This field represents all the data qualities present at the end of the period.

For more information, refer to TimeSeries data quality attributes.

originalTableName

nvarchar(64)

This field displays the name of the table before it was partitioned.

partitionTableName

nvarchar(64)

This field displays the name of the table after it was partitioned.

partitionFunctionName

nvarchar(64)

This field displays the name of the partition function within Microsoft SQL Server configuration.

partitionSchemaName

nvarchar(64)

This field displays the name of the partition schema within Microsoft SQL Server configuration.

partitionLevel

int

This field displays the number of future partitions that should be created from the current date.

numFuturePartition

int

This field displays the number of future partitions that should be created from the current date.

partitionGranularity

nvarchar(32)

This field displays how the partitions are split up (for example, by day).

createStartDate

date

This field displays the initial date that partitions were created.

singleDiskLocation

nvarchar(256)

This field displays the disk location where Microsoft SQL Server data files are located.

defaultFileGroupSize

int

This field determines the default size of the created file groups.

Note: This field must be specified, but the size will be determined by your data load.