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. |