You are running in Kiosk mode as Demo User (reset (x))  |  Turn Demo Mode On
 
Home
Logs
Calendar
Entry
BedReg
Reports
Menu
 

Update Engine Object


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

Or, enter a table name:
["elevated_concern_current","entry","hospital","jail","phone","phone_current","reference","reg_program","report","reg_program_current","report_block","report_usage","report_old","report_old_log","residence_own_current","service","service_cd","service_housing","staff_employment","staff_employment_latest","staff","staff_assign","staff_assign_current","staff_employment_current","staff_phone","staff_remote_login","staff_remote_login_current","staff_remote_login_now","status_eligible","system_log","table_log_enabled_tables","target_date","target_date_current","test_foo","test_now","user_login","user_login_latest","user_option","veteran_status","address_current","address_staff","address_staff_current","address_client","config_staff_password","agency_feature_config","config_staff_password_current","staff_password","staff_password_current","alert_notify","address_client_current","engine_label","alert_notify_current","alert_notify_enabled_objects","attachment","attachment_link","auth_token","auth_token_current","charge","payment","balance_project","balance_combined","bar","bar_current","bar_guest","bar_guest_current","bed","bed_reg","calendar","calendar_appointment","calendar_appointment_cancelled","alert","alert_consolidated","calendar_appointment_current","calendar_current","chronic_homeless_status_asked","client_protected","client_protected_current","client","client_death","client_guest_ineligible","client_note","client_ref","config_email","consent","data_dictionary","db_access","db_agency_functions","db_agency_relations","db_list","db_revision_history","desert","disability","duplication","duplication_staff","education_level","elevated_concern","address","elevated_concern_note","entry_visitor","ethnicity","family_member","feedback","guest_identification","guest_identification_current","guest","guest_authorization","guest_authorization_current","guest_visit","guest_visit_current","guest_visit_authorized","help","housing_unit","residence_other","residence_own","housing_history","housing_unit_current","housing_unit_subsidy","income","info_additional","info_additional_type","alert_notify_backup2","alert_notify_backup","alert_notify_log_backup2","alert_notify_log_backup","bar_back","client_ethnicity_backup","sys_flag","news","permission","permission_current","l_bed_group","l_entry_location","log","l_output","l_payment_form","l_payment_type","l_permission_type","l_phone_type","l_program","l_referral_source","l_report_block_type","l_report_category","l_service","l_service_cd","l_service_housing","l_service_project","l_sexual_minority_status","l_staff_assign_type","l_staff_employment_status","l_staff_position","l_staff_shift","l_state","l_unit_type","l_value_type","l_veteran_status","l_visit_type","l_accuracy","l_agency","l_agency_facility","l_agency_feature","l_agency_flavor","l_agency_program","l_agency_project","l_agency_staff_type","l_alert_notify_action","l_bar_location","l_bar_incident_location","l_bar_reason","l_bar_resolution_location","l_barred_from","l_bed_rereg","l_brc_resolution","l_calendar_appointment_resolution","l_calendar_type","l_charge_type","l_chronic_homeless_status","l_client_death_data_source","l_client_death_location","l_client_death_type","l_consent_status","l_consent_type","l_contact_type","l_data_source","l_day_of_week","l_departure_reason","l_void_reason","l_volunteer","l_washington_county","l_washington_county_add","l_yes_no","l_inanimate_item","log_back_dbmod_16","l_log_type","l_departure_type","l_desert_type","l_disability","l_elevated_concern_reason","l_elevated_concern_status","l_ethnicity","l_ethnicity_simple","l_event_repeat_type","l_exit_status","l_facility","l_family_relation","l_fund_type","l_gender","l_geography","l_geography_detail","l_grade_level","l_highest_education","l_hispanic_origin","l_hospital","l_housing_project","l_identification_type","l_income","l_income_add","l_income_certification_type","l_jail_facility","l_language","l_move_out_was","l_name_suffix","l_news_priority","l_other_assistance","tbl_l_permission_type","tbl_permission","tbl_phone","tbl_reference","tbl_l_program","tbl_l_yes_no","tbl_l_referral_source","tbl_reg_program","tbl_l_report_block_type","tbl_report_block","tbl_l_report_category","tbl_report","tbl_report_usage","tbl_l_geography","tbl_l_geography_detail","tbl_l_accuracy","tbl_l_state","tbl_residence_other","tbl_l_chronic_homeless_status","tbl_l_departure_reason","tbl_l_departure_type","tbl_l_housing_project","tbl_l_exit_status","tbl_l_facility","tbl_housing_unit","tbl_residence_own","tbl_l_contact_type","tbl_l_service","tbl_l_service_project","tbl_service","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_agency_staff_type","tbl_l_day_of_week","tbl_l_staff_employment_status","tbl_l_staff_position","tbl_l_staff_shift","tbl_staff_password","tbl_staff_employment","tbl_l_phone_type","tbl_staff_phone","tbl_staff_remote_login","tbl_system_log","tbl_target_date","tbl_user_login","tbl_staff","tbl_client","tbl_user_option","tbl_l_veteran_status","tbl_veteran_status","tbl_config_staff_password","tbl_engine_label","tbl_alert_log","tbl_alert_notify_log","tbl_attachment_link_log","tbl_attachment_log","tbl_bar_log","tbl_bed_log","tbl_calendar_appointment_log","tbl_calendar_log","tbl_charge_log","tbl_client_death_log","tbl_client_log","tbl_client_protected_log","tbl_client_ref_log","tbl_data_dictionary_log","tbl_db_access_log","tbl_db_revision_history_log","tbl_disability_log","tbl_duplication_log","tbl_duplication_staff_log","tbl_education_level_log","tbl_elevated_concern_log","tbl_entry_log","tbl_ethnicity_log","tbl_feedback_log","tbl_help_log","tbl_hospital_log","tbl_housing_unit_log","tbl_housing_unit_subsidy_log","tbl_income_log","tbl_info_additional_log","tbl_jail_log","tbl_l_accuracy_log","tbl_l_agency_facility_log","tbl_l_agency_feature_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_bar_location_log","tbl_l_bed_group_log","tbl_l_bed_rereg_log","tbl_l_brc_resolution_log","tbl_l_calendar_appointment_resolution_log","tbl_l_calendar_type_log","tbl_l_chronic_homeless_status_log","tbl_l_client_death_data_source_log","tbl_l_client_death_location_log","tbl_l_client_death_type_log","tbl_l_contact_type_log","tbl_l_data_source_log","tbl_l_day_of_week_log","tbl_l_departure_reason_log","tbl_l_departure_type_log","tbl_l_disability_log","tbl_l_elevated_concern_reason_log","tbl_l_elevated_concern_status_log","tbl_l_entry_location_log","tbl_l_ethnicity_log","tbl_l_ethnicity_simple_log","tbl_l_event_repeat_type_log","tbl_l_exit_status_log","tbl_l_facility_log","tbl_l_fund_type_log","tbl_l_gender_log","tbl_l_geography_detail_log","tbl_l_geography_log","tbl_l_grade_level_log","tbl_l_highest_education_log","tbl_l_hispanic_origin_log","tbl_l_housing_project_log","tbl_l_inanimate_item_log","tbl_l_income_certification_type_log","tbl_l_income_log","tbl_l_info_additional_type_log","tbl_l_jail_facility_log","tbl_l_language_log","tbl_l_name_suffix_log","tbl_l_news_priority_log","tbl_l_other_assistance_log","tbl_l_permission_type_log","tbl_l_phone_type_log","tbl_l_program_log","tbl_l_referral_source_log","tbl_l_report_category_log","tbl_l_service_log","tbl_l_service_project_log","tbl_l_sexual_minority_status_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_unit_type_log","tbl_l_value_type_log","tbl_l_veteran_status_log","tbl_l_volunteer_log","tbl_l_washington_county_log","tbl_l_yes_no_log","tbl_log_log","tbl_news_log","tbl_payment_log","tbl_permission_log","tbl_reference_log","tbl_reg_program_log","tbl_report_log","tbl_report_usage_log","tbl_residence_other_log","tbl_residence_own_log","tbl_service_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_l_log_type_log","tbl_engine_config","tbl_address","tbl_agency_feature_config","tbl_alert","tbl_alert_notify","tbl_attachment","tbl_attachment_link","tbl_auth_token","tbl_bar","tbl_bed","tbl_calendar_appointment","tbl_calendar","tbl_charge","tbl_chronic_homeless_status_asked","tbl_client_death","tbl_client_note","tbl_client_note_log","tbl_client_protected","tbl_client_ref","tbl_config_email","tbl_consent","tbl_data_dictionary","tbl_db_access","tbl_db_revision_history","tbl_desert","tbl_disability","tbl_duplication","tbl_duplication_staff","tbl_education_level","tbl_elevated_concern","tbl_entry","tbl_entry_visitor","tbl_ethnicity","tbl_family_member","tbl_feedback","tbl_guest_authorization","tbl_guest_identification","tbl_guest","tbl_guest_visit","tbl_help","tbl_hospital","tbl_housing_unit_subsidy","tbl_income","tbl_info_additional","tbl_info_additional_type","tbl_jail","tbl_l_agency_feature","tbl_l_agency_flavor","tbl_l_alert_notify_action","tbl_l_bar_location","tbl_l_bar_reason","tbl_l_barred_from","tbl_l_bed_group","tbl_l_bed_rereg","tbl_l_brc_resolution","tbl_l_calendar_appointment_resolution","tbl_l_calendar_type","tbl_l_charge_type","tbl_l_client_death_data_source","tbl_l_client_death_location","tbl_l_client_death_type","tbl_l_consent_status","tbl_l_consent_type","tbl_l_data_source","tbl_l_desert_type","tbl_l_disability","tbl_l_elevated_concern_reason","tbl_l_elevated_concern_status","tbl_l_entry_location","tbl_l_ethnicity","tbl_l_ethnicity_simple","tbl_l_event_repeat_type","tbl_l_family_relation","tbl_l_fund_type","tbl_l_gender","tbl_l_grade_level","tbl_l_highest_education","tbl_l_hispanic_origin","tbl_l_hospital","tbl_l_identification_type","tbl_l_inanimate_item","tbl_l_income_certification_type","tbl_l_income","tbl_l_log_type","tbl_l_jail_facility","tbl_l_language","tbl_l_name_suffix","tbl_l_other_assistance","tbl_l_output","tbl_l_sexual_minority_status","tbl_l_unit_type","tbl_l_value_type","tbl_l_visit_type","tbl_l_volunteer","tbl_l_washington_county","tbl_log","tbl_l_news_priority","tbl_news","tbl_l_payment_form","tbl_l_payment_type","tbl_l_void_reason","tbl_payment"]

