Notice error: unserialize(): Error at offset when searching on contacts

a:90:{s:2:"id";a:10:{s:4:"name";s:2:"id";s:4:"type";i:1;s:5:"title";s:10:"Contact ID";s:11:"description";s:17:"Unique Contact ID";s:8:"required";b:1;s:6:"import";b:1;s:5:"where";s:18:"civicrm_contact.id";s:13:"headerPattern";s:24:"/internal|contact?|id$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;}s:12:"contact_type";a:12:{s:4:"name";s:12:"contact_type";s:4:"type";i:2;s:5:"title";s:12:"Contact Type";s:11:"description";s:16:"Type of Contact.";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"export";b:1;s:5:"where";s:28:"civicrm_contact.contact_type";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:4:{s:5:"table";s:20:"civicrm_contact_type";s:9:"keyColumn";s:4:"name";s:11:"labelColumn";s:5:"label";s:9:"condition";s:17:"parent_id IS NULL";}}s:16:"contact_sub_type";a:13:{s:4:"name";s:16:"contact_sub_type";s:4:"type";i:2;s:5:"title";s:15:"Contact Subtype";s:11:"description";s:57:"May be used to over-ride contact view and edit templates.";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:32:"civicrm_contact.contact_sub_type";s:13:"headerPattern";s:41:"/C(ontact )?(subtype|sub-type|sub type)/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:4:{s:5:"table";s:20:"civicrm_contact_type";s:9:"keyColumn";s:4:"name";s:11:"labelColumn";s:5:"label";s:9:"condition";s:21:"parent_id IS NOT NULL";}}s:12:"do_not_email";a:9:{s:4:"name";s:12:"do_not_email";s:4:"type";i:16;s:5:"title";s:12:"Do Not Email";s:6:"import";b:1;s:5:"where";s:28:"civicrm_contact.do_not_email";s:13:"headerPattern";s:23:"/d(o )?(not )?(email)/i";s:11:"dataPattern";s:10:"/^\d{1,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:12:"do_not_phone";a:9:{s:4:"name";s:12:"do_not_phone";s:4:"type";i:16;s:5:"title";s:12:"Do Not Phone";s:6:"import";b:1;s:5:"where";s:28:"civicrm_contact.do_not_phone";s:13:"headerPattern";s:28:"/d(o )?(not )?(call|phone)/i";s:11:"dataPattern";s:10:"/^\d{1,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:11:"do_not_mail";a:9:{s:4:"name";s:11:"do_not_mail";s:4:"type";i:16;s:5:"title";s:11:"Do Not Mail";s:6:"import";b:1;s:5:"where";s:27:"civicrm_contact.do_not_mail";s:13:"headerPattern";s:45:"/^(d(o\s)?n(ot\s)?mail)|(\w*)?bulk\s?(\w*)$/i";s:11:"dataPattern";s:10:"/^\d{1,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:10:"do_not_sms";a:9:{s:4:"name";s:10:"do_not_sms";s:4:"type";i:16;s:5:"title";s:10:"Do Not Sms";s:6:"import";b:1;s:5:"where";s:26:"civicrm_contact.do_not_sms";s:13:"headerPattern";s:21:"/d(o )?(not )?(sms)/i";s:11:"dataPattern";s:10:"/^\d{1,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:12:"do_not_trade";a:9:{s:4:"name";s:12:"do_not_trade";s:4:"type";i:16;s:5:"title";s:12:"Do Not Trade";s:6:"import";b:1;s:5:"where";s:28:"civicrm_contact.do_not_trade";s:13:"headerPattern";s:23:"/d(o )?(not )?(trade)/i";s:11:"dataPattern";s:10:"/^\d{1,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:10:"is_opt_out";a:11:{s:4:"name";s:10:"is_opt_out";s:4:"type";i:16;s:5:"title";s:29:"No Bulk Emails (User Opt Out)";s:11:"description";s:93:"Has the contact opted out from receiving all bulk email from the organization or site domain?";s:8:"required";b:1;s:6:"import";b:1;s:5:"where";s:26:"civicrm_contact.is_opt_out";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:16:"legal_identifier";a:12:{s:4:"name";s:16:"legal_identifier";s:4:"type";i:2;s:5:"title";s:16:"Legal Identifier";s:11:"description";s:104:"May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.
    ";s:9:"maxlength";i:32;s:4:"size";i:20;s:6:"import";b:1;s:5:"where";s:32:"civicrm_contact.legal_identifier";s:13:"headerPattern";s:13:"/legal\s?id/i";s:11:"dataPattern";s:12:"/\w+?\d{5,}/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:19:"external_identifier";a:12:{s:4:"name";s:19:"external_identifier";s:4:"type";i:2;s:5:"title";s:19:"External Identifier";s:11:"description";s:113:"Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.";s:9:"maxlength";i:64;s:4:"size";i:8;s:6:"import";b:1;s:5:"where";s:35:"civicrm_contact.external_identifier";s:13:"headerPattern";s:16:"/external\s?id/i";s:11:"dataPattern";s:11:"/^\d{11,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:9:"sort_name";a:11:{s:4:"name";s:9:"sort_name";s:4:"type";i:2;s:5:"title";s:9:"Sort Name";s:11:"description";s:45:"Name used for sorting different contact types";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"export";b:1;s:5:"where";s:25:"civicrm_contact.sort_name";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:12:"display_name";a:11:{s:4:"name";s:12:"display_name";s:4:"type";i:2;s:5:"title";s:12:"Display Name";s:11:"description";s:76:"Formatted name representing preferred format for display/print/other output.";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"export";b:1;s:5:"where";s:28:"civicrm_contact.display_name";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:9:"nick_name";a:12:{s:4:"name";s:9:"nick_name";s:4:"type";i:2;s:5:"title";s:8:"Nickname";s:11:"description";s:9:"Nickname.";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.nick_name";s:13:"headerPattern";s:21:"/n(ick\s)name|nick$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:10:"legal_name";a:12:{s:4:"name";s:10:"legal_name";s:4:"type";i:2;s:5:"title";s:10:"Legal Name";s:11:"description";s:11:"Legal Name.";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:26:"civicrm_contact.legal_name";s:13:"headerPattern";s:27:"/^legal|(l(egal\s)?name)$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:9:"image_URL";a:10:{s:4:"name";s:9:"image_URL";s:4:"type";i:32;s:5:"title";s:9:"Image Url";s:11:"description";s:81:"optional URL for preferred image (photo, logo, etc.) to display for this contact.";s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.image_URL";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"File";}}s:30:"preferred_communication_method";a:13:{s:4:"name";s:30:"preferred_communication_method";s:4:"type";i:2;s:5:"title";s:30:"Preferred Communication Method";s:11:"description";s:44:"What is the preferred mode of communication.";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:46:"civicrm_contact.preferred_communication_method";s:13:"headerPattern";s:37:"/^p(ref\w*\s)?c(omm\w*)|( meth\w*)$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:2:{s:15:"optionGroupName";s:30:"preferred_communication_method";s:14:"optionEditPath";s:52:"civicrm/admin/options/preferred_communication_method";}}s:18:"preferred_language";a:13:{s:4:"name";s:18:"preferred_language";s:4:"type";i:2;s:5:"title";s:18:"Preferred Language";s:11:"description";s:87:"Which language is preferred for communication. FK to languages in civicrm_option_value*_en_CA*.";s:9:"maxlength";i:5;s:4:"size";i:6;s:6:"import";b:1;s:5:"where";s:34:"civicrm_contact.preferred_language";s:13:"headerPattern";s:8:"/^lang/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:3:{s:15:"optionGroupName";s:9:"languages";s:9:"keyColumn";s:4:"name";s:14:"optionEditPath";s:31:"civicrm/admin/options/languages";}}s:21:"preferred_mail_format";a:14:{s:4:"name";s:21:"preferred_mail_format";s:4:"type";i:2;s:5:"title";s:21:"Preferred Mail Format";s:11:"description";s:47:"What is the preferred mode of sending an email.";s:9:"maxlength";i:8;s:4:"size";i:8;s:6:"import";b:1;s:5:"where";s:37:"civicrm_contact.preferred_mail_format";s:13:"headerPattern";s:35:"/^p(ref\w*\s)?m(ail\s)?f(orm\w*)$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:7:"default";s:4:"Both";s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:1:{s:8:"callback";s:26:"CRM_Core_SelectValues::pmf";}}s:4:"hash";a:10:{s:4:"name";s:4:"hash";s:4:"type";i:2;s:5:"title";s:12:"Contact Hash";s:11:"description";s:52:"Key for validating requests related to this contact.";s:9:"maxlength";i:32;s:4:"size";i:20;s:6:"export";b:1;s:5:"where";s:20:"civicrm_contact.hash";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";}s:14:"contact_source";a:12:{s:4:"name";s:6:"source";s:4:"type";i:2;s:5:"title";s:14:"Contact Source";s:11:"description";s:61:"where contact come from, e.g. import, donate module insert...";s:9:"maxlength";i:255;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:22:"civicrm_contact.source";s:13:"headerPattern";s:24:"/(C(ontact\s)?Source)$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:10:"first_name";a:12:{s:4:"name";s:10:"first_name";s:4:"type";i:2;s:5:"title";s:10:"First Name";s:11:"description";s:11:"First Name.";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:26:"civicrm_contact.first_name";s:13:"headerPattern";s:27:"/^first|(f(irst\s)?name)$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:11:"middle_name";a:12:{s:4:"name";s:11:"middle_name";s:4:"type";i:2;s:5:"title";s:11:"Middle Name";s:11:"description";s:12:"Middle Name.";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:27:"civicrm_contact.middle_name";s:13:"headerPattern";s:29:"/^middle|(m(iddle\s)?name)$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:9:"last_name";a:12:{s:4:"name";s:9:"last_name";s:4:"type";i:2;s:5:"title";s:9:"Last Name";s:11:"description";s:10:"Last Name.";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.last_name";s:13:"headerPattern";s:25:"/^last|(l(ast\s)?name)$/i";s:11:"dataPattern";s:16:"/^\w+(\s\w+)?+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:9:"prefix_id";a:11:{s:4:"name";s:9:"prefix_id";s:4:"type";i:1;s:5:"title";s:17:"Individual Prefix";s:11:"description";s:53:"Prefix or Title for name (Ms, Mr...). FK to prefix ID";s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.prefix_id";s:13:"headerPattern";s:18:"/^(prefix|title)/i";s:11:"dataPattern";s:26:"/^(mr|ms|mrs|sir|dr)\.?$/i";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:2:{s:15:"optionGroupName";s:17:"individual_prefix";s:14:"optionEditPath";s:39:"civicrm/admin/options/individual_prefix";}}s:9:"suffix_id";a:11:{s:4:"name";s:9:"suffix_id";s:4:"type";i:1;s:5:"title";s:17:"Individual Suffix";s:11:"description";s:44:"Suffix for name (Jr, Sr...). FK to suffix ID";s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.suffix_id";s:13:"headerPattern";s:11:"/^suffix$/i";s:11:"dataPattern";s:20:"/^(sr|jr)\.?|i{2,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:2:{s:15:"optionGroupName";s:17:"individual_suffix";s:14:"optionEditPath";s:39:"civicrm/admin/options/individual_suffix";}}s:12:"formal_title";a:12:{s:4:"name";s:12:"formal_title";s:4:"type";i:2;s:5:"title";s:12:"Formal Title";s:11:"description";s:70:"Formal (academic or similar) title in front of name. (Prof., Dr. etc.)";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:28:"civicrm_contact.formal_title";s:13:"headerPattern";s:9:"/^title/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:22:"communication_style_id";a:10:{s:4:"name";s:22:"communication_style_id";s:4:"type";i:1;s:5:"title";s:19:"Communication Style";s:11:"description";s:124:"Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value*_en_CA*.";s:6:"export";b:1;s:5:"where";s:38:"civicrm_contact.communication_style_id";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:2:{s:15:"optionGroupName";s:19:"communication_style";s:14:"optionEditPath";s:41:"civicrm/admin/options/communication_style";}}s:9:"job_title";a:12:{s:4:"name";s:9:"job_title";s:4:"type";i:2;s:5:"title";s:9:"Job Title";s:11:"description";s:9:"Job Title";s:9:"maxlength";i:255;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.job_title";s:13:"headerPattern";s:24:"/^job|(j(ob\s)?title)$/i";s:11:"dataPattern";s:2:"//";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:9:"gender_id";a:11:{s:4:"name";s:9:"gender_id";s:4:"type";i:1;s:5:"title";s:6:"Gender";s:11:"description";s:15:"FK to gender ID";s:6:"import";b:1;s:5:"where";s:25:"civicrm_contact.gender_id";s:13:"headerPattern";s:11:"/^gender$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:6:"Select";}s:14:"pseudoconstant";a:2:{s:15:"optionGroupName";s:6:"gender";s:14:"optionEditPath";s:28:"civicrm/admin/options/gender";}}s:10:"birth_date";a:10:{s:4:"name";s:10:"birth_date";s:4:"type";i:4;s:5:"title";s:10:"Birth Date";s:11:"description";s:13:"Date of birth";s:6:"import";b:1;s:5:"where";s:26:"civicrm_contact.birth_date";s:13:"headerPattern";s:46:"/^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i";s:11:"dataPattern";s:21:"/\d{4}-?\d{2}-?\d{2}/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:11:"Select Date";}}s:11:"is_deceased";a:9:{s:4:"name";s:11:"is_deceased";s:4:"type";i:16;s:5:"title";s:8:"Deceased";s:6:"import";b:1;s:5:"where";s:27:"civicrm_contact.is_deceased";s:13:"headerPattern";s:21:"/i(s\s)?d(eceased)$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:13:"deceased_date";a:10:{s:4:"name";s:13:"deceased_date";s:4:"type";i:4;s:5:"title";s:13:"Deceased Date";s:11:"description";s:16:"Date of deceased";s:6:"import";b:1;s:5:"where";s:29:"civicrm_contact.deceased_date";s:13:"headerPattern";s:33:"/^deceased|(d(eceased\s)?date)$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:11:"Select Date";}}s:14:"household_name";a:12:{s:4:"name";s:14:"household_name";s:4:"type";i:2;s:5:"title";s:14:"Household Name";s:11:"description";s:15:"Household Name.";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:30:"civicrm_contact.household_name";s:13:"headerPattern";s:35:"/^household|(h(ousehold\s)?name)$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:17:"organization_name";a:12:{s:4:"name";s:17:"organization_name";s:4:"type";i:2;s:5:"title";s:17:"Organisation Name";s:11:"description";s:18:"Organization Name.";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:33:"civicrm_contact.organization_name";s:13:"headerPattern";s:41:"/^organization|(o(rganization\s)?name)$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:8:"sic_code";a:12:{s:4:"name";s:8:"sic_code";s:4:"type";i:2;s:5:"title";s:8:"Sic Code";s:11:"description";s:38:"Standard Industry Classification Code.";s:9:"maxlength";i:8;s:4:"size";i:8;s:6:"import";b:1;s:5:"where";s:24:"civicrm_contact.sic_code";s:13:"headerPattern";s:23:"/^sic|(s(ic\s)?code)$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:14:"user_unique_id";a:13:{s:4:"name";s:14:"user_unique_id";s:4:"type";i:2;s:5:"title";s:18:"Unique ID (OpenID)";s:11:"description";s:125:"the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:30:"civicrm_contact.user_unique_id";s:13:"headerPattern";s:29:"/^Open\s?ID|u(niq\w*)?\s?ID/i";s:11:"dataPattern";s:15:"/^[\w\/\:\.]+$/";s:6:"export";b:1;s:4:"rule";s:3:"url";s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:19:"current_employer_id";a:10:{s:4:"name";s:11:"employer_id";s:4:"type";i:1;s:5:"title";s:19:"Current Employer ID";s:11:"description";s:38:"OPTIONAL FK to civicrm_contact record.";s:6:"export";b:1;s:5:"where";s:27:"civicrm_contact.employer_id";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:11:"FKClassName";s:23:"CRM_Contact_DAO_Contact";s:4:"html";a:1:{s:4:"type";s:9:"EntityRef";}}s:18:"contact_is_deleted";a:9:{s:4:"name";s:10:"is_deleted";s:4:"type";i:16;s:5:"title";s:19:"Contact is in Trash";s:8:"required";b:1;s:6:"export";b:1;s:5:"where";s:26:"civicrm_contact.is_deleted";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}}s:12:"created_date";a:10:{s:4:"name";s:12:"created_date";s:4:"type";i:256;s:5:"title";s:12:"Created Date";s:11:"description";s:33:"When was the contact was created.";s:8:"required";b:0;s:6:"export";b:1;s:5:"where";s:28:"civicrm_contact.created_date";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:7:"default";s:4:"NULL";}s:13:"modified_date";a:10:{s:4:"name";s:13:"modified_date";s:4:"type";i:256;s:5:"title";s:13:"Modified Date";s:11:"description";s:84:"When was the contact (or closely related entity) was created or modified or deleted.";s:8:"required";b:0;s:6:"export";b:1;s:5:"where";s:29:"civicrm_contact.modified_date";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:7:"default";s:45:"CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP";}s:9:"addressee";a:11:{s:4:"name";s:9:"addressee";s:4:"type";i:2;s:5:"title";s:9:"Addressee";s:11:"description";s:133:"Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:15:"addressee.label";s:13:"headerPattern";s:14:"/^addressee$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;}s:14:"email_greeting";a:11:{s:4:"name";s:14:"email_greeting";s:4:"type";i:2;s:5:"title";s:14:"Email Greeting";s:11:"description";s:133:"Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:20:"email_greeting.label";s:13:"headerPattern";s:19:"/^email_greeting$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;}s:15:"postal_greeting";a:11:{s:4:"name";s:15:"postal_greeting";s:4:"type";i:2;s:5:"title";s:15:"Postal Greeting";s:11:"description";s:133:"Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:21:"postal_greeting.label";s:13:"headerPattern";s:20:"/^postal_greeting$/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;}s:16:"current_employer";a:2:{s:4:"name";s:17:"organization_name";s:5:"title";s:16:"Current Employer";}s:13:"location_type";a:4:{s:4:"name";s:13:"location_type";s:5:"where";s:26:"civicrm_location_type.name";s:5:"title";s:13:"Location Type";s:15:"hasLocationType";b:1;}s:14:"street_address";a:13:{s:4:"name";s:14:"street_address";s:4:"type";i:2;s:5:"title";s:14:"Street Address";s:11:"description";s:245:"Concatenation of all routable street address components (prefix, street number, street name, suffix, unit
      number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail
      delivery, etc.).
    ";s:9:"maxlength";i:96;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:30:"civicrm_address.street_address";s:13:"headerPattern";s:19:"/(street|address)/i";s:11:"dataPattern";s:56:"/^(\d{1,5}( [0-9A-Za-z]+)+)$|^(P\.?O\.\? Box \d{1,5})$/i";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:13:"street_number";a:10:{s:4:"name";s:13:"street_number";s:4:"type";i:1;s:5:"title";s:13:"Street Number";s:11:"description";s:96:"Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112.";s:6:"export";b:1;s:5:"where";s:29:"civicrm_address.street_number";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:20:"street_number_suffix";a:12:{s:4:"name";s:20:"street_number_suffix";s:4:"type";i:2;s:5:"title";s:20:"Street Number Suffix";s:11:"description";s:109:"Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A
    ";s:9:"maxlength";i:8;s:4:"size";i:8;s:6:"export";b:1;s:5:"where";s:36:"civicrm_address.street_number_suffix";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:11:"street_name";a:12:{s:4:"name";s:11:"street_name";s:4:"type";i:2;s:5:"title";s:11:"Street Name";s:11:"description";s:92:"Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main.";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"export";b:1;s:5:"where";s:27:"civicrm_address.street_name";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:11:"street_unit";a:12:{s:4:"name";s:11:"street_unit";s:4:"type";i:2;s:5:"title";s:11:"Street Unit";s:11:"description";s:64:"Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200";s:9:"maxlength";i:16;s:4:"size";i:12;s:6:"export";b:1;s:5:"where";s:27:"civicrm_address.street_unit";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:22:"supplemental_address_1";a:13:{s:4:"name";s:22:"supplemental_address_1";s:4:"type";i:2;s:5:"title";s:22:"Supplemental Address 1";s:11:"description";s:40:"Supplemental Address Information, Line 1";s:9:"maxlength";i:96;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:38:"civicrm_address.supplemental_address_1";s:13:"headerPattern";s:38:"/(supplemental(\s)?)?address(\s\d+)?/i";s:11:"dataPattern";s:33:"/unit|ap(ar)?t(ment)?\s(\d|\w)+/i";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:22:"supplemental_address_2";a:13:{s:4:"name";s:22:"supplemental_address_2";s:4:"type";i:2;s:5:"title";s:22:"Supplemental Address 2";s:11:"description";s:40:"Supplemental Address Information, Line 2";s:9:"maxlength";i:96;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:38:"civicrm_address.supplemental_address_2";s:13:"headerPattern";s:38:"/(supplemental(\s)?)?address(\s\d+)?/i";s:11:"dataPattern";s:33:"/unit|ap(ar)?t(ment)?\s(\d|\w)+/i";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:4:"city";a:13:{s:4:"name";s:4:"city";s:4:"type";i:2;s:5:"title";s:4:"City";s:11:"description";s:27:"City, Town or Village Name.";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:20:"civicrm_address.city";s:13:"headerPattern";s:7:"/city/i";s:11:"dataPattern";s:37:"/^[A-Za-z]+(\.?)(\s?[A-Za-z]+){0,2}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:18:"postal_code_suffix";a:13:{s:4:"name";s:18:"postal_code_suffix";s:4:"type";i:2;s:5:"title";s:16:"Post Code Suffix";s:11:"description";s:54:"Store the suffix, like the +4 part in the USPS system.";s:9:"maxlength";i:12;s:4:"size";i:3;s:6:"import";b:1;s:5:"where";s:34:"civicrm_address.postal_code_suffix";s:13:"headerPattern";s:29:"/p(ostal)\sc(ode)\ss(uffix)/i";s:11:"dataPattern";s:19:"/\d?\d{4}(-\d{4})?/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:11:"postal_code";a:13:{s:4:"name";s:11:"postal_code";s:4:"type";i:2;s:5:"title";s:11:"Postal Code";s:11:"description";s:114:"Store both US (zip5) AND international postal codes. App is responsible for country/region appropriate validation.";s:9:"maxlength";i:64;s:4:"size";i:6;s:6:"import";b:1;s:5:"where";s:27:"civicrm_address.postal_code";s:13:"headerPattern";s:13:"/postal|zip/i";s:11:"dataPattern";s:19:"/\d?\d{4}(-\d{4})?/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:10:"geo_code_1";a:11:{s:4:"name";s:10:"geo_code_1";s:4:"type";i:512;s:5:"title";s:8:"Latitude";s:11:"description";s:8:"Latitude";s:6:"import";b:1;s:5:"where";s:26:"civicrm_address.geo_code_1";s:13:"headerPattern";s:6:"/geo/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:10:"geo_code_2";a:11:{s:4:"name";s:10:"geo_code_2";s:4:"type";i:512;s:5:"title";s:9:"Longitude";s:11:"description";s:9:"Longitude";s:6:"import";b:1;s:5:"where";s:26:"civicrm_address.geo_code_2";s:13:"headerPattern";s:6:"/geo/i";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:12:"address_name";a:12:{s:4:"name";s:4:"name";s:4:"type";i:2;s:5:"title";s:12:"Address Name";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:20:"civicrm_address.name";s:13:"headerPattern";s:33:"/^location|(l(ocation\s)?name)$/i";s:11:"dataPattern";s:7:"/^\w+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:9:"master_id";a:11:{s:4:"name";s:9:"master_id";s:4:"type";i:1;s:5:"title";s:25:"Master Address Belongs To";s:11:"description";s:16:"FK to Address ID";s:6:"import";b:1;s:5:"where";s:25:"civicrm_address.master_id";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:11:"FKClassName";s:20:"CRM_Core_DAO_Address";s:15:"hasLocationType";b:1;}s:6:"county";a:12:{s:4:"name";s:4:"name";s:4:"type";i:2;s:5:"title";s:6:"County";s:11:"description";s:14:"Name of County";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:19:"civicrm_county.name";s:13:"headerPattern";s:9:"/county/i";s:11:"dataPattern";s:10:"/[A-Z]{2}/";s:6:"export";b:1;s:15:"hasLocationType";b:1;}s:14:"state_province";a:12:{s:4:"name";s:4:"name";s:4:"type";i:2;s:5:"title";s:8:"Province";s:11:"description";s:22:"Name of State/Province";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:27:"civicrm_state_province.name";s:13:"headerPattern";s:20:"/state|prov(ince)?/i";s:11:"dataPattern";s:10:"/[A-Z]{2}/";s:6:"export";b:1;s:15:"hasLocationType";b:1;}s:7:"country";a:12:{s:4:"name";s:4:"name";s:4:"type";i:2;s:5:"title";s:7:"Country";s:11:"description";s:12:"Country Name";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:20:"civicrm_country.name";s:13:"headerPattern";s:10:"/country/i";s:11:"dataPattern";s:39:"/^[A-Z][a-z]+\.?(\s+[A-Z][a-z]+){0,3}$/";s:6:"export";b:1;s:15:"hasLocationType";b:1;}s:5:"phone";a:13:{s:4:"name";s:5:"phone";s:4:"type";i:2;s:5:"title";s:5:"Phone";s:11:"description";s:22:"Complete phone number.";s:9:"maxlength";i:32;s:4:"size";i:20;s:6:"import";b:1;s:5:"where";s:19:"civicrm_phone.phone";s:13:"headerPattern";s:8:"/phone/i";s:11:"dataPattern";s:19:"/^[\d\(\)\-\.\s]+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:9:"phone_ext";a:13:{s:4:"name";s:9:"phone_ext";s:4:"type";i:2;s:5:"title";s:15:"Phone Extension";s:11:"description";s:38:"Optional extension for a phone number.";s:9:"maxlength";i:16;s:4:"size";i:4;s:6:"import";b:1;s:5:"where";s:23:"civicrm_phone.phone_ext";s:13:"headerPattern";s:12:"/extension/i";s:11:"dataPattern";s:7:"/^\d+$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:5:"email";a:14:{s:4:"name";s:5:"email";s:4:"type";i:2;s:5:"title";s:5:"Email";s:11:"description";s:13:"Email address";s:9:"maxlength";i:254;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:19:"civicrm_email.email";s:13:"headerPattern";s:10:"/e.?mail/i";s:11:"dataPattern";s:91:"/^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$/";s:6:"export";b:1;s:4:"rule";s:5:"email";s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:7:"on_hold";a:11:{s:4:"name";s:7:"on_hold";s:4:"type";i:16;s:5:"title";s:7:"On Hold";s:11:"description";s:31:"Is this address on bounce hold?";s:8:"required";b:1;s:6:"export";b:1;s:5:"where";s:21:"civicrm_email.on_hold";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:4:"html";a:1:{s:4:"type";s:8:"CheckBox";}s:15:"hasLocationType";b:1;}s:11:"is_bulkmail";a:10:{s:4:"name";s:11:"is_bulkmail";s:4:"type";i:16;s:5:"title";s:17:"Use for Bulk Mail";s:11:"description";s:31:"Is this address for bulk mail ?";s:8:"required";b:1;s:6:"export";b:1;s:5:"where";s:25:"civicrm_email.is_bulkmail";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:15:"hasLocationType";b:1;}s:14:"signature_text";a:11:{s:4:"name";s:14:"signature_text";s:4:"type";i:32;s:5:"title";s:14:"Signature Text";s:11:"description";s:39:"Text formatted signature for the email.";s:6:"import";b:1;s:5:"where";s:28:"civicrm_email.signature_text";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:7:"default";s:4:"NULL";s:15:"hasLocationType";b:1;}s:14:"signature_html";a:11:{s:4:"name";s:14:"signature_html";s:4:"type";i:32;s:5:"title";s:14:"Signature Html";s:11:"description";s:39:"HTML formatted signature for the email.";s:6:"import";b:1;s:5:"where";s:28:"civicrm_email.signature_html";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";s:6:"export";b:1;s:7:"default";s:4:"NULL";s:15:"hasLocationType";b:1;}s:11:"im_provider";a:4:{s:4:"name";s:11:"im_provider";s:5:"where";s:22:"civicrm_im.provider_id";s:5:"title";s:11:"IM Provider";s:15:"hasLocationType";b:1;}s:2:"im";a:13:{s:4:"name";s:4:"name";s:4:"type";i:2;s:5:"title";s:14:"IM Screen Name";s:11:"description";s:14:"IM screen name";s:9:"maxlength";i:64;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:15:"civicrm_im.name";s:13:"headerPattern";s:40:"/I(nstant )?M(ess.*)?|screen(\s+)?name/i";s:11:"dataPattern";s:28:"/^[A-Za-z][0-9A-Za-z]{20,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}s:15:"hasLocationType";b:1;}s:6:"openid";a:13:{s:4:"name";s:6:"openid";s:4:"type";i:2;s:5:"title";s:6:"OpenID";s:11:"description";s:125:"the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM";s:9:"maxlength";i:255;s:4:"size";i:45;s:6:"import";b:1;s:5:"where";s:21:"civicrm_openid.openid";s:13:"headerPattern";s:27:"/^Open.?ID|u(niq\w*)?.?ID/i";s:11:"dataPattern";s:15:"/^[\w\/\:\.]+$/";s:6:"export";b:1;s:4:"rule";s:3:"url";s:15:"hasLocationType";b:1;}s:12:"world_region";a:10:{s:4:"name";s:4:"name";s:4:"type";i:2;s:5:"title";s:12:"World Region";s:11:"description";s:43:"Region name to be associated with countries";s:9:"maxlength";i:128;s:4:"size";i:45;s:6:"export";b:1;s:5:"where";s:24:"civicrm_worldregion.name";s:13:"headerPattern";s:0:"";s:11:"dataPattern";s:0:"";}s:3:"url";a:12:{s:4:"name";s:3:"url";s:4:"type";i:2;s:5:"title";s:7:"Website";s:11:"description";s:7:"Website";s:9:"maxlength";i:128;s:4:"size";i:30;s:6:"import";b:1;s:5:"where";s:19:"civicrm_website.url";s:13:"headerPattern";s:10:"/Website/i";s:11:"dataPattern";s:28:"/^[A-Za-z][0-9A-Za-z]{20,}$/";s:6:"export";b:1;s:4:"html";a:1:{s:4:"type";s:4:"Text";}}s:8:"custom_3";a:10:{s:4:"name";s:8:"custom_3";s:5:"title";s:11:"Institution";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:3;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:8:"custom_4";a:12:{s:4:"name";s:8:"custom_4";s:5:"title";s:4:"From";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:4;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:4:"Date";s:9:"html_type";s:11:"Select Date";s:15:"is_search_range";s:1:"0";s:11:"date_format";s:4:"M yy";s:11:"time_format";N;}s:8:"custom_5";a:12:{s:4:"name";s:8:"custom_5";s:5:"title";s:2:"To";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:5;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:4:"Date";s:9:"html_type";s:11:"Select Date";s:15:"is_search_range";s:1:"0";s:11:"date_format";s:4:"M yy";s:11:"time_format";N;}s:8:"custom_6";a:10:{s:4:"name";s:8:"custom_6";s:5:"title";s:22:"Area of Specialization";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:6;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:8:"custom_7";a:10:{s:4:"name";s:8:"custom_7";s:5:"title";s:19:"Diplomas or Degrees";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:7;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:8:"custom_8";a:10:{s:4:"name";s:8:"custom_8";s:5:"title";s:8:"Employer";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:8;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:8:"custom_9";a:10:{s:4:"name";s:8:"custom_9";s:5:"title";s:14:"Position/Title";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:9;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:9:"custom_10";a:12:{s:4:"name";s:9:"custom_10";s:5:"title";s:4:"From";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:10;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:4:"Date";s:9:"html_type";s:11:"Select Date";s:15:"is_search_range";s:1:"0";s:11:"date_format";s:4:"M yy";s:11:"time_format";N;}s:9:"custom_11";a:12:{s:4:"name";s:9:"custom_11";s:5:"title";s:2:"To";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:11;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:4:"Date";s:9:"html_type";s:11:"Select Date";s:15:"is_search_range";s:1:"0";s:11:"date_format";s:4:"M yy";s:11:"time_format";N;}s:9:"custom_12";a:10:{s:4:"name";s:9:"custom_12";s:5:"title";s:13:"Employer Type";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:12;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:6:"Select";s:15:"is_search_range";s:1:"0";}s:9:"custom_13";a:10:{s:4:"name";s:9:"custom_13";s:5:"title";s:40:"Area of Expertise (maximum 60 chracters)";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:13;s:16:"options_per_line";N;s:11:"text_length";s:2:"60";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:9:"custom_14";a:10:{s:4:"name";s:9:"custom_14";s:5:"title";s:18:"Other Affiliations";s:13:"headerPattern";s:2:"//";s:6:"import";i:1;s:15:"custom_field_id";i:14;s:16:"options_per_line";N;s:11:"text_length";s:3:"255";s:9:"data_type";s:6:"String";s:9:"html_type";s:4:"Text";s:15:"is_search_range";s:1:"0";}s:6:"groups";a:2:{s:5:"title";s:8:"Group(s)";s:4:"name";s:6:"groups";}s:4:"tags";a:2:{s:5:"title";s:6:"Tag(s)";s:4:"name";s:4:"tags";}s:5:"notes";a:2:{s:5:"title";s:7:"Note(s)";s:4:"name";s:5:"notes";}}