Campaign_Agent_Productivity_Per_Interval_Summary Table
The following table contains the list, definitions, and data attributes of the columns of campaign_agent_productivity_per_interval_summary table.
All durations given here are in milliseconds.
Column Name | Position | Source Data Type | Sample Value | Column Description |
|---|---|---|---|---|
interval_start_day | 1 | timestamp without time zone | 09/21/15 05:00 PM | It contains the day when the call is started |
interval_end_day | 2 | timestamp without time zone | 09/21/15 05:00 PM | It contains the day when the call is ended. |
interval_start_hour | 3 | timestamp without time zone | 09/21/15 05:00 PM | It contains the hour when the call is started. |
interval_end_hour | 4 | timestamp without time zone | 09/21/15 05:00 PM | It contains the hour when the call is ended. |
interval_start_30_minutes | 5 | timestamp without time zone | 09/21/15 05:00 PM | It contains the time when 30-minute interval in the call is started. |
interval_end_30_minutes | 6 | timestamp without time zone | 09/21/15 05:00 PM | It contains the time when the 30-minute interval is ended. |
contact_center_id | 7 | integer | 1 | It contains the Contact Centre ID in which the call is done. |
process_name | 8 | character varying | Outbound | It is the name of the Process from which the call is done. |
campaign_name | 9 | character varying | Outbound | It is the name of the campaign in which the call is done. |
campaign_id | 10 | integer | 1 | It is the ID of the campaign in which the call is done. |
user_name | 11 | character varying | agent | It shows the name of the user who have initiated the call. |
user_id | 12 | character varying | agent | It contains the ID of the user who initiated the call. |
auto_on_inbound_calls | 13 | integer | 10 | It contains the total count of inbound calls answered in the 10-minutes interval during the Auto-Call On status. |
auto_on_offered_inbound_calls | 14 | integer | 33 | It shows the total count of inbound calls offered to the user during the Auto-Call On status. |
auto_on_inbound_calls_ringing_time | 15 | bigint | 30000 | It shows the total ringing time of inbound calls during the Auto-Call On status. |
auto_on_inbound_calls_talktime | 16 | bigint | 534543 | It is the total talk time of the user during the Auto-Call On status. |
auto_on_inbound_calls_talktime_in_interval | 17 | bigint | 44364 | It is the total talk time in the 10-minute interval during the Auto-Call On status. |
auto_on_inbound_calls_wraptime | 18 | bigint | 646456 | It is the total wrap time of the user during the Auto-Call On status. |
auto_on_inbound_calls_wraptime_in_interval | 19 | bigint | 43564 | It is the total wrap time of the user in the 10-minute interval during the Auto-Call On status. |
auto_off_inbound_calls | 20 | integer | 56 | It is the total number of inbound calls answered in the 10-minute interval during the Auto-Call Off status. |
auto_off_offered_inbound_calls | 21 | integer | 46 | It is the total number of inbound calls offered to the user during the Auto-Call Off status. |
auto_off_inbound_calls_ringing_time | 22 | bigint | 554754 | It is the total inbound calls ringing time during the Auto-Call Off status |
auto_off_inbound_calls_talktime | 23 | bigint | 54654654 | It is the total talk time of the user during the Auto-Call Off status |
auto_off_inbound_calls_talktime_in_interval | 24 | bigint | 3523535 | It is the total talk time in the 10-minute interval during the Auto-Call Off status |
auto_off_inbound_calls_wraptime | 25 | bigint | 2353 | It is the total wrap time of the user during the Auto-Call Off status |
auto_off_inbound_calls_wraptime_in_interval | 26 | bigint | 354355 | It is the total wrap time of the user in the 10-minute interval during the Auto-Call Off status. |
auto_on_dialer_calls | 27 | integer | 10 | It is the total number of outbound calls made by the dialler for the user during the Auto-Call On status |
auto_on_offered_dialer_calls | 28 | integer | 12 | It is the total number of outbound offered call by the dialer to user during the Auto-Call On status |
auto_on_dialer_calls_ringing_time | 29 | bigint | 454464 | It is the total ringing time for the outbound calls made during the Auto-Call On status. |
auto_on_dialer_calls_talktime | 30 | bigint | 4546456 | It is the total talk time of the outbound calls made during the Auto-Call On status |
auto_on_dialer_calls_talktime_in_interval | 31 | bigint | 4646456 | It is the total talk time of the outbound calls made in the 10-minute interval during the Auto-Call On status. |
auto_on_dialer_calls_wraptime | 32 | bigint | 46456456 | It is the total wrap time of the outbound calls made during the Auto-Call On status |
auto_on_dialer_calls_wraptime_in_interval | 33 | bigint | 54657 | It is the total wrap time of the outbound calls in the 10-minute interval during the Auto-Call On status |
auto_off_dialer_calls | 34 | integer | 67 | It is the total number of outbound calls made by dialer for the user during the Auto-Call Off status. |
auto_off_offered_dialer_calls | 35 | integer | 55 | It is the total number of outbound offered calls by the dialer to the user during the Auto-Call Off Status. |
auto_off_dialer_calls_ringing_time | 36 | bigint | 654765 | It is the total ringing time of the outbound calls made during the Auto-Call Off status |
auto_off_dialer_calls_talktime | 37 | bigint | 56456 | It is the total talk time of the outbound calls made during the Auto-Call Off status |
auto_off_dialer_calls_talktime_in_interval | 38 | bigint | 324234 | It is the total talk time of the outbound calls made in the 10-minute interval during the Auto-Call Off status |
auto_off_dialer_calls_wraptime | 39 | bigint | 2342 | It is the total wrap time of the outbound calls made during the Auto-Call Off status. |
auto_off_dialer_calls_wraptime_in_interval | 40 | bigint | 23423 | It is the total wrap time of the outbound calls made in the 10-minute interval during the Auto-Call Off status |
auto_on_manual_dial_calls | 41 | integer | 44 | It is the total number of manual dial calls made by the user during the Auto-Call On status |
auto_on_offered_manual_dial_calls | 42 | integer | 4 | It is the total number of the manual dial calls offered by the user during the Auto-Call On status |
auto_on_manual_dial_calls_ringing_time | 43 | bigint | 1890 | It is the total ringing time of the manual dial calls made during the Auto-Call on status |
auto_on_manual_dial_calls_talktime | 44 | bigint | 11165 | It is the total talk time of the manual dial calls made during the Auto-Call On status |
auto_on_manual_dial_calls_talktime_in_interval | 45 | bigint | 11165 | It is the total talk time of the manual dial calls made in the 10-minute interval during the Auto-Call On status |
auto_on_manual_dial_calls_wraptime | 46 | bigint | 27297 | It is the total wrap time for the manual dial calls made during the Auto-Call On status. |
auto_on_manual_dial_calls_wraptime_in_interval | 47 | bigint | 27297 | It is the total talk time for the manual dial calls made in the 10-minute interval during the Auto-Call On status. |
auto_off_manual_dial_calls | 48 | integer | 78 | It is the total number of manual dial calls made by the user during the Auto-Call Off status |
auto_off_offered_manual_dial_calls | 49 | integer | 56 | It is the total number of manual dial calls offered by the user during the Auto-Call Off status |
auto_off_manual_dial_calls_ringing_time | 50 | bigint | 577567 | It is the total ringing time for the manual dial calls made during the Auto-Call Off status |
auto_off_manual_dial_calls_talktime | 51 | bigint | 7979 | It is the total talk time for the manual dial calls made during the Auto-Call Off status |
auto_off_manual_dial_calls_talktime_in_interval | 52 | bigint | 797923 | It is the total talk time for the manual dial calls made in the 10-minute interval during the Auto-Call Off status |
auto_off_manual_dial_calls_wraptime | 53 | bigint | 73479 | It is the total wrap time for the manual dial calls made during the Auto-Call Off status |
auto_off_manual_dial_calls_wraptime_in_interval | 54 | bigint | 73874 | It is the total wrap time for the manual dial calls made in the 10-minute interval during the Auto-Call Off status |
auto_on_transfer_to_campaign_calls | 55 | integer | 67 | It is the total number of calls that are transferred to the campaign and answered by the user during the Auto-Call On status |
auto_on_offered_transfer_to_campaign_calls | 56 | integer | 0 | It is the total number of calls offered that are transferred to the campaign during the Auto-Call On status |
auto_on_transfer_to_campaign_calls_ringing_time | 57 | bigint | 3435 | It is the total ringing time for the calls that are transferred to the campaign during the Auto-Call On status |
auto_on_transfer_to_campaign_calls_talktime | 58 | bigint | 67867 | It is the total talk time for the calls that are transferred to the campaign during the Auto-Call On status |
auto_on_transfer_to_campaign_calls_talktime_in_interval | 59 | bigint | 768768 | It is the total talk time for the calls that are transferred to the campaign in the 10-minute interval during the Auto-Call On status |
auto_on_transfer_to_campaign_calls_wraptime | 60 | bigint | 6868 | It is the total wrap time for the calls that are transferred to the campaign during the Auto-Call On status |
auto_on_transfer_to_campaign_calls_wraptime_in_interval | 61 | bigint | 435345 | It is the total wrap time for the calls that are transferred to the campaign in the 10-minute interval during the Auto-Call On status |
auto_off_transfer_to_campaign_calls | 62 | integer | 55 | It is the total number of calls that are transferred to the campaign answered by the user during the Auto-Call Off status |
auto_off_offered_transfer_to_campaign_calls | 63 | integer | 79 | It is the total number of calls offered that are transferred to the campaign during the Auto-Call Off status |
auto_off_transfer_to_campaign_calls_ringing_time | 64 | bigint | 68678 | It is the total ringing time for the calls that are transferred to the campaign during the Auto-Call Off status |
auto_off_transfer_to_campaign_calls_talktime | 65 | bigint | 546546 | It is the total talk time for the calls that are transferred to the campaign during the Auto-Call Off status |
auto_off_transfer_to_campaign_calls_talktime_in_interval | 66 | bigint | 123123 | It is the total talk time for the calls that are transferred to the campaign in the 10-minute interval during the Auto-Call Off status |
auto_off_transfer_to_campaign_calls_wraptime | 67 | bigint | 23243 | It is the total wrap time for the calls that are transferred to the campaign during the Auto-Call Off status |
auto_off_transfer_to_campaign_calls_wraptime_in_interval | 68 | bigint | 2324 | It is the total wrap time for the calls that are transferred to the campaign in the 10-minute interval during the Auto-Call Off status |
auto_on_callback_calls | 69 | integer | 99 | It is the total number of callbacks answered by the user during the Auto-Call On status |
auto_on_offered_callback_calls | 70 | integer | 100 | It is the total number of callbacks offered during the Auto-Call On status |
auto_on_callback_calls_ringing_time | 71 | bigint | 67567 | It is the total ringing time for the callbacks attended during the Auto-Call On status |
auto_on_callback_calls_talktime | 72 | bigint | 34234 | It is the total talk time for the callback attended during the Auto-Call On status |
auto_on_callback_calls_talktime_in_interval | 73 | bigint | 23423 | It is the total talk time for the callbacks attended in the 10-minute interval during the Auto-Call On status |
auto_on_callback_calls_wraptime | 74 | bigint | 45456 | It is the total wrap time for the callbacks attended to the campaign during the Auto-Call On status |
auto_on_callback_calls_wraptime_in_interval | 75 | integer | 565 | It is the total wrap time for the callbacks attended in the 10-minute interval during the Auto-Call On status |
auto_off_callback_calls | 76 | integer | 12 | It is the total number of callbacks attended by the user during the Auto-Call Off status |
auto_off_offered_callback_calls | 77 | bigint | 23 | It is the total number of callback offered in the 10-minute interval during the Auto-Call Off status |
auto_off_callback_calls_ringing_time | 78 | bigint | 3434 | It is the total ringing time for the callbacks attended during the Auto-Call Off status |
auto_off_callback_calls_talktime | 79 | bigint | 24234 | It is the total talk time for the callbacks attended during the Auto-Call Off status |
auto_off_callback_calls_talktime_in_interval | 80 | bigint | 24234 | It is the total talk time for the callbacks attended in the 10-minute interval during the Auto-Call Off status |
auto_off_callback_calls_wraptime | 81 | bigint | 2434 | It is the total wrap time for the callbacks attended during the Auto-Call Off status |
auto_off_callback_calls_wraptime_in_interval | 82 | bigint | 24234 | It is the total talk time for the callbacks attended in the 10-minute interval during the Auto-Call Off status |
udh_talktime_in_interval | 83 | bigint | 3434 | It is the total user talk time of all calls done in the 10-minute interval. |
udh_wraptime_in_interval | 84 | bigint | 27297 | It is the total user wrap time in the 10-minute interval. |
total_ready_duration | 85 | bigint | 1527278 | It is the total user time spent in the ready state. |
total_break_duration | 86 | bigint | 8035 | It is the total number of break durations used by the user. |
total_auto_on_duration | 87 | bigint | 1527278 | It is the total time duration for which the user was on the Auto-Call On status. |
total_auto_off_duration | 88 | bigint | 8035 | It is the total time duration for which the user was on Auto-Call Off status. |