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