StatisticID

Unique identifier for the statistic definition.

Yes

INTEGER

4

LongName

'Friendly' name of the statistic.

VARCHAR

255

ShortName

Unique name used in statistic calculations etc.

VARCHAR

255

Description

A description of the statistic.

LONGVARCHAR

StatType

The statistic type.

INTEGER

4

Follow the hyperlink for details.

StatAttributes

Statistic attributes.

INTEGER

4

Follow the hyperlink for details.

ListLength

Defines the maximum number of events to be retained.

INTEGER

4

Event list statistics only

ForecastLength

Defines the number of 'future' values supported by the statistic.

INTEGER

4

Static statistics only

HistoryLength

Defines the how many previous time period values should be maintained.

INTEGER

4

Value statistics only

TimePeriod

Indicates time period for which statistics should be gathered.

INTEGER

4

Follow the hyperlink for details.

TimePeriodOffset

The 'offset' into the time period from which statistics should be calculated.

DECIMAL

13

Follow the hyperlink for details.

FormatString

Defines the parameter values for parameter aware statistics.

VARCHAR

255

The format of this string is statistic specific.

CurrencyString

The currency associated with the statistic.

VARCHAR

255

Currency statistics only.

CurrentPhysicalSlotIndex

The physical (real) statistic event index for the current time period.

INTEGER

4

Value statistics only. Physical slots are 'wrapped' to maintain linear progression.

CurrentVirtualSlotIndex

The virtual statistic event index for the current time period.

INTEGER

4

Value statistics only. Physical slots are 'wrapped' to maintain linear progression.

TimePeriodStartTime

The actual time when the time period for the current index started.

TIMESTAMP

8

StatisticEnabled

Is the statistic enabled?

BIT

1

ParentID

Identifies the parent statistic of this statistic.

INTEGER

4

Foreign key: WgnStatDefinition