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
 
Choose Object Type:

 
This is a demo version of AGENCY, with some sample data. Feel free to add and change data as you explore.
AGENCY Advanced Search Page
Choose search criteria for Client records.

I want to

Field Name Condition Value Group*
Client
Last name
First name
Middle name
Name Suffix
Name Alias
Date of Birth
start:
end:
Social Security #
Gender
Hispanic Origin
Needs Interpreter
Primary Language
Veteran Status
Sexual Minority Status
Clinical Id
King Cty Id
Spc Id
Comments
Medical Issues
Medications
Allergies
Last Photo At
Issue No
Resident Id
Record Added At
Record Added By 2
Record Changed At
Record Changed By 2
ord Deleted?
Yes No
Record Deleted At
Record Deleted By 2
Deleted Comment
System Log
Name Full
Name Full Alias
Protected Id?
Yes No
Pronoun Subject
Pronoun Object
Pronoun Possessive
Pronoun Possessive Pronoun
Pronoun Reflexive
 

* Grouping functionality is experimental. It may not work for some objects (It is known to not work with Logs). Re-ordering by column will also not work when grouping on fields.