Switch Login
 
Revision History (0)


Edit this Record
Clone this Record
Delete this Record
 
This is a demo version of AGENCY, with some sample data. Feel free to add and change data as you explore.
Viewing Staff record for Ashley Mathews
show/hide empty rows
The staff table tracks all your staff. A staff record is necessary to use AGENCY. You can also keep volunteers, interns, sited staff and others in this table. It is a good idea to create a staff_employment record for each staff person.
Staff (ID #) Ashley Mathews (41)
Username adwm1989
Staff Email adwm1989@yourdomain.org
Last Name Mathews
First Name Ashley
Legal First Name  
Full Name Mathews, Ashley
Active? Yes
Login Allowed Yes
Staff Title Case Manager
view lookup Program Administration (ADMIN)
view lookup Project Accounting (ACCOUNT)
view lookup Staff Position Case Manager (CASE_MGR)
view lookup Facility Administrative Offices (ADMIN)
view lookup Staff Shift Flex (FLEX)
view lookup Staff Type Paid (PAID)
view lookup Staff Employment Status Full-time (FULLTIME)
Hired On 7/30/2013
Terminated On  
Supervised By Ashley Mathews (41)
view lookup Gender Female (FEMALE)
Notes  
Added by Demo User (2), at 7/30/13 7:47 am.
View config file or def array for Staff
hide empty records
 

1 Alert

No Alert Notify Records

(Add an Alert Notify Record)
 

1 Staff Employment

 

1 Permission

No Remote Login/Access Records

(Add a Remote Login/Access Record)

No Staff Phones

(Add a Staff Phone)