{"id":159,"date":"2016-06-10T14:14:25","date_gmt":"2016-06-10T14:14:25","guid":{"rendered":"http:\/\/symbioticindia.in\/docu\/?p=159"},"modified":"2016-06-27T17:54:18","modified_gmt":"2016-06-27T17:54:18","slug":"data-structure-of-vicidial_closer_log","status":"publish","type":"post","link":"http:\/\/symbioticindia.in\/docu\/2016\/06\/10\/data-structure-of-vicidial_closer_log\/","title":{"rendered":"Data Structure of vicidial_closer_log"},"content":{"rendered":"

vicidial_closer_log<\/span><\/h1>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field Name<\/th>\nDescription<\/th>\nLocation<\/th>\n<\/tr>\n
closecallid<\/td>\nclosed call table Primary key<\/td>\n<\/td>\n<\/tr>\n
lead_id<\/td>\nID of Lead<\/td>\nvicidial\/admin_modify_lead.php?lead_id=<\/td>\n<\/tr>\n
list_id<\/td>\nID of List<\/td>\nvicidial\/admin_modify_lead.php?lead_id=<\/td>\n<\/tr>\n
campaign_id<\/td>\nAlpha Numeric Campaign ID<\/td>\nfrom Vicidial Campaigns<\/td>\n<\/tr>\n
call_date<\/td>\nDate and Time call was made<\/td>\n<\/td>\n<\/tr>\n
start_epoch<\/td>\nStart of Call Time<\/td>\n<\/td>\n<\/tr>\n
end_epoch<\/td>\nEnd of Call Time<\/td>\n<\/td>\n<\/tr>\n
length_in_sec<\/td>\nTotal Length of call in seconds<\/td>\nvicidial\/AST_agent_performance_detail.php<\/td>\n<\/tr>\n
status<\/td>\nwhat happpened to the call<\/td>\nSamples: AFTHRS = did not match call times for an Ingroup or Call Menu; NANQUE = no agent was available<\/td>\n<\/tr>\n
phone_code<\/td>\nfrom lead record<\/td>\nvicidial\/admin_modify_lead.php?lead_id=<\/td>\n<\/tr>\n
phone_number<\/td>\nfrom lead record<\/td>\nvicidial\/admin_modify_lead.php?lead_id=<\/td>\n<\/tr>\n
user<\/td>\nUser ID<\/td>\nvicidial\/AST_agent_time_detail.php<\/td>\n<\/tr>\n
comments<\/td>\nExplanation related to Status in this table<\/td>\nMore information related to status: for instance: “After Hours Drop” when status is “AFTHRS”.<\/td>\n<\/tr>\n
processed<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
queue_seconds<\/td>\nWait time before arriving at an agent<\/td>\n<\/td>\n<\/tr>\n
user_group<\/td>\nuser group of agent who handled this call record<\/td>\n<\/td>\n<\/tr>\n
xfercallid<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
term_reason<\/td>\nCall Termination Reason<\/td>\nSamples: AGENT; ABANDON; CALLER<\/td>\n<\/tr>\n
uniqueid<\/td>\nUnique ID assigned by asterisk<\/td>\n<\/td>\n<\/tr>\n
agent_only<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
queue_position<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

vicidial_closer_log Field Name Description Location closecallid closed call table Primary key lead_id ID of Lead vicidial\/admin_modify_lead.php?lead_id= list_id ID of List vicidial\/admin_modify_lead.php?lead_id= campaign_id Alpha Numeric Campaign ID from Vicidial Campaigns call_date Date and Time call was made start_epoch Start of Call Time end_epoch End of Call Time length_in_sec Total Length of call in seconds vicidial\/AST_agent_performance_detail.php status ..<\/p>\n

<\/div>\n

Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,23],"tags":[],"class_list":["post-159","post","type-post","status-publish","format-standard","hentry","category-asterisk","category-vicidial"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"predecessor-version":[{"id":160,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/159\/revisions\/160"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}