Home > Technical > Table Definitions > STATSPER

STATSPER

This table contains a record for each statistical period, which is generally a one week period. These periods are used when storing statistics information.

Column Type Description
STRYEARWEEK VARCHAR(7) Unique code for the stats period. The exact form will depend on the STRPERIODTYPE.
W   yyyy.ww, where yyyy is the year and ww is the week number as a two digit number, for example 2006.01, 2006.52.
M   yyyyMmm, where yyyy is the year and mm is the month number as a two digit number, for example 2006M01, 2006M12.
D   yymmdd where yy is the year, mm is the month and dd is the day, for example 060613.
DTMSTART DATETIME The date the period starts.
DTMEND DATETIME The date the period ends.
INTMONTHNUM INT The month of the year which the period belongs in. (1-13).
STRPERIODTYPE VARCHAR(1) The type of period. W=Weekly, M=Monthly, D=Daily.
 

Primary Key: STRYEARWEEK

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)