Campaign_Session_Denormalized_Data Table
The following table contains the list, definitions, and data attributes of columns of campaign_session_denormalized_data table.
All durations are in milliseconds.
Column Name | Position | Source Data Type | Sample Value | Column Description |
|---|---|---|---|---|
setup_id It is marked as CK (distinct ush_rec_no,curh_id,cuah_id, ush_session_id | 1 | character varying | Nullfor normal setup | It is the ID of the application setup. It is used in case of Central ART Setup where multiple application setups are being used. |
setup_name | 2 | character varying | Null for normal setup | It represents the name of the Setup. It is used in case of Central ART Setup, where multiple application setups are being used. |
ush_session_id | 3 | character varying | d646-53a91d0a-ses-agent-4907-2 | It is the session id from user_session_history table of the logged in user. |
ush_user_id | 4 | character varying | agent | It contains the ID of the logged in user. |
ush_local_ip | 5 | character varying | 10.10.2.184 | It contains the local IP Address of the machine through which the user is loggedin. |
ush_public_ip | 6 | character varying | 10.10.2.184 | It contains the Public IP Address of the machine from where the user is logged in. |
ush_login_time | 7 | timestamp without time zone | 06/24/14 01:00 PM | It contains the login time of the user. |
ush_logout_time | 8 | timestamp without time zone | 06/24/14 01:00 PM | It contains the logout time of the user, if any. |
ush_client_type | 9 | character varying | web.client | It is the type of the user’s machine fron which the user is logged-in (Java, webaccess, or other.) |
ush_client_version | 10 | character varying | 02.22.20420140502 | It contains the version of client machine. |
ush_browser_info | 11 | character varying | Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0 | It contains the information of the user’s machine browser, through which the user is logged in. |
ush_reason | 12 | character varying | USER_LOGOUT | It contains the logout reason of the user. |
ush_archive_id | 13 | bigint | 7 | It is the archive Id of the user_session_history (that is a unique value per record in user_session_history). |
ush_interval_start_time | 14 | timestamp without time zone | 06/24/14 12:50 PM | It contains the start time of the user’s interval time. |
ush_interval_end_time | 15 | timestamp without time zone | 06/24/14 12:50 PM | It contains the end time of the user’s interval. |
ush_contributed_login_duration | 16 | bigint | 102791 | It contains the total login duration in the particular interval of the user. |
ush_total_login_duration | 17 | bigint | 734201 | It contains the total login duration of the user. |
curh_id | 18 | character varying | d646-53a91d0a-ses-agent-4907-2 | It contains the unique ID of the campaign in which the user’s status was ready. |
curh_campaign_id | 19 | Integer | 1 | It is the campaign ID in which the user changed its ready state |
curh_session_id | 20 | character varying | d646-53a91d0a-ses-agent-4907-2 | It is the session ID of the user. |
curh_ready_start_time | 21 | timestamp without time zone | 06/24/14 12:48 PM | It contains the time when the user set ready status. |
curh_ready_end_time | 22 | timestamp without time zone | 06/24/14 12:48 PM | It contains the time when user set the break status. |
curh_break_end_time | 23 | timestamp without time zone | 06/24/14 12:48 PM | It contains the time when the user set ready status again. |
curh_break_reason | 24 | character varying | agent_selected_campaign | It contains the reason for the break set by the system. |
curh_agent_break_reason | 25 | character varying | | It contains the break reason, selected by the user. |
curh_contact_center_id | 26 | Integer | 1 | It contains the contact centre ID in which the user’s ready state has been changed. |
curh_break_end_reason | 27 | character varying | agent_set_ready | It contains the end break reason. |
curh_archive_id | 28 | bigint | 6 | It is the archive ID of campaign user ready history (that is the unique value per record in campaign user ready history) |
cuah_id | 29 | character varying | d646-53a91d0a-ses-agent-4907-2 | It contains the unique ID of the campaign user Auto-Call history. |
cuah_campaign_id | 30 | Integer | 1 | It is the campaign ID in which Auto-Call state changed |
cuah_session_id | 31 | character varying | d646-53a91d0a-ses-agent-4907-2 | It contains the session ID of the user. |
cuah_auto_call_on_start_time | 32 | timestamp without time zone | 06/24/14 12:48 PM | It contains the time when user set Auto-Call On status. |
cuah_auto_call_on_end_time | 33 | timestamp without time zone | 06/24/14 12:48 PM | It contains the time when user set Auto-Call Off status. |
cuah_auto_call_off_end_time | 34 | timestamp without time zone | 06/24/14 12:48 PM | It contains the time when user set Auto-Call On status again. |
cuah_end_reason | 35 | character varying | agent_selected_campaign | It is the Auto-Call end reason. |
cuah_contact_center_id | 36 | Integer | 1 | It is the ID of the contact centre. |
cuah_auto_call_start_reason | 37 | character varying | agent_set_ready | It contains the reason for which the Auto-Call status has been changed to On. |
cuah_archive_id | 38 | bigint | 6 | It is the archive ID of campaign user Auto-Call history (that is unique value per record in campaign user autocall history) |
curh_contributed_ready_duration | 39 | bigint | 0 | It is the contributed ready duration in the interval. |
curh_ready_tag | 40 | boolean | | |
curh_contributed_break_duration | 41 | bigint | 7749 | It is the contributed break duration in the interval. |
curh_break_tag | 42 | boolean | | |
curh_total_ready_duration | 43 | bigint | 0 | It is the total ready duration of the user. |
curh_total_break_duration | 44 | bigint | 7749 | It is the total break duration of the user. |
cuah_contributed_auto_call_on_duration | 45 | bigint | 0 | It is the total contributed Auto-Call On duration in the interval. |
cuah_contributed_auto_call_off_duration | 46 | bigint | 7749 | It is the total contributed Auto-Call Off duration in the interval. |
cuah_total_auto_call_on_duration | 47 | bigint | 0 | It is the total Auto-Call On duration in the interval. |
cuah_total_auto_call_off_duration | 48 | bigint | 7749 | It is the total Auto-Call Off duration in the interval. |
cuah_interval_start_time | 49 | timestamp without time zone | 06/24/14 12:40 PM | It is the interval start time for the campaign user Auto-Call history. |
cuah_interval_end_time | 50 | timestamp without time zone | 06/24/14 12:40 PM | It is the interval end time for the campaign user Auto-Call history. |
curh_interval_start_time | 51 | timestamp without time zone | 06/24/14 12:40 PM | It is the interval start time for the campaign user ready history. |
curh_interval_end_time | 52 | timestamp without time zone | 06/24/14 12:40 PM | It is the interval end time for the campaign user ready history. |
curh_rec_no | 53 | Integer | 1 | It is the curh rec numbers when split in intervals. |
cuah_rec_no | 54 | Integer | 1 | It is the cuah record number when split in intervals. |
ush_rec_no | 55 | Integer | 1 | It contains the ush record number when split in intervals. |
curh_record_number_in_interval | 56 | Integer | 1 | It is total number of curh rec_number in interval (count increases with join entries). |
ush_record_number_in_interval | 57 | Integer | 1 | It is the ush rec_number in interval (count increases with join entries). |
campaign_name | 58 | character varying | Outbound | It is the name of the campaign. |
process_name | 59 | character varying | Outbound | It is the name of the process. |
Username | 60 | character varying | Agent | It contains the name of the user. |
interval_start_30_minutes | 61 | timestamp without time zone | 06/24/14 12:30 PM | It is the start time of the 30-minute interval. |
interval_end_30_minutes | 62 | timestamp without time zone | 06/24/14 12:30 PM | It is the end time of the 30-minute interval. |
interval_start_hour | 63 | timestamp without time zone | 06/24/14 12:30 PM | It is the start time of the 1-hour interval. |
interval_end_hour | 64 | timestamp without time zone | 06/24/14 12:30 PM | It is the end time of the 1-hour interval. |
interval_start_day | 65 | timestamp without time zone | 06/24/14 12:30 PM | It contains the start time of the day interval. |
interval_end_day | 66 | timestamp without time zone | 06/24/14 12:30 PM | It contains the end time of the day interval. |