This is an intermediate table, which is used for filling the KDW_SACTTOTPK_FACT table. This table includes the following:
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
HOUR_ID | varchar | 40 | No | Hour in which the activity took place. Primary key component. Foreign key to ARF_TIME_HOUR.ID column. |
TIME_AS_IS | timestamp | No | Primary key component. | |
NUM_EVENTS | integer | Yes | Session activity peak count. |