ACD_Interval_Denormalized_Entity Table

the following table contains the list, definition, and data attributes of columns of acd interval denormalized entity table all the durations are here in milliseconds column name position source data type sample value column description setup id rec no,ch archive id,unique id) 1 character varying null for 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 ch archive id 3 bigint 205 it is the archive id of call history (that is unique value per record in call history ) rah archive id 4 bigint 217 it is the archive id of resourceallocation history (that is the unique value) rrh archive id 5 bigint 217 it is the archive id of resource request history (that is the unique value) rch archive id 6 bigint 188 it is the archive id of resource consumption history (that is the unique value) uch archive id 7 bigint 188 it is the archive id of user call history (that is the unique value) ch setup time 8 integer 254 it is the setup time for the customer ch ringing time 9 integer 5924 it contains the ringing time for the customer ch ringing start time 10 timestamp without time zone 11/26/14 09 06 pm it contains the ringing start time for the customer ch call id 11 character varying d693 547572ce vcall 5 it shows the id of the call ch call leg id 12 character varying d693 547572ce out call leg null1019 it shows the customer call leg id ch contact center id 13 integer 1 it contains the contact centre id ch process id 14 integer 1 it contains the process id ch campaign id 15 integer 1 it contains the id of the campaign ch phone 16 character varying 56547 it contains the phone number of the customer ch crt object id 17 character varying d693 547572ce vce 5 it contains the crt object id of the customer ch customer id 18 integer 111 it is the id of the customer ch lead id 19 integer 3 it contains the lead id in which the customer is present ch dialing comments 20 character varying 1234 it contains the dialing comments for inbound calls, it will contain the did number ch is outbound 21 boolean t it checks whether the call was inbound or outbound ch call type 22 character varying outbound manual dial it shows which type of the call such as outbound or inbound ch system disposition 23 character varying no answer it is the system disposition of the call ch date added 24 timestamp without time zone 06/24/14 06 09 pm it is the date and time added of the call ch call result 25 character varying failure it contains the call result ch hangup cause 26 character varying provider temp failure it contains the hang up cause ch hangup cause description 27 character varying request terminated it contains the description of the call hang up ch hangup cause code 28 character varying 487 it contains the hang up cause code ch hangup first 29 boolean t it is the hang up party ch hangup on hold 30 boolean f it contains a boolean value such as t or f to tell whether the customer hang up with on hold ch call originate time 31 timestamp without time zone 06/24/14 06 09 pm it is the call origination time ch call end time 32 timestamp without time zone 06/24/14 06 09 pm it is the call end time ch ivr time 33 timestamp without time zone 06/24/14 06 09 pm it is the total time that a customer spent in ivr ch talk time 34 timestamp without time zone 331398 it is the talk time of customer side ch hold time 35 timestamp without time zone 0 it contains the customer hold time ch recording file url 36 character varying 0 it contains the url of voicelog path ch nodeflow id 37 character varying d858 53a9667d nf 6 it is the nodeflow id it is used for the internal use that helps in the debugging of ivr related issues ch actual channel 38 character varying sip/901 00000003 it is the channel code of voip it’s value will be sip/xxxx yyyyyyy for pri and it’s value will be dahdi/xxx xxxxx ch column 1 39 character varying it is the call history additional parameters it is meant for customized usage the default is null ch value 1 40 character varying it is the call history additional parameters it is meant for customized usage the default value is null ch column 2 41 character varying it is the call history additional parameters it is meant for customized usage the default value is null ch value 2 42 character varying it is the call history additional parameters it is meant for customized usage the default value is null ch column 3 43 character varying it is the call history additional parameters it is meant for customized usage the default value is null ch value 3 44 character varying it is the call history additional parameters it is meant for customized usage the default value is null ch connection state 45 character varying it is the call history additional parameters to show the connection state it is meant for customized usage the default value is null ch connection state data 46 character varying it is the call history additional parameters to show the connection state it is meant for customized usage the default value is null ch customer source 47 character varying it is the call history additional parameters to show the customer source it is meant for customized usage the default value is null ch is test call 48 boolean it is the call history additional parameters it is meant for customized usage the default value is null ch num attempts 49 integer it is meant for future usage related to the number of attempts ch hangup details 50 character varying it contains the hang up details ch related crt object id 51 character varying it contains the call unique id for the calls created in case of local ivr conference ch nodeflow meta data 52 character varying it is the call history additional parameters related to the nodeflow metadata it is meant for customized usage the default value is null ch dialed call details 53 character varying {"d858 53a9667d out call leg null1007" {"4535" "ringing"}} it is the call history additional parameters for dialed call details it is meant for customized usage the default value is null ch crm url 54 character varying http //10 10 2 184 8786/crm1/ customer php? it contains the crm url formed to show the customer details in the pop up ch src phone 55 character varying 9999999990 it the name of the customer for the inbound call ch dst phone 56 character varying 1234 / 1234567890 it is the destination number in case of inbound call and the customer number in case of outbound call udh id 57 character varying d858 53a9667d user disp h 2 it contains the uniqueue id from users disposition history udh call id 58 character varying d858 53a9667d vcall 2d858 53a9667d out call leg softphone11005 it is the unique call id udh call leg id 59 character varying it is the user call leg id udh date added 60 timestamp without time zone 06/24/14 06 09 pm it contains the date added udh user disposition time 61 timestamp without time zone 06/24/14 06 09 pm it contains the disposition time udh transfer time 62 timestamp without time zone it is the call transfer time udh transfer to 63 character varying it shows to whom the call is transferred udh disposition details 64 character varying campaign system disposition it contains the disposition details udh disposition class 65 character varying others it contains the disposition class that belongs to the disposition code udh disposition code 66 character varying foreign language it contains the disposition code ofthe call udh user id 67 character varying agent it is the user id for the call udh session id 68 character varying d858 53a9667d ses agent 8098 0 it is the user session id of the user who have handled the call udh user crt object id 69 character varying d858 53a9667d ses agent 8098 0 uce 67567\@2 it is the user call leg id it is always unique udh wrap time 70 integer 300430 it is the total time (in milliseconds) took by the agent to dispose the call udh talk time 71 integer 0 it is the user talk time udh working 72 boolean t it shows user ready and break status while disposing of the call udh campaign team id 73 integer it is meant for future usage udh campaign team id 74 boolean it shows whether the call is disposed of by the crm or not udh agent queue id 75 integer it contains the id of the queue in which the call was answered udh auto call on time 76 integer 336463 it is the user auto call on time while on a particular call udh auto call off time 77 integer 0 it is the user auto call off time while on a particular call udh user connected time 78 timestamp without time zone 06/24/14 06 09 pm it is the time stamp when the user got the call udh user disconnected time 79 timestamp without time zone 06/24/14 06 09 pm it contains the time when the call gets disconnected at the user end udh campaign id 80 integer 1 it is the campaign id udh association type 81 character varying manualdial association it is association type (system parameters) udh request id 82 character varying d858 53a9667d res req 2 it contains the request id uch call leg id 83 character varying d858 53a9667d out call leg softphone11005 it contains the call leg id uch user id 84 character varying agent it contains the user id uch session id 85 character varying d858 53 it contains the session id uch crt object id 86 character varying a9667d ses agent 8098 0 it contains the customer call id it is a unique value uch setup time 87 integer 454 it contains the user call leg setup time uch ringing time 88 integer 4686 it contains the user call leg ring time uch talk time 89 integer 30979 it contains the user call leg talk time uch date added 90 timestamp without time zone 06/24/14 06 09 pm it contains the date added uch id 91 integer uch phone 92 character varying it contains the phone number of user channel (if call context not end point) uch call context id 93 integer 2 it contains the call context id for the user call leg uch ringing start time 94 timestamp without time zone 06/24/14 06 09 pm it contains the ring time that is started on user channel uch call originate time 95 timestamp without time zone 06/24/14 06 09 pm it contains the user channel originate time rah id 96 bigint 19 it contains the unique id of the resource allocation history rah request id 97 character varying d858 53a9667d res req 2 it is the request id of the request that is allocated rah wait time 98 bigint 31 it is the wait time for the request that is allocated rah result 99 character varying allocated it is the result of the request (for example allocated, timed out, and others rah allocated resource 100 character varying d858 53a9667d ses agent 8098 0 it is the session id of the user to whom the request was allocated rah date added 101 timestamp without time zone 06/24/14 06 09 pm it contains date added rch id 102 bigint 16 it shows the unique id of resource consumption history rch request id 103 character varying d858 53a9667d res req 2 it is the request id of request that was being consumed rch service time 104 bigint 336657 it is the total service time for a request rch allocated resource 105 character varying d858 53a9667d ses agent 8098 0 it shows the session id of the user who served the request rch date added 106 timestamp without time zone 06/24/14 06 14 pm it contains the date added rrh id 107 bigint it contains the unique id of resource request history rrh request id 108 character varying d858 53a9667d res req 2 it is the id of the request a new request id is generated for a request each time it is reacd ed rrh request time 109 timestamp without time zone 06/24/14 06 09 pm it is the time at which request arrived at acd node rrh media type 110 character varying voicemedia it contains the media type of the request (for example voicemedia, chatmedia, and others) rrh constraint type 111 character varying constraint context type campaign it is the constraint type where request arrived (for example, contact centre, campaign, queue, and others) rrh constraint id 112 integer 1 it contains the id of the constraint type where request arrived (for example, contactcenterid, campaignid, queueid) rrh mrt object id 113 character varying d858 53a9667d vce 2 it is the mrt object id of the request rrh source context id 114 integer 1 rrh request type 115 character varying multipleextensionspecificresourcerequest it is the request type of the request (for example, multipleextensionrespecificresourcerequest, voicemultipleextensionresourcerequest, chatresourcerequest, and others) rrh association type 116 character varying manualdial association it is the association type due to which request hit acd (for example, manualdial, callbackdial, inbounddial, and others) rrh date added 117 timestamp without time zone 06/24/14 06 09 pm it contains the date added first queue hit 118 boolean t it contains the queue id of the first queue in which request entered first queue answered 119 boolean 20 it contains the queue id of the first queue in which the request was answered unique id 120 bigint it contains the unique id of the table max request time 121 timestamp without time zone it is the maximum request time for all requests min request time 122 timestamp without time zone it is the minimum request time for all requests rrh source context type 123 character varying campaign rec no 124 integer 1 it is the number for a record that has been split in intervals interval start 125 timestamp without time zone 06/24/14 06 10 pm it is the start time of the interval interval end 126 timestamp without time zone 06/24/14 06 10 pm it contains the end time of the interval interval start 30 minutes 127 timestamp without time zone 06/24/14 06 10 pm it is the start time of the 30 minute interval interval end 30 minutes 128 timestamp without time zone 06/24/14 06 10 pm it contains the end time of the 30 minute interval interval start hour 129 timestamp without time zone 06/24/14 06 10 pm it contains the start time of the 1 hour interval interval end hour 130 timestamp without time zone 06/24/14 06 10 pm it contains the end time of the 1 hour interval interval start day 131 timestamp without time zone 06/24/14 06 10 pm it contains the start time of the day interval interval end day 132 timestamp without time zone 06/25/14 06 10 pm it contains the end time of the day interval ch setup time in interval 133 bigint 810 it is the setup time of the customer in a particular interval uch setup time in interval 134 bigint 454 it shows the setup time of user in a particular interval uch ringing time in interval 135 bigint 4686 it is the ringing time of a user in a particular interval udh talk time in interval 136 bigint 0 it contains the talk time of a user in a particular interval udh wrap time in interval 137 bigint 0 it contains the wrap time of a user in a particular interval rah wait time in interval 138 bigint 31 it contains the wait time for a request in a particular interval ch ringing time in interval 139 bigint 30067 it contains the ringing time of the customer in a particular interval total talk time 140 integer 0 it is the total talk time for a customer total wait time 141 integer 31 it is the total wait time for a particular inbound call cumulative wait time 142 bigint 31 it is the total wait time for a request upto a particular interval it increases if a request was waiting in the later intervals also campaign name 143 character varying outbound it contains the name of the campaign username 144 character varying agent it contains the name of the user process name 145 character varying outbound it contains the name of the process queue name 146 character varying it contains the name of the queue udh preview duration 147 integer it contains the preview duration of the call udh preview start time 148 timestamp without time zone it contains the preview start time of the call udh preview time in interval 149 bigint 0 it contains the preview time of the call in the interval archiver comments 150 character varying it contains the archiver comments, if any ch filter source 151 character varying like 98% the filter used to fetch a number from the lead file ch dialled phone 152 character varying null in general cases it is not used for the normal releases, which is equivalent to dst phone