You are running in Kiosk mode as Demo SuperUser (reset (x))  |  Turn Demo Mode On
 
Home
Add donor
Menu
Reports
 

Update Engine Object


List all DB Views
List all DB Tables
List all AGENCY functions

Or, enter a table name:
["address","gift_inkind","gift","donor_stat","donor_total","duplication_staff","feedback","gift_united_way","help","info_additional","info_additional_type","user_login","user_login_latest","user_option","volunteer_hours","volunteer_reg","address_preferred","a_table","target_date","target_date_current","alert","alert_consolidated","staff_employment_latest","report_block","report","config_email","staff_employment","staff_employment_current","staff","config_staff_password","config_staff_password_current","alert_notify","alert_notify_current","alert_notify_enabled_objects","staff_password","staff_password_current","attachment","donor","engine_label","attachment_link","auth_token","auth_token_current","boo_table","boo_view","boo_top_view","calendar","calendar_appointment","calendar_appointment_cancelled","calendar_appointment_current","calendar_current","data_dictionary","db_access","db_agency_functions","db_agency_relations","db_list","db_revision_history","donor_flag","donor_link","donor_note","gift_cash","alert_notify_backup2","alert_notify_backup","alert_notify_log_backup2","alert_notify_log_backup","news","permission","permission_current","proposal","reference","report_usage","report_old","report_old_log","sent_mail","staff_assign","staff_assign_current","staff_phone","staff_remote_login","staff_remote_login_current","staff_remote_login_now","system_log","table_log_enabled_tables","l_accuracy","l_active","l_address_obsolete_reason","l_address_type","l_agency","l_agency_facility","l_agency_flavor","l_agency_program","l_agency_project","l_agency_staff_type","l_alert_notify_action","l_ask","l_calendar_appointment_resolution","l_calendar_type","l_contract","l_day_of_week","l_donor_flag_type","l_donor_type","l_event_repeat_type","l_gender","l_gift_cash_form","l_inkind_item","l_length_commitment","l_volunteer_location","l_yes_no","log","l_inanimate_item","log_back_dbmod_16","l_log_type","l_news_priority","l_output","l_permission_type","l_phone_type","l_proposal_current_status","l_proposal_next_action","l_proposal_status","l_referral_source","l_report_block_type","l_report_category","l_response","l_restriction","l_send_mail","l_staff_assign_type","l_staff_employment_status","l_staff_position","l_staff_shift","l_state","l_value_type","l_volunteer_activity","tbl_log","tbl_l_news_priority","tbl_news","tbl_l_permission_type","tbl_permission","tbl_l_proposal_current_status","tbl_l_proposal_next_action","tbl_l_restriction","tbl_proposal","tbl_reference","tbl_l_report_block_type","tbl_report_block","tbl_l_report_category","tbl_report","tbl_report_usage","tbl_l_response","tbl_sent_mail","tbl_l_agency","tbl_l_staff_assign_type","tbl_staff_assign","tbl_l_agency_facility","tbl_l_agency_program","tbl_l_agency_project","tbl_l_staff_position","tbl_l_agency_staff_type","tbl_staff_employment","tbl_l_day_of_week","tbl_l_staff_employment_status","tbl_l_staff_shift","tbl_staff_password","tbl_l_phone_type","tbl_staff_phone","tbl_staff_remote_login","tbl_system_log","tbl_user_login","tbl_user_option","tbl_l_volunteer_activity","tbl_volunteer_hours","tbl_staff","tbl_donor","tbl_l_length_commitment","tbl_l_referral_source","tbl_l_volunteer_location","tbl_volunteer_reg","tbl_config_email","tbl_target_date","tbl_config_staff_password","tbl_engine_label","tbl_address_log","tbl_alert_log","tbl_alert_notify_log","tbl_attachment_link_log","tbl_calendar_appointment_log","tbl_calendar_log","tbl_data_dictionary_log","tbl_db_access_log","tbl_db_revision_history_log","tbl_donor_flag_log","tbl_donor_link_log","tbl_donor_log","tbl_donor_note_log","tbl_duplication_staff_log","tbl_feedback_log","tbl_gift_cash_log","tbl_gift_inkind_log","tbl_gift_united_way_log","tbl_help_log","tbl_l_accuracy_log","tbl_l_active_log","tbl_l_address_obsolete_reason_log","tbl_l_address_type_log","tbl_l_agency_facility_log","tbl_l_agency_flavor_log","tbl_l_agency_log","tbl_l_agency_program_log","tbl_l_agency_project_log","tbl_l_agency_staff_type_log","tbl_l_alert_notify_action_log","tbl_l_ask_log","tbl_l_calendar_appointment_resolution_log","tbl_l_calendar_type_log","tbl_l_contract_log","tbl_l_day_of_week_log","tbl_l_donor_flag_type_log","tbl_l_donor_type_log","tbl_l_event_repeat_type_log","tbl_l_gender_log","tbl_l_gift_cash_form_log","tbl_l_inanimate_item_log","tbl_l_inkind_item_log","tbl_l_length_commitment_log","tbl_l_news_priority_log","tbl_l_permission_type_log","tbl_l_phone_type_log","tbl_l_proposal_current_status_log","tbl_l_proposal_next_action_log","tbl_l_proposal_status_log","tbl_l_referral_source_log","tbl_l_report_category_log","tbl_l_response_log","tbl_l_restriction_log","tbl_l_send_mail_log","tbl_l_staff_assign_type_log","tbl_l_staff_employment_status_log","tbl_l_staff_position_log","tbl_l_staff_shift_log","tbl_l_state_log","tbl_l_volunteer_activity_log","tbl_l_volunteer_location_log","tbl_l_yes_no_log","tbl_log_log","tbl_news_log","tbl_permission_log","tbl_proposal_log","tbl_reference_log","tbl_report_log","tbl_report_usage_log","tbl_sent_mail_log","tbl_staff_assign_log","tbl_staff_employment_log","tbl_staff_log","tbl_staff_phone_log","tbl_staff_remote_login_log","tbl_user_login_log","tbl_volunteer_hours_log","tbl_volunteer_reg_log","tbl_engine_config","tbl_address","tbl_alert_notify","tbl_alert","tbl_attachment","tbl_attachment_link","tbl_auth_token","tbl_calendar_appointment","tbl_calendar","tbl_data_dictionary","tbl_db_access","tbl_db_revision_history","tbl_donor_flag","tbl_donor_link","tbl_donor_note","tbl_duplication_staff","tbl_feedback","tbl_gift_cash","tbl_gift_inkind","tbl_gift_united_way","tbl_help","tbl_info_additional","tbl_info_additional_type","tbl_l_accuracy","tbl_l_active","tbl_l_address_obsolete_reason","tbl_l_address_type","tbl_l_agency_flavor","tbl_l_alert_notify_action","tbl_l_ask","tbl_l_calendar_appointment_resolution","tbl_l_calendar_type","tbl_l_contract","tbl_l_donor_flag_type","tbl_l_donor_type","tbl_l_event_repeat_type","tbl_l_gender","tbl_l_gift_cash_form","tbl_l_inanimate_item","tbl_l_inkind_item","tbl_l_log_type","tbl_l_output","tbl_l_proposal_status","tbl_l_send_mail","tbl_l_state","tbl_l_value_type","tbl_l_yes_no"]

