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. |