Skip to Content
0
Nov 24, 2006 at 02:27 PM

WCR_USERSTAT Table AGGREGATIONLEVEL field

89 Views

Hi,

We're creating a custom Activity report using the WCR Tables but have doubts about fields of table WCR_USERSTAT.

field AGGREGATIONLEVEL get the values h(ourly), d(aily), m(onthly) and q(uarterly).

But what is the meaning of those?

Because the following records confuses us.

timestamphour aggregationlevel hasheduserid usertype logonid date

1157068800000 m USER1 n USER1 9/1/2006

1158105600000 d USER1 n USER1 9/13/2006

1151712000000 q USER1 n USER1 7/1/2006

can you help us?