DELETE FROM wp_wic_data_dictionary WHERE  left( field_slug, 13 ) != 'custom_field_';
TRUNCATE TABLE wp_wic_form_field_groups;
INSERT INTO wp_wic_data_dictionary (entity_slug, group_slug, field_slug, field_type, field_label, field_order, listing_order, sort_clause_order, required, dedup, readonly, hidden, field_default, transient, wp_query_parameter, placeholder, option_group, list_formatter, reverse_sort, customizable, enabled, uploadable, upload_dedup, last_updated_time) VALUES
('activity', 'activity', 'last_updated_by', 'selectmenu', 'By', 440, 0, 0, '', 0, 1, 0, '', 0, '', '', 'constituent_last_updated_by', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'last_updated_time', 'date', 'Updated', 430, 0, 0, '', 0, 1, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('activity', '', 'upload_id', 'selectmenu', 'Upload File', 450, 0, 0, '', 0, 0, 0, '', 0, '', '', 'upload_id', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'activity_amount', 'text', 'Amount', 35, 30, 0, '', 0, 0, 0, '', 0, '', 'Amount', '', '', 0, 0, 1, 1002, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'activity_date', 'date', 'Date', 30, 10, 10, '', 0, 0, 0, '', 0, '', 'Date', '', '', 1, 0, 1, 1005, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'activity_note', 'activity_note', 'Note', 60, 0, 0, '', 0, 0, 0, '', 0, '', ' . . . notes . . .', '', '', 0, 0, 1, 1010, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'activity_type', 'selectmenu', 'Type', 20, 20, 0, '', 0, 0, 0, '', 0, '', 'Type', 'activity_type_options', 'activity_type_options', 0, 0, 1, 1000, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'constituent_id', 'selectmenu_constituent', 'Constituent', 10, 40, 0, 'individual', 0, 0, 1, '', 0, '', 'Search . . .', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'ID', 'text', 'Internal ID for Activity', 400, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'issue', 'selectmenu_issue', 'Issue', 40, 50, 0, 'individual', 0, 0, 0, '', 0, '', 'Issue', 'get_issue_options', '', 0, 0, 1, 1020, 0, '2000-01-01 01:01:01'),
('activity', 'activity', 'pro_con', 'selectmenu', 'Pro or Con', 50, 60, 0, '', 0, 0, 0, '', 0, '', 'Pro/Con', 'pro_con_options', 'pro_con_options', 0, 0, 1, 1070, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_1', 'text', 'Part 1 (no space to part 2)', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 44, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_2', 'text', 'Part 2', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 45, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_3', 'text', 'Part 3', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 46, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_4', 'text', 'Part 4', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 47, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_5', 'text', 'Part 5', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 48, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_6', 'text', 'Part 6', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 49, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_7', 'text', 'Part 7,  Apt. word ( e.g., "Apt" )', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 50, 0, '2000-01-01 01:01:01'),
('address', '', 'address_line_part_8', 'text', 'Part 8, Apartment #', 0, 0, 0, '', 0, 0, 1, '', 0, '', '1A', '', '', 0, 0, 1, 51, 0, '2000-01-01 01:01:01'),
('address', '', 'last_updated_by', 'selectmenu', 'Address Updated By', 440, 0, 0, '', 0, 1, 0, '', 0, '', '', 'constituent_last_updated_by', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('address', '', 'last_updated_time', 'date', 'Address Updated Time', 430, 0, 0, '', 0, 1, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('address', 'address_line_1', 'address_line', 'autocomplete', 'Street Address', 40, 90, 0, 'group', 1, 0, 0, '', 0, '', '123R Main St Apt 1', '', '', 0, 0, 1, 52, 0, '2000-01-01 01:01:01'),
('address', 'address_line_1', 'address_type', 'selectmenu', 'Address Type', 30, 0, 0, '', 0, 0, 0, '', 0, '', 'Type', 'address_type_options', '', 0, 0, 1, 140, 1, '2000-01-01 01:01:01'),
('address', 'address_line_1', 'constituent_id', 'text', 'Constituent ID for Address', 20, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 1, '2000-01-01 01:01:01'),
('address', 'address_line_1', 'ID', 'text', 'Internal ID for Address', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('address', 'address_line_1', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('address', 'address_line_1', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('address', 'address_line_2', 'city', 'autocomplete', 'City', 80, 100, 0, 'group', 1, 0, 0, '', 0, '', 'City', '', '', 0, 0, 1, 60, 0, '2000-01-01 01:01:01'),
('address', 'address_line_2', 'state', 'selectmenu', 'State', 90, 0, 0, 'group', 1, 0, 0, '', 0, '', 'State', 'state_options', '', 0, 0, 1, 70, 0, '2000-01-01 01:01:01'),
('address', 'address_line_2', 'zip', 'autocomplete', 'Postal Code', 100, 0, 0, 'group', 1, 0, 0, '', 0, '', 'Postal Code', '', '', 0, 0, 1, 80, 0, '2000-01-01 01:01:01'),
('address', 'address_line_2', 'lat', 'text', 'Lat', 120, 0, 0, '', 0, 0, 1, '0', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('address', 'address_line_2', 'lon', 'text', 'Lon', 130, 0, 0, '', 0, 0, 1, '0', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_activity', 'activity_row', 'activity_comparison', 'selectmenu', '', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', 'advanced_search_general_comparisons', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_activity', 'activity_row', 'activity_field', 'selectmenu', '', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', 'activity_fields', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_activity', 'activity_row', 'activity_type', 'selectmenu', '', 20, 0, 0, '', 0, 0, 0, '', 0, '', '', 'activity_type_options_all', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_activity', 'activity_row', 'activity_value', 'text', '', 40, 0, 0, '', 0, 0, 0, '', 0, '', 'Enter value', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_activity', 'activity_row', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', '', 'having_count', 'text', '', 0, 0, 0, '', 0, 0, 0, '', 0, '', 'Count', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'constituent_having_aggregator', 'selectmenu', '', 5, 0, 0, '', 0, 0, 0, '', 0, '', '', 'advanced_search_having_aggregators', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'constituent_having_comparison', 'selectmenu', '', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', 'advanced_search_quantitative_comparisons', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'constituent_having_field', 'selectmenu', '', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', 'constituent_having_fields', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'constituent_having_issue_cat', 'multiselect', '', 25, 0, 0, '', 0, 0, 0, '', 0, '', '', 'advanced_search_issue_cats', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'constituent_having_type', 'selectmenu', '', 20, 0, 0, '', 0, 0, 0, '', 0, '', '', 'activity_type_options_all', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'constituent_having_value', 'text', '', 40, 0, 0, '', 0, 0, 0, '', 0, '', 'Enter value', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent_having', 'constituent_having_row', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent', 'constituent_row', 'constituent_comparison', 'selectmenu', '', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', 'advanced_search_general_comparisons', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent', 'constituent_row', 'constituent_entity_type', 'selectmenu', '', 20, 0, 0, '', 0, 0, 0, '', 0, '', '', 'constituent_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent', 'constituent_row', 'constituent_field', 'selectmenu', '', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', 'constituent_fields', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent', 'constituent_row', 'constituent_value', 'text', '', 40, 0, 0, '', 0, 0, 0, '', 0, '', 'Enter value', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search_constituent', 'constituent_row', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'advanced_search_checked_substitute', 'advanced_search_checked_substitute', 'selectmenu', 'Checked Substitute', 999, 0, 0, '', 0, 0, 1, '1', 0, '', '', 'advanced_search_checked_substitute', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_activity', 'activity_and_or', 'selectmenu', '', 60, 0, 0, '', 0, 0, 1, 'and', 0, '', '', 'activity_and_or', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_activity', 'advanced_search_activity', 'multivalue', 'Select', 50, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_constituent_having', 'advanced_search_constituent_having', 'multivalue', 'Select', 70, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_constituent_having', 'constituent_having_and_or', 'selectmenu', '', 80, 0, 0, '', 0, 0, 1, 'and', 0, '', '', 'constituent_having_and_or', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_constituent', 'advanced_search_constituent', 'multivalue', 'Select', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_constituent', 'constituent_and_or', 'selectmenu', '', 40, 0, 0, '', 0, 0, 1, 'and', 0, '', '', 'constituent_and_or', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_definition', 'activity_and_or_constituent', 'selectmenu', '', 20, 0, 0, '', 0, 0, 1, 'and', 0, '', '', 'activity_and_or_constituent', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('advanced_search', 'search_definition', 'activity_or_constituent', 'selectmenu', 'Rows', 10, 0, 0, '', 0, 0, 0, 'constituent', 0, '', '', 'activity_or_constituent', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'case', 'case_assigned', 'selectmenu', 'Staff', 110, -3, 0, '', 0, 0, 0, '', 0, '', '', 'get_administrator_array', '', 0, 0, 1, 180, 0, '2000-01-01 01:01:01'),
('constituent', 'case', 'case_review_date', 'date', 'Review Date', 130, -1, 0, '', 0, 0, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 170, 0, '2000-01-01 01:01:01'),
('constituent', 'case', 'case_status', 'selectmenu', 'Status', 120, -2, 0, '', 0, 0, 0, '', 0, '', '', 'case_status_options', '', 0, 0, 1, 160, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'address', 'multivalue', 'Address', 60, 60, 0, 'group', 1, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'email', 'multivalue', 'Email', 50, 50, 0, 'group', 1, 0, 0, '', 0, '', '', '', 'email_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'first_name', 'autocomplete', 'First Name', 10, 10, 30, 'group', 1, 0, 0, '', 0, '', 'First Name', '', '', 0, 0, 1, 20, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'last_name', 'autocomplete', 'Last Name', 30, 30, 20, 'group', 1, 0, 0, '', 0, '', 'Last Name', '', '', 0, 0, 1, 40, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'salutation', 'text', 'Salutation', 35, 0, 0, '', 0, 0, 0, '', 0, '', 'Betsy or Dr. Smith -- for email merge', '', '', 0, 0, 1, 107, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'middle_name', 'autocomplete', 'Middle Name', 20, 20, 40, '', 1, 0, 0, '', 0, '', 'Middle Name', '', '', 0, 0, 1, 30, 0, '2000-01-01 01:01:01'),
('constituent', 'contact', 'phone', 'multivalue', 'Phone', 40, 40, 0, '', 0, 0, 0, '', 0, '', '', '', 'phone_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'delete', 'mark_deleted', 'text', 'Mark Deleted', 999, 0, 0, '', 0, 0, 0, 'DELETED', 0, '', 'DELETED', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'date_of_birth', 'date', 'Date of Birth', 85, 0, 0, '', 0, 0, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 110, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'year_of_birth', 'birth_year', 'Year of Birth', 86, 0, 0, '', 0, 0, 0, '', 0, '', 'YYYY', '', '', 0, 0, 1, 111, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'gender', 'selectmenu', 'Gender', 90, 0, 0, '', 0, 0, 0, '', 0, '', '', 'gender_options', '', 0, 0, 1, 120, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'occupation', 'text', 'Occupation', 91, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 121, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'employer', 'text', 'Employer', 92, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 122, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'is_deceased', 'checked', 'Deceased?', 95, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 130, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'is_my_constituent', 'selectmenu', 'Mine?', 105, 0, 0, '', 0, 0, 0, ' ', 0, '', '', 'is_my_constituent_options', '', 0, 0, 1, 131, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'ID', 'text', 'Internal Id', 110, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 10, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'last_updated_time', 'date', 'Updated', 120, 0, 0, '', 0, 1, 0, '', 0, '', 'Not yet saved', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'last_updated_by', 'selectmenu', 'By', 130, 0, 0, '', 0, 1, 0, '', 0, '', '', 'constituent_last_updated_by', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'personal', 'no_dupcheck', 'checked', '', 0, 0, 0, '', 0, 0, 1, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'registration_id', 'text', 'Reg. ID', 430, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 220, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'registration_synch_status', 'text', 'Synch Status', 440, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'registration_date', 'date', 'Reg. Date', 450, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 240, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'registration_status', 'text', 'Reg. Status', 460, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 250, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'party', 'text', 'Reg. Party', 470, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 260, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'ward', 'text', 'Ward', 480, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 270, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'precinct', 'text', 'Precinct', 490, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 280, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'council_district', 'text', 'Council', 500, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 290, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'state_rep_district', 'text', 'Rep', 510, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 300, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'state_senate_district', 'text', 'Senate', 520, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 310, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'congressional_district', 'text', 'Congress', 530, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 320, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'county', 'text', 'County', 540, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 330, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'other_district_1', 'text', 'Other 1', 550, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 340, 0, '2000-01-01 01:01:01'),
('constituent', 'registration', 'other_district_2', 'text', 'Other 2', 560, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 350, 0, '2000-01-01 01:01:01'),
('constituent', 'dedup', 'duplicate_constituent', 'selectmenu_constituent', 'Constituent', 998, 0, 0, '', 0, 0, 1, '', 1, '', 'Search . . .', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('dashboard', 'dashboard', 'date_range', 'date', '', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('dashboard', 'dashboard', 'case_assigned', 'selectmenu', '', 20, 0, 0, '', 0, 0, 0, '', 0, '', '', 'get_administrator_array_plus', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('dashboard', 'dashboard', 'case_status', 'selectmenu', '', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', 'case_status_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('dashboard', 'dashboard', 'follow_up_status', 'selectmenu', '', 30, 30, 0, '', 0, 0, 0, '', 0, '', '', 'follow_up_status_options', 'follow_up_status_options', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('dashboard', 'dashboard', 'issue_staff', 'selectmenu', '', 10, 10, 0, '', 0, 0, 0, '', 0, '', '', 'get_administrator_array_plus', 'issue_staff_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'enabled', 'selectmenu', 'Enabled', 100, 80, 0, '', 0, 0, 0, '1', 0, '', '', 'enabled_disabled_array', 'enabled_disabled_array', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'entity_slug', 'text', 'entity_slug', 2, 0, 0, '', 0, 1, 1, 'constituent', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'field_default', 'text', 'Default', 50, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'field_label', 'text', 'Visible Name', 20, 30, 20, 'individual', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'field_order', 'text', 'Screen Order', 40, 0, 0, 'individual', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'field_slug', 'text', 'System Name', 10, 0, 0, '', 0, 1, 0, '', 0, '', 'System will define system name', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'field_type', 'selectmenu', 'Field Type', 60, 40, 0, 'individual', 0, 0, 0, '', 0, '', '', 'custom_field_types', 'custom_field_types', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'group_slug', 'selectmenu', 'Screen Group ', 30, 10, 10, 'individual', 0, 0, 0, '', 0, '', '', 'customizable_groups', 'customizable_groups', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'ID', 'text', 'Internal ID for Field', 3, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'is_changed', 'text', '', 1, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'list_formatter', 'text', 'List Formatter', 80, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'option_group', 'selectmenu', 'Option Group ', 70, 50, 0, '', 0, 0, 0, '', 0, '', '', 'list_option_groups', 'decode_option_groups', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('data_dictionary', 'data_dictionary', 'readonly', 'checked', 'Read Only', 90, 0, 0, '', 0, 0, 0, '0', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'account', 'read_account', 'selectmenu', 'Read Email From', 10, 0, 0, '', 0, 0, 0, 'exchange', 1, '', '', 'read_account_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'account', 'send_account', 'selectmenu', 'Send Email Via', 20, 0, 0, '', 0, 0, 0, 'exchange', 1, '', '', 'send_account_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'activesync', 'activesync_email_address', 'text', 'Email Address', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'activesync', 'activesync_sender_name', 'text', 'Sender Name', 20, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_subjects', 'forget_date_phrase', 'text', 'Date Phrase', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_message_grouping', 'mapped_threshold', 'text', 'Allow automated processing of messages with trained subject line ONLY if this % of sentences match the original message:', 10, 0, 0, '', 0, 0, 0, '85', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_message_grouping', 'word_minimum_threshold', 'text', 'Allow automated processing of messages with trained subject line ONLY if the incoming message has more words than:', 40, 0, 0, '', 0, 0, 0, '200', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_message_grouping', 'parse_strictness', 'selectmenu', 'Ungroup messages (force individual review) unless they meet at least this parse quality standard', 80, 0, 0, '', 0, 0, 0, '5', 1, '', '', 'email_parse_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'capitalization', 'selectmenu', 'Capitalization of city/state line', 30, 0, 0, '', 0, 0, 0, '1', 1, '', '', 'capitalization_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'city_word_count', 'selectmenu', 'Number of city words accepted', 40, 0, 0, '', 0, 0, 0, '3', 1, '', '', 'city_word_count_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'email_source', 'selectmenu', 'Email Source', 15, 0, 0, '', 0, 0, 0, '1', 1, '', '', 'email_source_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'maximum_name_length', 'selectmenu', 'Maximum number of words in name', 60, 0, 0, '', 0, 0, 0, '4', 1, '', '', 'maximum_name_length_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'minimum_name_length', 'selectmenu', 'Minimum number of words in name', 70, 0, 0, '', 0, 0, 0, '2', 1, '', '', 'minimum_name_length_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'street_word_count', 'selectmenu', 'Number of street words accepted', 50, 0, 0, '', 0, 0, 0, '3', 1, '', '', 'street_word_count_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_address_parse_options', 'zip_required', 'selectmenu', 'Zip Code Strictness', 20, 0, 0, '', 0, 0, 0, '1', 1, '', '', 'zip_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_disqualifiers', 'disqualifiers', 'textarea', 'Discard text blocks containing these phrases.', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_terms', 'apartments', 'textarea', 'Apartments -- a line beginning with one of these will be classified as an apartment line', 30, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_terms', 'special_streets', 'textarea', 'One Word Streets -- parser will let these through without a street suffix', 25, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_terms', 'states', 'textarea', 'States and State Abbreviations -- parser requires these in a city-state-zip line ', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_terms', 'streets', 'textarea', 'Streets Suffixes -- parser requires these in a street address line ', 20, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_titles', 'post_titles', 'textarea', 'Recognize and discard these if at end of name', 50, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_titles', 'pre_titles', 'textarea', 'Recognize and discard these if ahead of name', 70, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_titles', 'closings', 'textarea', 'Recognize these as closing lines, not names', 80, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'imap_to_wic_parse_titles', 'non_names', 'textarea', 'Recognize that lines containing these words are not name lines', 90, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'is_my_constituent_rules', 'use_is_my_constituent_rules', 'selectmenu', 'Use Geographic Rules?', 10, 0, 0, '', 0, 0, 0, 'N', 1, '', '', 'use_is_my_constituent_rule_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'is_my_constituent_rules', 'imc_qualifiers', 'textarea', 'States, cities and/or zips that indicate constituency (string separated by "|" character)', 20, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'non_constituent_responder', 'use_non_constituent_responder', 'selectmenu', 'Use Non-constituent Responder?', 10, 0, 0, '', 0, 0, 0, '1', 1, '', '', 'use_non_constituent_responder_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'non_constituent_responder', 'non_constituent_response_subject_line', 'text', 'Non Constituent Response Subject Line', 20, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'non_constituent_responder', 'non_constituent_response_message', 'textarea', 'Non Constituent Response Text (should include signature -- no signature will be added)', 30, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_settings', 'team_definition', 'team_list', 'textarea', 'Put these emails in the Team Tab.', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_compose', 'compose_options', 'compose_to', 'multi_email', '', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_compose', 'compose_options', 'compose_cc', 'multi_email', '', 20, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_compose', 'compose_options', 'compose_bcc', 'multi_email', '', 30, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_compose', 'compose_options', 'compose_subject', 'text', '', 40, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_compose', 'compose_options', 'compose_issue', 'selectmenu_issue', '', 50, 0, 0, '', 0, 0, 1, '', 1, '', 'Issue', 'get_issue_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_compose', 'compose_options', 'compose_content', 'textarea', '', 60, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'search_subjects_phrase', 'text', '', 5, 0, 0, '', 0, 0, 0, '', 1, '', 'Search subject lines and mapped issues.', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'constituent_id', 'selectmenu_constituent', 'Constituent', 10, 40, 0, 'individual', 0, 0, 1, '', 0, '', 'Search . . .', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'case_assigned', 'selectmenu', 'Assigned Staff:', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', 'get_administrator_array', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'issue', 'selectmenu_issue', '', 40, 0, 0, '', 0, 0, 1, '', 1, '', 'Issue', 'get_issue_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'pro_con', 'selectmenu', 'Pro/Con value to be recorded for incoming emails (optional):', 50, 0, 0, '', 0, 0, 0, '', 1, '', 'Pro/Con?', 'pro_con_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'subject', 'text', '', 60, 0, 0, '', 0, 0, 0, '', 1, '', ' Filter email subjects', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'message_subject', 'text', '', 62, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'message_to', 'multi_email', '', 64, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'message_cc', 'multi_email', '', 66, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'message_bcc', 'multi_email', '', 68, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'include_attachments', 'checked', '', 70, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'add_cc', 'checked', '', 73, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email_inbox', 'inbox_options', 'working_template', 'textarea', '', 74, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email', '', 'last_updated_by', 'selectmenu', 'Email Updated By', 440, 0, 0, '', 0, 1, 0, '', 0, '', '', 'constituent_last_updated_by', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email', '', 'last_updated_time', 'date', 'Email Updated Time', 430, 0, 0, '', 0, 1, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email', 'email_row', 'constituent_id', 'text', 'Constituent ID for Email', 10, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 1, '2000-01-01 01:01:01'),
('email', 'email_row', 'email_address', 'autocomplete', 'Email Address', 30, 100, 0, 'group', 1, 0, 0, '', 0, '', 'Email Address', '', '', 0, 0, 1, 90, 0, '2000-01-01 01:01:01'),
('email', 'email_row', 'email_type', 'selectmenu', 'Email Type', 20, 0, 0, '', 0, 0, 0, '', 0, '', 'Type', 'email_type_options', '', 0, 0, 1, 145, 1, '2000-01-01 01:01:01'),
('email', 'email_row', 'ID', 'text', 'Internal ID for Email', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email', 'email_row', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('email', 'email_row', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'external', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'external', 'ID', 'text', 'Internal ID for External', 10, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'external', 'external_type', 'selectmenu', 'Type', 20, 20, 10, 'individual', 1, 0, 0, '', 0, '', '', 'external_type_options', 'list_external_type', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'external', 'external_identifier', 'selectmenu', 'Identifier', 30, 30, 20, 'individual', 1, 0, 0, '', 0, '', '', '_identifier_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'external', 'external_name', 'text', 'Description', 40, 40, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'external', 'enabled', 'selectmenu', 'Enabled', 50, 50, 0, '', 1, 0, 0, '1', 0, '', '', 'enabled_disabled_array', 'enabled_disabled_array', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'defaults', 'issue', 'selectmenu_issue', 'Issue', 5, 0, 0, 'individual', 0, 0, 0, '', 0, '', 'Issue', 'get_issue_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'management', 'case_assigned', 'selectmenu', 'Staff', 8, 45, 0, '', 0, 0, 0, '', 0, '', '', 'get_administrator_array', 'issue_staff_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'management', 'case_status', 'selectmenu', 'Status', 9, 0, 0, '', 0, 0, 0, '', 0, '', '', 'case_status_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'defaults', 'activity_type', 'selectmenu', 'Type', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', 'activity_type_options', 'activity_type_options', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'types', 'address_type', 'selectmenu', 'Address Type', 20, 0, 0, '', 0, 0, 0, '', 0, '', '', 'address_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'types', 'email_type', 'selectmenu', 'Email Type', 30, 0, 0, '', 0, 0, 0, '', 0, '', '', 'email_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'types', 'phone_type', 'selectmenu', 'Phone Type', 40, 0, 0, '', 0, 0, 0, '', 0, '', '', 'phone_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'front_end_posts', 'front_end_posts', 'selectmenu', 'New Front End Post Creation', 50, 0, 0, '', 0, 0, 0, 'never', 0, '', '', 'front_end_post_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'front_end_posts', 'front_end_post_initial_status', 'selectmenu', 'Initial Status for New Posts', 60, 0, 0, '', 0, 0, 0, 'pending', 0, '', '', 'front_end_post_initial_status_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'update', 'policy_identity', 'selectmenu', 'Name/DOB', 10, 0, 0, '', 0, 0, 0, 'blank_existing', 0, '', '', 'constituent_interface_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'update', 'policy_custom_data', 'selectmenu', 'Custom Fields', 20, 0, 0, '', 0, 0, 0, 'non_blank_incoming', 0, '', '', 'constituent_interface_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'update', 'policy_address', 'selectmenu', 'Address', 30, 0, 0, '', 0, 0, 0, 'update_test_match', 0, '', '', 'multivalue_interface_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'update', 'policy_phone', 'selectmenu', 'Phone', 35, 0, 0, '', 0, 0, 0, 'update_test_match', 0, '', '', 'multivalue_interface_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('external', 'update', 'policy_email', 'selectmenu', 'Email', 40, 0, 0, '', 0, 0, 0, 'always', 0, '', '', 'multivalue_interface_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'activity_open', 'wic_live_issue', 'selectmenu', 'Rule', 20, 20, 0, '', 0, 0, 0, 'open', 0, '', '', 'wic_live_issue_options', 'wic_live_issue_options', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_classification', 'post_category', 'multiselect', 'Categories', 20, 50, 0, '', 0, 0, 0, '', 0, 'cat', '', 'get_post_category_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_classification', 'tags_input', 'text', 'Tags', 10, 0, 0, '', 0, 0, 0, '', 0, 'tag', 'Tag or comma separated tags', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_content', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_content', 'post_content', 'textarea', 'Text', 20, 0, 0, '', 0, 0, 0, '', 0, 'post_content', ' . . . issue content . . .', '', '', 0, 0, 1, 1040, 0, '2000-01-01 01:01:01'),
('issue', 'issue_content', 'post_title', 'text', 'Title', 10, 40, 0, 'individual', 0, 0, 0, '', 0, 'post_title', '', '', '', 0, 0, 1, 1030, 0, '2000-01-01 01:01:01'),
('issue', 'issue_creation', 'ID', 'text', 'Post ID', 40, 1, 0, '', 0, 1, 0, '', 0, 'p', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_creation', 'post_author', 'selectmenu', 'By', 10, 0, 0, '', 0, 1, 0, '', 0, 'author', 'Not yet created', 'get_post_author_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_creation', 'post_date', 'date', 'On', 20, 0, 10, '', 0, 1, 0, '', 0, 'date', 'Not yet created', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_creation', 'post_status', 'selectmenu', 'Visibility', 30, 60, 0, '', 0, 1, 0, '', 0, 'post_status', '', 'post_status_options', 'post_status_options', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_management', 'follow_up_status', 'selectmenu', 'Status', 30, 30, 0, '', 0, 0, 0, '', 0, '', '', 'follow_up_status_options', 'follow_up_status_options', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_management', 'issue_staff', 'selectmenu', 'Staff', 10, 10, 0, '', 0, 0, 0, '', 0, '', '', 'get_administrator_array', 'issue_staff_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('issue', 'issue_management', 'review_date', 'date', 'Review', 40, -1, 0, '', 0, 0, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', '', 'wic-export-parameters', 'text', '', 0, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'found_count', 'text', '', 0, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'list_page_offset', 'text', '', 0, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'retrieve_limit', 'text', '', 0, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'search_id', 'text', '', 0, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'share_name', 'text', '', 0, 0, 0, '', 0, 0, 0, '', 0, '', 'Enter a name to share this search  . . .', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'wic-main-search-box', 'autocomplete', '', 0, 0, 0, '', 0, 0, 0, '', 0, '', 'Quick search for constituents and issues', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('list', 'list', 'wic-post-export-button', 'select', 'Type', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', 'download_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'constituent', 'confirm', 'text', 'Type PURGE CONSTITUENT DATA in all caps to confirm constituent purge.', 70, 0, 0, '', 0, 0, 0, '', 1, '', 'enter exactly as shown', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'constituent', 'keep_activity', 'checked', 'Keep if activity', 30, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'constituent', 'keep_address', 'checked', 'Keep if physical address', 60, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'constituent', 'keep_all', 'checked', 'Keep all constituents', 65, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'constituent', 'keep_email', 'checked', 'Keep if email address', 40, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'constituent', 'keep_phone', 'checked', 'Keep if phone number', 50, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'search', 'keep_search', 'checked', 'Keep logs', 10, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('manage_storage', 'staging', 'keep_staging', 'checked', 'Keep temporary upload files', 20, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'enabled', 'select', 'Enabled', 30, 30, 0, '', 1, 0, 0, '1', 0, '', '', 'enabled_disabled_array', 'enabled_disabled_array', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'ID', 'text', 'Internal ID for OptionGroup', 5, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'last_updated_by', 'selectmenu', 'Last Updater', 60, 0, 0, '', 0, 1, 0, '', 0, '', '', 'constituent_last_updated_by', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'last_updated_time', 'text', 'Last Updated', 70, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'option_group_desc', 'text', 'Description', 20, 20, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'option_group_slug', 'text', 'Group Name', 10, 0, 10, 'individual', 1, 0, 0, '', 0, '', 'no_spaces_allowed', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_group', 'option_group', 'option_value', 'multivalue', 'Option Values', 40, 40, 0, '', 0, 0, 0, '', 0, '', '', '', 'option_label_list_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'enabled', 'select', 'Enabled', 50, 0, 0, '', 0, 0, 0, '1', 0, '', '', 'enabled_disabled_array', 'enabled_disabled_array', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'ID', 'text', 'Internal ID for Option Value', 400, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'option_group_id', 'text', 'Option Group ID', 10, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'option_label', 'text', 'Visible', 30, 10, 0, '', 0, 0, 0, '', 0, '', 'Visible in drop down.', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'option_value', 'text', 'Database', 20, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'parent_option_group_slug', 'text', 'Option Group Slug', 15, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('option_value', 'option_value', 'value_order', 'text', 'Order', 40, 0, 10, 'individual', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'blog', 'ID', 'text', 'Blog ID', 10, 10, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'blog', 'siteurl', 'text', 'Site URL', 20, 20, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'blog', 'blogname', 'text', 'Blog Name', 30, 30, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'blog', 'blogdescription', 'text', 'Blog Description', 40, 0, 0, '', 0, 1, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'owner', 'wic_owner_name', 'text', 'Owner Name', 50, 50, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'owner', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'owner', 'wic_owner_type', 'selectmenu', 'Owner Type', 55, 55, 0, '', 0, 0, 0, '', 0, '', '', 'valid_owner_types', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('owner', 'owner', 'wic_owner_id', 'text', 'Owner ID', 60, 60, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('phone', '', 'last_updated_by', 'selectmenu', 'Phone Updated By', 440, 0, 0, '', 0, 1, 0, '', 0, '', '', 'constituent_last_updated_by', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('phone', '', 'last_updated_time', 'date', 'Phone Updated Time', 430, 0, 0, '', 0, 1, 0, '', 0, '', 'Date', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'constituent_id', 'text', 'Constituent ID for Phone', 10, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 1, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'extension', 'text', 'Phone Extension', 40, 0, 0, 'group', 0, 0, 0, '', 0, '', 'Ext.', '', '', 0, 0, 1, 105, 0, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'ID', 'text', 'Internal ID for Phone', 0, 0, 0, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'is_changed', 'text', '', 2, 0, 0, '', 0, 0, 1, '0', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'phone_number', 'text', 'Phone Number', 30, 100, 0, 'group', 0, 0, 0, '', 0, '', 'Number', '', 'phone_number_formatter', 0, 0, 1, 100, 0, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'phone_type', 'selectmenu', 'Phone Type', 20, 0, 0, '', 0, 0, 0, '', 0, '', 'Type', 'phone_type_options', '', 0, 0, 1, 150, 1, '2000-01-01 01:01:01'),
('phone', 'phone_row', 'screen_deleted', 'deleted', 'x', 1, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'download_time', 'text', 'Last Download', 50, 50, 0, '', 0, 0, 0, '', 0, '', '', '', 'download_time_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'entity', 'text', 'Entity', 30, 30, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'favorite', 'text', 'Favorite', 18, 10, 10, '', 0, 0, 0, '', 0, '', '', '', 'favorite_formatter', 1, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'ID', 'text', 'ID', 10, -1, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'is_named', 'text', '', 24, 24, 5, '', 0, 0, 0, '', 0, '', '', '', '', 1, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'result_count', 'text', 'Count', 110, 45, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'search_time', 'text', 'Search Time', 20, 20, 20, '', 0, 0, 0, '', 0, '', '', '', 'time_formatter', 1, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'serialized_search_array', 'text', 'Search Details', 40, 40, 0, '', 0, 0, 0, '', 0, '', '', '', 'serialized_search_array_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'serialized_search_parameters', 'text', 'Serialized Search Parameters', 100, 100, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'share_name', 'text', 'Share Name', 25, 43, 8, '', 0, 0, 0, '', 0, '', '', '', 'share_name_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('search_log', 'search_log', 'user_id', 'text', 'User ID', 15, 0, 0, '', 0, 0, 0, '', 0, '', '', '', 'user_id_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'activity', 'activity_date', 'date', 'Activity Date', 10, 0, 0, '', 0, 0, 0, '', 1, '', 'Date', '', '', 1, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'activity', 'activity_type', 'selectmenu', 'Activity Type', 20, 0, 0, '', 0, 0, 0, '', 1, '', 'Type', 'activity_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'activity', 'issue', 'selectmenu_issue', 'Activity Issue', 40, 0, 0, '', 0, 0, 0, '', 1, '', 'Issue', 'get_issue_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'activity', 'pro_con', 'selectmenu', 'Activity Pro/Con', 30, 0, 0, '', 0, 0, 0, '', 1, '', 'Pro/Con', 'pro_con_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'address', 'address_type', 'selectmenu', 'Address type ', 30, 0, 0, '', 0, 0, 0, '', 1, '', '', 'address_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'address', 'city', 'text', 'City/town ', 40, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'address', 'state', 'selectmenu', 'State ', 50, 0, 0, '', 0, 0, 0, '', 1, '', '', 'state_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'address', 'zip', 'text', 'Postal code ', 60, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'constituent_match', 'add_unmatched', 'checked', 'Add unmatched constituents (uncheck to skip unmatched):', 10, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'constituent_match', 'protect_blank_overwrite', 'checked', 'Protect all fields from being overwritten by blank input (leave checked for most uploads):', 35, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'constituent_match', 'protect_identity', 'checked', 'For matched constituents, only update phone, email or activity (protect name, custom data and address):', 30, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'constituent_match', 'update_matched', 'checked', 'Update matched constituents (uncheck to skip matched):', 20, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'email', 'email_type', 'selectmenu', 'Email type ', 70, 0, 0, '', 0, 0, 0, '', 1, '', '', 'email_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'history', 'upload_by', 'selectmenu', 'Upload User', 20, 20, 20, '', 0, 1, 0, '', 0, '', '', 'get_administrator_array', 'issue_staff_formatter', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'history', 'upload_time', 'text', 'Upload Time', 10, 10, 10, '', 0, 1, 0, '', 0, '', 'Not yet uploaded', '', '', 1, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'ID', 'text', 'Internal Id for Upload', 0, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'serialized_column_map', 'textarea', '', 50, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'serialized_default_decisions', 'textarea', '', 70, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'serialized_final_results', 'textarea', '', 80, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'serialized_match_results', 'textarea', '', 60, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'serialized_upload_parameters', 'textarea', '', 40, 0, 0, '', 0, 1, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'upload_file', 'text', '', 25, 25, 25, '', 0, 0, 1, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'initial', 'upload_status', 'selectmenu', '', 35, 35, 35, '', 0, 1, 1, '', 0, '', '', 'upload_status', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'new_issue_creation', 'create_issues', 'checked', 'Create new issues from unmatched non-blank titles (check to accept or go back and unmap titles):', 60, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'phone', 'phone_type', 'selectmenu', 'Phone type ', 80, 0, 0, '', 0, 0, 0, '', 1, '', '', 'phone_type_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'charset', 'selectmenu', 'Character set (try changing this if characters look wrong or you see stray question marks in your upload text)', 45, 0, 0, '', 0, 0, 0, 'UTF-8', 1, '', '', 'charset_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'delimiter', 'radio', 'Delimiter (character between fields)', 20, 0, 0, '', 0, 0, 0, 'comma', 1, '', '', 'delimiter_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'enclosure', 'radio', 'Enclosure (character enclosing fields that might include the delimiter)', 30, 0, 0, '', 0, 0, 0, '2', 1, '', '', 'enclosure_options', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'escape', 'text', 'Escape (character indicating that next character should be read literally, not as enclosure or delimiter)', 40, 0, 0, '', 0, 0, 0, '', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'includes_column_headers', 'checked', 'Has column headers', 5, 0, 0, '', 0, 0, 0, '1', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'max_execution_time', 'text', 'Max execution time for verification', 100, 0, 0, '', 0, 0, 0, '300', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('upload', 'save_options', 'max_line_length', 'text', 'Max line length (sum of lengths of data in all fields in the input file row)', 50, 0, 0, '', 0, 0, 0, '2000', 1, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('user', 'disable_autocomplete', 'disable_autocomplete', 'checked', 'Disable', 70, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01'),
('user', 'signature', 'signature', 'textarea', '', 10, 0, 0, '', 0, 0, 0, '', 0, '', '', '', '', 0, 0, 1, 0, 0, '2000-01-01 01:01:01');
INSERT INTO wp_wic_form_field_groups ( entity_slug, group_slug, group_label, group_legend, group_order, initial_open, sidebar_location, last_updated_time ) VALUES
( 'constituent', 'contact', 'Contact Info', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'constituent', 'case', 'Case Management', '', 30, 0, 0, '2000-01-01 01:01:01'),
( 'constituent', 'personal', 'Personal Info', '', 20, 0, 0, '2000-01-01 01:01:01'),
( 'constituent', 'registration', 'Registration', 'Resident or voter registration and district information as uploaded or from central database copy -- no manual updates.', 40, 0, 0, '2000-01-01 01:01:01'),
( 'constituent', 'delete', 'Delete/Dedup', 'Start hard delete/dedup dialog.  Note that before version 3, WP Issues CRM did a soft delete by marking constituents as "Deleted". The old "Deleted" marking no longer has any effect.
 You can search for any old "Deleted" records in Advanced Search or just purge them all in Manage Storage. ', 45, 0, 0, '2000-01-01 01:01:01'),
( 'constituent', 'dedup', 'Dummy to create field in DOA, but screened out in form creation', '', 90, 1, 0, '2000-01-01 01:01:01'),
( 'constituent', 'activity', 'Activities', '', 50, 1, 1, '2000-01-01 01:01:01'),
( 'address', 'address_line_1', 'Address Line 1', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'address', 'address_line_2', 'Address Line 2', '', 20, 0, 0, '2000-01-01 01:01:01'),
( 'email', 'email_row', 'Email Row', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'external', 'external', 'Step One: Select Form', 'You can use major Wordpress form plugins to create constituent and activity records in WP Issues CRM from the front end.
WP Issues CRM will match the submitted form data into your database, creating new constituent records as needed for non-matching submissions.
<br/><br/>Select form type and select form (you must install the applicable form plugin and add the form first). <strong>We currently support: <a  target="_blank" href="http://www.gravityforms.com/">Gravity Forms</a> 
and <a  target="_blank" href="https://wordpress.org/plugins/contact-form-7/">Contact Form 7</a></strong>.<br/><br/>', 10, 1, 0, '2000-01-01 01:01:01'),
( 'external', 'defaults', 'Step Two: Classify Form Submissions', 'Select an issue (required) and activity type (optional) to classify submissions coming in through this form.', 20, 1, 0, '2000-01-01 01:01:01'),
( 'external', 'types', 'Option: Data Types', 'Select phone/email/address types to be assigned to data coming in through this interface.', 45, 1, 1, '2000-01-01 01:01:01'),
( 'external', 'assignments', 'Step Three: Map Form Fields', 'Please save/update basic selections from steps one and two before mapping fields.<br/><br/><button id="map_form_fields_button" class="wic-form-button">Map Form Fields</button>', 30, 1, 0, '2000-01-01 01:01:01'),
( 'external', 'management', 'Option: Case Management', 'Select a staff member and case status to be assigned to constituents submitting data through this interface. Note that if a constituent has been previously
assigned to another staff member and the status is still open, the constituent will not be reassigned.  Either way, the review date will be set to today unless you leave the staff field blank.  If a constituent
is previously assigned and has an open status, that will not be removed, even if default status is not set for this interface.', 40, 1, 1, '2000-01-01 01:01:01'),
( 'external', 'front_end_posts', 'Option: Front End Posts', 'You can use WP Issues CRM to create new Wordpress posts (and users) from forms. 
The new posts will be created as front facing posts on your site and the interface will log an activity record  for the new or existing constituent 
as for any other form submission.<br/><br/>
For new posts to be created, email_address, post_title and post_content must be mapped from the form and non-blank. It is up to the form to include and require those 
fields, otherwise new post/user creation will fail and insert an error message into the note on the activity created by the form interface. 
If new post creation fails, you will still get whatever notice the form sends.  
<br/><br/>User naming is controlled by the submitting form.  If a field keyed as `nick_name` is included in the form and is non-blank, it will be set as the display name for the new Wordpress user.  Otherwise, first and/or last name,
as mapped will be used.  However, there is no need to require any name at all.  A unique anonymous user name will be generated.<br/><br/>
This interface is designed to securely support transient users and returning users without requiring login for posting.  
Returning users who enter the same email address will see their display name remain constant across posts.
New Wordpress users will be created as Subscribers with no privileges and no password will be sent to them.  All user names, as opposed to display names, will include a 15 character random additional string and the password created 
for them is also hard to hack, 30 characters long with special characters. The site administrator can, of course,
create a usable login name and password (and reattribute posts to that usable login) through the Wordpress User interface.<br/><br/>
Control of spam submissions depends on the form.  The form plugins we support include spam control tools and we do encourage full use of those tools.', 50, 0, 1, '2000-01-01 01:01:01'),
( 'external', 'update', 'Option: Update Policies for Existing Constituents', 'WP Issues CRM attempts to match incoming data to existing constituents
to avoid creating duplicates.  For unmatched constituents, all categories of incoming data will always be added, but, depending on the interface data source, you may want to set different policies on how incoming data will be applied
for matched constituents.  Note that constituent matching is attempted using field combinations in this order: (1) first name and email, (2) email alone, (3) first name, last name, street_address, (4)
first 5 letters of each of first name, full last name, street_address, (5) first name, last name, dob, (6) first name, last name, zip.', 60, 0, 1, '2000-01-01 01:01:01'),
( 'external', 'delete', 'Delete Form Interface', 'Deleting the interface will NOT delete the form and will NOT delete data previously captured through the form.', 100, 0, 1, '2000-01-01 01:01:01'),
( 'phone', 'phone_row', 'Phone Row', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'activity', 'activity', '', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'issue', 'issue_content', 'Content', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'issue', 'issue_classification', 'Classification', '', 20, 0, 0, '2000-01-01 01:01:01'),
( 'issue', 'issue_management', 'Management', '', 30, 0, 0, '2000-01-01 01:01:01'),
( 'issue', 'issue_creation', 'Codes', 'These fields are not updateable except through the regular Wordpress admin screens.', 40, 0, 0, '2000-01-01 01:01:01'),
( 'issue', 'activity_open', 'Activity Tracking', 'When should issue appear in dropdown for entering activities', 25, 1, 0, '2000-01-01 01:01:01'),
( 'issue', 'activity', 'Activities', '', 50, 1, 1, '2000-01-01 01:01:01'),
( 'owner', 'blog', 'Site Info', 'Adjust these variables through Wordpress settings interface.', 10, 1, 0, '2000-01-01 01:01:01'),
( 'owner', 'owner', 'Site Info', 'Set these variables to allow and segment this site\'s access to the central copy of WP Issues CRM for constituent data synchronization.', 20, 1, 0, '2000-01-01 01:01:01'),
( 'owner', 'owner_info', 'Defining Owners', 'Explanation', 30, 1, 1, '2000-01-01 01:01:01'),
( 'option_group', 'option_group', 'Option Groups', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'option_value', 'option_value', 'Option Values', '', 0, 0, 0, '2000-01-01 01:01:01'),
( 'data_dictionary', 'data_dictionary', 'Customizable Fields', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'data_dictionary', 'current_field_config', 'Groups and Enabled Fields', 'Refer to the list of groups and enabled fields on the constituent form to choose where to position your custom field.', 20, 1, 0, '2000-01-01 01:01:01'),
( 'option_group', 'current_option_group_usage', 'Existing Database Values for this Option', 'Refer to the listing below of actually used option values for this option group when modifying the option value list.', 90, 1, 0, '2000-01-01 01:01:01'),
( 'synch', 'mark_deleted', 'Departed Constituents', 'Mark constituents no longer registered in district with Synch Status "N"', 10, 1, 0, '2000-01-01 01:01:01'),
( 'synch', 'refresh_registration', 'Registration Changed', 'Refresh changed registration data for constituents in district -- mark with Synch Status "R"', 20, 1, 0, '2000-01-01 01:01:01'),
( 'synch', 'refresh_address', 'Address Changed', 'Refresh changed address data for constituents in district -- mark with Synch Status "R"', 30, 1, 0, '2000-01-01 01:01:01'),
( 'synch', 'add_constituents', 'New Constituents', 'Add newly registered constituents -- mark with Synch Status "A"', 40, 1, 0, '2000-01-01 01:01:01'),
( 'synch', 'synch_info', 'Synch Info', 'Explanation', 50, 1, 1, '2000-01-01 01:01:01'),
( 'user', 'signature', '', 'simple group pulled in to email_settings form', 4, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'initial', 'Initial Upload', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'upload_parameters', 'Upload Parameters', '', 20, 1, 1, '2000-01-01 01:01:01'),
( 'upload', 'save_options', 'File Parse Settings', '', 15, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'history', 'History', '', 25, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'mappable', 'Mappable Fields', '', 30, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'summary_results', 'Constituent matching results', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'constituent_match', 'Constituent add/update choices', 'Choose how cases will be handled in the final upload process', 20, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'constituent', 'Constituent default values', 'The constituent fields below have not been mapped. You can set defaults for them.', 30, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'address', '', '', 32, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'phone', '', '', 34, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'email', '', '', 36, 1, 0, '2000-01-01 01:01:01'),
( 'upload', 'activity', 'Activity default values ', 'The activity fields below have not been mapped. You can set default values for them.  
If any activity fields are mapped or defaulted, an activity record will be created from each record in the input file.', 
40, 1, 1, '2000-01-01 01:01:01'),
( 'upload', 'issue', '', '', 45, 1, 1, '2000-01-01 01:01:01'),
( 'upload', 'new_issue_creation', 'New Issue Titles ', 'Back at the mapping step, you mapped an input field to Issue Title (and did not map a field to Issue, which would override Issue Title). 
Some of the titles in your input data do not match existing Issue Titles. If you wish, WP Issues CRM will create new posts/issues, using the titles
 and content that you have mapped. You must either check to accept this or go back and unmap Issue Title.', 50, 1, 1, '2000-01-01 01:01:01'),
( 'email_compose', 'compose_options', '', '', 10, 1, 1, '2000-01-01 01:01:01'),
( 'email_inbox', 'inbox_options', '', '', 10, 1, 1, '2000-01-01 01:01:01'),
( 'email_settings', 'account', 'Account', 'WP Issues CRM supports several types of account for receiving and sending email.', 1, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'activesync', 'ActiveSync', 'WP Issues CRM will attempt to autodiscover your Exchange Server if you save an Exchange email and set the Exchange password for that email here.', 2, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'gmail_oauth', 'Gmail', 'WP Issues CRM can read and send mail through the Gmail API.  Gmail heavily filters incoming email, especially if forwarded, and so may not be suitable as a general purpose constituent inbox where responsiveness is a priority.', 3, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'user_sig', 'Signature', '', 20, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'team_definition', 'Team Emails', 'Incoming emails from addresses that you list here will appear in the Team tab.  You can use % as a wildcard for any string of characters.   For example %masenate% would include any email address with masenate in the middle. Separate terms with the pipe "|" character.
For example:  mybestfriend@gmail.com|staffmember1@jones.com|%masenate%|%belmontma.gov.  Comparisons are not case sensitive.', 30, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'imap_message_grouping', 'Grouping', 'WP Issues CRM groups messages for bulk handling following conservative rules.  In addition to requiring a
 subject line which you have affirmatively trained, it also checks for consistency of message content. Note that matches are updated dynamically as you make new replies.', 30, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'is_my_constituent_rules', 'Constituents', 'If you serve a geographic district, WP Issues CRM can often determine whether email comes from your constituents.  
All in one string in any order, enter cities, zip codes or two letter abbreviations for states that you wish to consider as comprising your constituency.  
For example, "NH|Belmont|Watertown|02134|02135|02116".  Use this setting together with the Non-constituent Reply setting or just use it to update your database as email contacts are automatically logged.  
For existing constituents with already known constituency status, the saved status will override the results of the Constituents logic.  Message lines containing messages from known constituents will be highlighted blue in the inbox. ', 31, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'non_constituent_responder', 'Reply', 'If you have enabled Constituents settings, then if you enable an autoreply here, when non-constituents (or people who do not provide a parseable address)
send repetitive emails for which you have trained responses intended for your constituents, they will get this standard reply instead of your trained reply.  This autoreply only replies to trained incoming emails.  It is intended 
to filter out non-constituents from incoming mass email campaigns.  It does not take the place of a general purpose auto reply.  New constituents will not be created and no activity record will be saved when an autoreply is issued.', 32, 1, 0, '2000-01-01 01:01:01'),
( 'email_settings', 'imap_subjects', 'Forget', 'Set global subject mapping forget date -- exclude possibly obsolete older mappings in all processing.
    You can use specific dates in any english format or use variable phrases like "30 days ago".', 70, 1, 1, '2000-01-01 01:01:01'),
( 'email_settings', 'imap_to_wic_disqualifiers', 'Disqualifiers', 'List words that should identify a text block as NOT the address of the person sending the email -- typically, phrases from your name or address. Separate phrases with the pipe "|" character.  Other punctuation will be ignored.
For example "Brownsberger|State House|02133"', 90, 1, 1, '2000-01-01 01:01:01'),
( 'email_settings', 'imap_to_wic_address_parse_options', 'Rules', 'You may not need to change these settings ever, but adjustments may help handle special cases.', 100, 1, 1, '2000-01-01 01:01:01'),
( 'email_settings', 'imap_to_wic_parse_terms', 'Terms', 'You will not need to change these settings often if ever. Separate terms with the pipe "|" character.  Other punctuation will be ignored. Clear any field to load defaults on next refresh. Then alter values to trigger auto save to assure that defaults are restored.', 110, 1, 1, '2000-01-01 01:01:01'),
( 'email_settings', 'imap_to_wic_parse_titles', 'Titles', 'You will not need to change these settings often if ever. Separate terms with the pipe "|" character.  Other punctuation will be ignored. Clear any field to load defaults on next refresh.  Then alter values to trigger auto save to assure that defaults are restored.', 120, 1, 1, '2000-01-01 01:01:01'),
( 'manage_storage', 'statistics', 'Storage Statistics', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'manage_storage', 'staging', 'Purge Upload Files', 'Purge temporary upload files and upload history.  Will NOT backout uploaded data.', 20, 1, 1, '2000-01-01 01:01:01'),
( 'manage_storage', 'search', 'Purge Logs', 'Purge search log and inbox synchronization log.', 25, 1, 1, '2000-01-01 01:01:01'),
( 'manage_storage', 'constituent', 'Purge Constituents', 'Purge constituent data -- check to keep constituents with specified data categories. 
	All other constituents will be purged.  For example, if you check \"Keep if activity\" and \"Keep if email address\", then only constituents that have either an activity or an email address will be retained.
	All lacking both activity or email address be purged.  Uncheck \"Keep all constituents\" and enter confirmation phrase to confirm constituent purge.
	Note that the entire search log is always purged when any constituents are purged.', 30, 1, 1, '2000-01-01 01:01:01'),
( 'manage_storage', 'clean_deleted', 'Clean Up old \"Deleted\" constituents.', 'Since version 3.0, WP Issues CRM does a hard delete on constituents when requested from the constituent update form.
Earlier versions used a soft delete, marking constituents as \"Deleted\".  These markings are now ignored when preparing lists. Use the button below to clean up \"Deleted\" constituents by physically deleting them. ', 50, 1, 1, '2000-01-01 01:01:01'),
( 'list', 'list', 'List Transients', '', 10, 0, 0, '2000-01-01 01:01:01'),
( 'advanced_search', 'search_definition', 'Search Definition', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'advanced_search', 'search_constituent', 'Constituent Search Terms', '', 20, 1, 0, '2000-01-01 01:01:01'),
( 'advanced_search', 'search_activity', 'Activity Search Terms', '', 30, 1, 0, '2000-01-01 01:01:01'),
( 'advanced_search', 'search_constituent_having', 'Constituent Activity Search Terms', 'Choose search terms applicable to the selected set of activities for each selected constituent.', 40, 1, 0, '2000-01-01 01:01:01'),
( 'advanced_search_constituent', 'constituent_row', '', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'advanced_search_activity', 'activity_row', '', '', 10, 1, 0, '2000-01-01 01:01:01'),
( 'advanced_search_constituent_having', 'constituent_having_row', '', '', 10, 1, 0, '2000-01-01 01:01:01' );
