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.

AGENCY Administration

Update Engine Array Stored in DB

This should be run after any database or configuration update.

Update Engine Object

Database Modifications

These modifications have been applied to the database. Database modification files are located in the 'database/pg/db_mods' directory.

Add a Db Revision History
# Per Page Reverse Totals Columns
Db Revision History Id Db Revision Db Revision Description Flavor Git Sha Git Tag
Applied At Comment Added At Added By Record Changed By Record Changed At
ord Deleted? Record Deleted At Record Deleted By Deleted Comment System Log
All 50 records, Sorted by Applied
At
  #
Db
Revision
Git
Tag
Applied
At
1 REPORT_DYNAMIC_PIVOT db_mod.76 12/1/17 12:57 pm
2 ENGINE_LABELS db_mod.75 12/1/17 12:57 pm
3 ARRAY_SORT_FN_FOR_DB db_mod.74 12/1/17 12:57 pm
4 STAFF_PASSWORD_EXPIRATION db_mod.71 12/1/17 12:56 pm
5 REPORT_ENGINE_LINKS db_mod.70 12/1/17 12:56 pm
6 FIX_STAFF_POSITION_LENGTH_IN_STAFF_EMPLOYMENT db_mod.70 12/1/17 12:56 pm
7 EMAIL_SENDER_IN_TABLE db_mod.70 12/1/17 12:56 pm
8 INTERNAL_ACCESS db_mod.69 12/1/17 12:56 pm
9 REORDER_REPORT_BLOCK_SORT_ID db_mod.68 12/1/17 12:56 pm
10 TARGET_DATE db_mod.67 12/1/17 12:56 pm
11 SYSTEM_LIVE_AT db_mod.62 12/1/17 12:56 pm
12 ADD_REMOTE_ACCESS_PERM db_mod.60 11/20/13 5:36 pm
13 ADD_XOR_FUNCTION db_mod.55 11/20/13 5:36 pm
14 ADD_PHOTO_PERMISSION db_mod.50 11/20/13 5:35 pm
15 NEW_REPORT_SYSTEM db_mod.48 11/20/13 5:35 pm
16 UPDATE_GENDER_CODES db_mod.45 11/20/13 5:20 pm
17 CREATE_MISSING_SYSTEM_LOG db_mod.47 11/20/13 5:20 pm
18 ADD_BE_NULL_POINT_FUNCTION db_mod.44 4/11/12 1:54 pm
19 NAME_FULL_IN_STAFF_VIEW db_mod.42 4/11/12 1:53 pm
20 FIX_ALERT_NOTIFY_2_3_4_FIELDS db_mod.40 4/11/12 1:53 pm
21 LENGTHEN_ATTACHMENT_LINK_PARENT_OBJECT db_mod.38 4/11/12 1:53 pm
22 ENABLING_CHANGED_AT_TRIGGERS2011-06-26 02:10:35.853685-07   6/26/11 2:10 am
23 RESTRUCTURE_INFO_ADDITIONAL_TYPE db_mod.34 5/24/11 3:12 pm
24 MISSING_INFO_ADDITIONAL_TABLES db_mod.33 5/24/11 3:11 pm
25 FROM_UNITED_WAY_DEFAULT_FALSE db_mod.32 5/24/11 3:11 pm
26 ADD_UNKNOWN_ACCURACY_OPTION db_mod.31 5/24/11 3:11 pm
27 LOOSEN_DB_LIST_UNIQUE_CONSTRAINT db_mod.30 5/24/11 3:11 pm
28 FIX_TABLE_LOG_DELETES db_mod.29 5/24/11 3:11 pm
29 DB_TABLE_LOG_FUNCTIONS   5/24/11 3:11 pm
30 ADD_EXPORT_PERMISSIONS db_mod.25 5/24/11 3:10 pm
31 ALERT_NOTIFY_VALIDITY_CHECKS db_mod.24 5/24/11 3:10 pm
32 ENHANCE_ALERT_NOTIFY4 db_mod.23 5/24/11 3:10 pm
33 ENHANCE_ALERT_NOTIFY3 db_mod.22 5/24/11 3:10 pm
34 ENHANCE_ALERT_NOTIFY2 db_mod.21 5/24/11 3:09 pm
35 ENHANCE_ALERT_NOTIFY db_mod.20 5/24/11 3:08 pm
36 CREATE_AUTH_TOKEN_TABLE db_mod.19 5/23/10 11:05 pm
37 ADD_UPDATE_ENGINE_PERMISSION db_mod.18 5/23/10 11:05 pm
38 UPDATE_EMAIL_ALERTS db_mod.17 5/23/10 11:05 pm
39 CREATE_NEW_LOG_TABLE db_mod.16 5/23/10 11:05 pm
40 ADD_PERMISSION_REPORT db_mod.15 5/23/10 11:02 pm
41 ENABLE_ATTACHMENTS db_mod.14 5/23/10 11:02 pm
42 REQUIRE_DONOR_NOTE_TEXT db_mod.12 5/23/10 11:02 pm
43 CREATE_INFO_ADDITIONAL info_additional 5/23/10 11:01 pm
44 ENABLING_TABLE_LOG_TRIGGERS2010-04-21 15:27:08.62315-07   4/21/10 3:27 pm
45 ADD_DEFAULT_REPORTS db_mod.6 10/30/09 12:22 pm
46 CHANGE_REPORT_DEFAULTS db_mod.5 10/30/09 12:19 pm
47 FIX_CALENDAR_REPEATING_EVENTS db_mod.4 10/16/09 3:26 pm
48 REJECT_WRONG_FLAVOR_DB_MODS db_mod.3 10/16/09 3:25 pm
49 DB_REV_RESTRUCTURE db_mod_1 10/15/09 7:19 pm
50 Initial AGENCY Install   10/6/09 2:52 am
Browse AGENCY Tables via Engine

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"]
Browse Engine Config Array

These pages may take some time to load

Enter a configured object name:

Include Field Definitions (these can be long)
Staff Account Administration

Add a new staff account

 

Show All Staff Permission Records

Transfer/Close Caseload
Transfer or close?
Transfer/Close for
Transfer caseload to
Date original assignment ends (new assignments will start next day)
Donor Unduplication
Set Cookie ID for this MachineNo Cookie Configuration Specified. (Can set AG_MACHINE_ID_BY_COOKIE in agency_config_local.php)
Database Maintenance
back to top