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
 
This is a demo version of AGENCY, with some sample data. Feel free to add and change data as you explore.
Listing Staff
Using: SELECT * FROM staff WHERE agency_facility_code = 'ADMIN'

# Per Page Reverse Totals Columns
Staff (ID #) Username Username Unix Staff Email Kc Staff Id Last Name
First Name Legal First Name Full Name Active? Login Allowed Staff Title
Program Project Staff Position Facility Staff Shift Staff Type
Staff Employment Status Hired On Terminated On Supervised By Pgp Key Public Gender
Notes Added By Added At Record Changed By Record Changed At ord Deleted?
Record Deleted At Record Deleted By Deleted Comment System Log Staff Photo Staff Summary
Staff Phone Old Mh Id
All 4 records, Sorted by Active?
  #
Active?
Staff
Photo
Staff
(ID
#)
Staff
Summary
Staff
Phone
1 Yes Sarah Demo (38)
position: Project Manager
project: Accounting
Supervised By: Lisa Hilton (39)
facility: Administrative Offices
email: demo_sarah@yourdomain.org
no phone numbers
2 Yes Demo User (2)
position: Case Manager
project: Project 2
Supervised By: Ashley Mathews (41)
facility: Administrative Offices
email: demo@yourdomain.org
no phone numbers
3 Yes Ashley Mathews (41)
position: Case Manager
project: Accounting
Supervised By: Ashley Mathews (41)
facility: Administrative Offices
email: adwm1989@yourdomain.org
no phone numbers
4 Yes Ashley Mathews (43)
position: Administrative Support
project: Accounting
Supervised By: Ashley Mathews (41)
facility: Administrative Offices
email: hrbusiness14@gmail.com
no phone numbers