KDW_PSESSACTPK

This is an intermediate table which is used for filling the KDW_SESSACTPK_FACT table. This table includes the following:

Column Name

Type

Length

Null Allowed

Description

HOUR_ID

varchar

40

No

Primary key component. Foreign key to ARF_TIME_HOUR.ID column.

TIME_AS_IS

timestamp

No

Primary key component.

ORGANIZATION_ID

varchar

40

No

Primary key component. Foreign key to ARF_IU_ORG.ID column.

NUM_EVENTS

integer

Yes

Number of events that occurred. Session activity peak count.