--- title: ACD_Interval_Denormalized_Entity Table slug: contact-center/acdintervaldenormalizedentity-table docTags: createdAt: 2025-12-28T17:53:32.957Z --- The following table contains the list, definition, and data attributes of columns of acd\_interval\_denormalized\_entity table. :::hint{type="info"} 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. |