Switch Login
 
This is a demo version of AGENCY, with some sample data. Feel free to add and change data as you explore.
Listing Donor record for
Using: SELECT *, address_names(address_id(donor_id)) AS names FROM donor

Add a Donor
# Per Page Reverse Totals Columns
Donor Donor Name Donor Type Annual Report Listing Www Url Date of Birth
Source Anonymous? Skip Thanks Send Mail Ask Preferred Address
Inactive? From United Way Special Next Mail Scratch Address Mail Added By
Added At Record Changed By Record Changed At ord Deleted? Record Deleted At Record Deleted By
Deleted Comment System Log Donor Comment Names
All 13 records, Sorted by Donor_name(donor_id)
  #
Donor
Donor
Type
Names
Inactive?
1 H.E.B. (9) Corporation   No
2 Jimmy James (3) Individual   No
3 Joe Blow (6) Individual   No
4 Joe Nona (7) Corporation   No
5 Joe P. Sample (8) Civic/Religous Groups   No
6 John Rockefeller (1) Individual   No
7 Kentalope Curtis (13) Individual   No
8 Mr. Ed Moe (4) Individual   No
9 Mrs. Sue Wills (5) Foundations   Yes
10 ra (11) Individual   No
11 Sarah Fausmer (2) Individual   No
12 sssssssssss (12) Corporation   No
13 testing mcfee (10) Individual   No