{"id":155,"date":"2016-06-10T14:13:05","date_gmt":"2016-06-10T14:13:05","guid":{"rendered":"http:\/\/symbioticindia.in\/docu\/?p=155"},"modified":"2016-06-10T14:13:05","modified_gmt":"2016-06-10T14:13:05","slug":"data-structure-of-vicidial_list","status":"publish","type":"post","link":"http:\/\/symbioticindia.in\/docu\/2016\/06\/10\/data-structure-of-vicidial_list\/","title":{"rendered":"Data Structure of vicidial_list"},"content":{"rendered":"

Most of these fields are visible in \/vicidial\/admin_modify_lead.php?lead_id={LEAD_ID} and\/or on the agent screen. If so, they are marked “admin_modify_lead” or “agent screen” (or “both”).<\/p>\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\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
lead_id<\/td>\nUnique ID for leads, incrementing<\/td>\nadmin_modify_lead<\/td>\n<\/tr>\n
entry_date<\/td>\nDate\/time lead imported<\/td>\n<\/td>\n<\/tr>\n
modify_date<\/td>\nDate\/time of last modification<\/td>\nEnforced by mysql code<\/td>\n<\/tr>\n
status<\/td>\nDisposition\/Status (NEW, DROP)<\/td>\nadmin_modify_lead<\/td>\n<\/tr>\n
user<\/td>\nvicidial user<\/td>\nadmin_modify_lead<\/td>\n<\/tr>\n
vendor_lead_code<\/td>\nvendor id<\/td>\nboth<\/td>\n<\/tr>\n
this field is used to link “multi-lead” alt phones together and is also often used to link to external databases such as CRMs<\/th>\n<\/tr>\n
source_id<\/td>\nused to link to external databases as either a unique record or a category<\/td>\n<\/td>\n<\/tr>\n
list_id<\/td>\nList containing the lead_id<\/td>\nUsed to link the lead to a campaign.<\/td>\n<\/tr>\n
gmt_offset_now<\/td>\nTime Zone<\/td>\nCalculated during import and again nightly with perl script<\/td>\n<\/tr>\n
called_since_last_reset<\/td>\nHas the lead been called<\/td>\nResetting this value to Zero allows the lead to be called again. Cannot be called if set to 1.<\/td>\n<\/tr>\n
phone_code<\/td>\nDial Code (1 in US, or could be 44 or 01144 for UK)<\/td>\nboth<\/td>\n<\/tr>\n
phone_number<\/td>\nPhone Number<\/td>\nboth<\/td>\n<\/tr>\n
title<\/td>\nTitle<\/td>\nboth<\/td>\n<\/tr>\n
first_name<\/td>\nFirst name<\/td>\nboth<\/td>\n<\/tr>\n
middle_initial<\/td>\nMiddle Initial<\/td>\nboth<\/td>\n<\/tr>\n
last_name<\/td>\nLast name<\/td>\nboth<\/td>\n<\/tr>\n
address1<\/td>\nPrimary Street Address<\/td>\nboth<\/td>\n<\/tr>\n
address2<\/td>\nAddress 2<\/td>\nboth<\/td>\n<\/tr>\n
address3<\/td>\nAddress 3<\/td>\nboth<\/td>\n<\/tr>\n
city<\/td>\nCity<\/td>\nboth<\/td>\n<\/tr>\n
state<\/td>\nState<\/td>\nboth<\/td>\n<\/tr>\n
province<\/td>\nProvince if outside CUSA<\/td>\nboth<\/td>\n<\/tr>\n
postal_code<\/td>\nPostal(ZIP) Code<\/td>\nboth<\/td>\n<\/tr>\n
country_code<\/td>\nCountry<\/td>\nadmin_modify_lead<\/td>\n<\/tr>\n
used to assist in GMT calculation. Two character code. ie: US or CA<\/th>\n<\/tr>\n
gender<\/td>\nGender<\/td>\nboth<\/td>\n<\/tr>\n
date_of_birth<\/td>\nBirthdate<\/td>\nadmin_modify_lead.php<\/td>\n<\/tr>\n
alt_phone<\/td>\nSecond Phone Number<\/td>\nboth<\/td>\n<\/tr>\n
email<\/td>\nemail<\/td>\nboth<\/td>\n<\/tr>\n
security_phrase<\/td>\nLabeled as “Show” in agent screen<\/td>\nboth<\/td>\n<\/tr>\n
comments<\/td>\nComments<\/td>\nboth<\/td>\n<\/tr>\n
called_count<\/td>\nNumber of times this lead has been called<\/td>\n<\/td>\n<\/tr>\n
last_local_call_time<\/td>\ndate and time of the last call<\/td>\n<\/td>\n<\/tr>\n
rank<\/td>\n<\/td>\nadmin_modify_lead<\/td>\n<\/tr>\n
owner<\/td>\nName of user that can dial lead if configured for owner dialing<\/td>\nadmin_modify_lead<\/td>\n<\/tr>\n
entry_list_id<\/td>\noriginal list id during import<\/td>\nif using custom fields, this is the “home” list id where those fields are kept.<\/td>\n<\/tr>\n
If the lead is moved between lists, this field must be populated to link to the field structure (and custom field record).<\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n

vicidial\/admin_modify_lead.php<\/p>\n

<\/h1>\n","protected":false},"excerpt":{"rendered":"

Most of these fields are visible in \/vicidial\/admin_modify_lead.php?lead_id={LEAD_ID} and\/or on the agent screen. If so, they are marked “admin_modify_lead” or “agent screen” (or “both”). Field Name Description Location lead_id Unique ID for leads, incrementing admin_modify_lead entry_date Date\/time lead imported modify_date Date\/time of last modification Enforced by mysql code status Disposition\/Status (NEW, DROP) admin_modify_lead user vicidial ..<\/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,25,23],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-asterisk","category-goautodial","category-vicidial"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/155","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=155"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":156,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/155\/revisions\/156"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}