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:
["entry","hospital","jail","phone_current","reference","reg_program","reg_program_current","report_block","report_usage","report","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","alert_consolidated","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","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","elevated_concern_current","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","phone","l_bed_group","l_entry_location","log","l_other_assistance","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_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_departure_type","l_visit_type","l_void_reason","l_volunteer","l_washington_county","l_washington_county_add","l_yes_no","log_back_dbmod_16","l_inanimate_item","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_log_type","l_move_out_was","l_name_suffix","l_news_priority","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_user_option","tbl_client","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_log_type_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_engine_config","tbl_address","tbl_agency_feature_config","tbl_alert_notify","tbl_alert","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_jail_facility","tbl_l_language","tbl_l_log_type","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 client records
Using: SELECT * FROM client

Add a Client
# Per Page Reverse Totals Columns
Client Last name First name Middle name Name Suffix Name Alias
Date of Birth 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
Added At Added By Record Changed At Record Changed By ord Deleted? Record Deleted At
Record Deleted By Deleted Comment System Log Name Full Name Full Alias Protected Id?
Household Composition Client / ID # Last Entry Restriction Status Gender
Ethnicity
Date of Birth
Picture
Records 1-50 (of 324 total records)
Page 1 of 7 Next 1 2 3 4 5 6 7
  #
Client
/
ID
#
Last
Entry
Restriction
Status
Gender />Ethnicity />Date
of
Birth
Picture
  1 SARAH, PUBLIC HEALTH
ID #393
(no Entries) Not barred (Add a bar) Unknown
Unknown, Latino
8/29/1980
111-22-3333
  2 SARAH, PUBLIC HEALTH
ID #396
(no Entries) Not barred (Add a bar) Male
Native American Indian
3/27/2013
111-22-3333
  3 JOHNSON, JOHN
ID #397
(no Entries) Not barred (Add a bar) Male
African, Alaska Native, Caucasian
1/13/1966
112-22-3333
  4 CONKLIN, GREG (aka WILCOX, JOHN)
ID #221
(no Entries) Not barred (Add a bar) Male
Other (undefined)
5/12/1961
000-00-8272
  5 BOGAN, JOSH, JR.
ID #399
(no Entries) Not barred (Add a bar) Transgender (Direction Unknown)
Alaska Native
7/1/2013
111-11-2345
  6 WILLIAMS, SHANELL
ID #400
Last Entry (Main Shelter): 7/30/13 8:03 am Not barred (Add a bar) Female
African Am/African Descent
1/4/1982
292-92-8445
  7 MCCONNELL, FRANK
ID #392
Last Entry (Main Shelter): 4/7/14 2:40 pm Not barred (Add a bar) Male
Chinese, Filipino
1/13/1922
122-23-3321
  8 ALDERMAN, CARLOS
ID #192
(no Entries) Not barred (Add a bar) Male
African Am/African Descent
5/31/1974
000-00-6477
  9 SAUSMER, SARAH
ID #368
(no Entries) Not barred (Add a bar) Female
Other (), Unknown
8/29/1957
111-22-3344
  10 JOHNSON, SYLVIAN W.
ID #372
(no Entries) Not barred (Add a bar) Female
(no Ethnicities)
1/13/1955
123-33-3333
  11 MARK, TWAIN
ID #398
(no Entries) Not barred (Add a bar) Male
African
2/29/1972
078-05-1120
  12 CONBERG, SCOUT
ID #359
(no Entries) Not barred (Add a bar) Female
(no Ethnicities)
10/1/1956
111-22-3333
  13 Johnson, Sally
ID #366
Last Entry (Front Door): 8/24/12 12:44 pm Not barred (Add a bar) Female
Latino
1/1/1974
123-33-3332
  14 SMITH, JOHN
ID #375
Last Entry (Main Shelter): 1/26/16 2:45 pm Not barred (Add a bar) Female
Alaska Native
1/1/1955
123-45-6789
  15 JOHANNSEN, PETER
ID #376
(no Entries) Not barred (Add a bar) Female
African Am/African Descent, Other Asian (Myanamar)
6/1/1949
543-44-5543
  16 TELLER, MARJANI
ID #265
Last Entry (Main Shelter): 5/5/11 1:01 pm Not barred (Add a bar) Female
African Am/African Descent
5/8/1959
000-00-3289
  17 GARDIPE, ROBBI
ID #269
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
5/8/1969
000-00-9746
  18 ARCHACKI, LAINIE B
ID #275
(no Entries) Not barred (Add a bar) Female
Caucasian
8/23/1953
000-00-6027
  19 PHILLIPS, LISA
ID #279
(no Entries) Not barred (Add a bar) Female
Caucasian
2/23/1953
000-00-2140
  20 HOLMES, FELICIA
ID #202
(no Entries) Not barred (Add a bar) Female
Caucasian
5/9/1973
000-00-7747
  21 SWIFT, SHERRIL
ID #263
Last Entry (Front Door): 4/11/13 10:48 am Not barred (Add a bar) Female
African Am/African Descent
7/3/1952
000-00-3929
  22 LAUGHLIN, KRISTI
ID #242
(no Entries) Not barred (Add a bar) Female
African Am/African Descent, Caucasian
3/26/1950
000-00-6633
  23 GREGORY, RITA, JR.
ID #127
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
7/8/1939
000-00-1210
  24 DAVIS, MARLENE
ID #211
(no Entries) Not barred (Add a bar) Female
Caucasian
7/9/1959
000-00-9341
  25 HALL, KARENZA
ID #149
(no Entries) Not barred (Add a bar) Female
Native American Indian
10/5/1970
000-00-3467
  26 YAZZIE, PAMELA (aka CHAVEZ, STEPHANIE)
ID #158
(no Entries) Not barred (Add a bar) Female
Caucasian
11/15/1946
000-00-4124
  27 DENISON, EUNICE (aka BELTRAN, KIMBERLY)
ID #174
(no Entries) Not barred (Add a bar) Female
Caucasian
8/9/1951
000-00-6275
  28 MEYERS, SUSAN
ID #176
Last Entry (Main Shelter): 5/4/11 9:14 pm Not barred (Add a bar) Female
Caucasian
7/10/1970
000-00-2582
  29 TYLER, MARIA
ID #253
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
5/23/1998
000-00-2858
  30 CHANEY, JENNIFER
ID #256
(no Entries) Not barred (Add a bar) Female
Caucasian
5/20/1964
000-00-5867
  31 QUINTASKET, MISSY (aka GRIFFIN, MARIE)
ID #349
Last Entry (Main Shelter): 6/18/18 9:09 am Not barred (Add a bar) Female
African Am/African Descent
8/23/1958
000-00-9402
  32 WASCHKIES, SONJA
ID #187
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
9/18/1951
000-00-4653
  33 GUTIERREZ, JESUS (aka NOTTI, VIRGINIA)
ID #194
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
5/30/1975
000-00-1498
  34 GRIFFITH, SHERRY (aka PAIGE, ANNETTE)
ID #303
(no Entries) Not barred (Add a bar) Female
Caucasian
12/28/1948
000-00-1412
  35 HARRISON, PIKA (aka SELLERS, JULIE)
ID #136
(no Entries) Not barred (Add a bar) Female
Caucasian
7/31/1959
000-00-9773
  36 GREEN, SHIRLEY
ID #340
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
1/30/1943
000-00-6381
  37 BLOYD, ETHEL
ID #185
Last Entry (Main Shelter): 5/4/11 9:01 pm Not barred (Add a bar) Female
Caucasian
9/18/1961
000-00-6654
  38 MORENO, KIMBERLY
ID #342
(no Entries) Not barred (Add a bar) Female
Native American Indian
5/10/1950
000-00-8338
  39 REYNOLDS, STEPHANIE M
ID #345
(no Entries) Not barred (Add a bar) Female
Caucasian
1/1/1958
000-00-2845
  40 COLEMAN, MONIQUE
ID #137
(no Entries) Not barred (Add a bar) Female
Caucasian
3/2/1976
000-00-8378
  41 ENGELBERT, TONYA I
ID #155
(no Entries) Not barred (Add a bar) Female
Caucasian
3/5/1960
000-00-2842
  42 DIXON, BEVERLY
ID #233
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
3/7/1959
000-00-5534
  43 PINA, MICHELLE
ID #183
(no Entries) Not barred (Add a bar) Female
Native American Indian
4/19/1959
000-00-3734
  44 THANH, LORA
ID #300
(no Entries) Not barred (Add a bar) Female
Latino
10/17/1976
000-00-5122
  45 ECKERSON, ELIZABETH O
ID #180
(no Entries) Not barred (Add a bar) Female
Caucasian
12/17/1942
000-00-6314
  46 SCHAUER, ANNE
ID #259
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
8/22/1974
000-00-2767
  47 PEREZ, DORSEY E
ID #257
(no Entries) Not barred (Add a bar) Female
African Am/African Descent
4/6/1961
000-00-2469
  48 KRAEMER, JULIE
ID #117
(no Entries) Not barred (Add a bar) Female
Caucasian
8/8/1976
000-00-6151
  49 JOHNDON, TIM
ID #383
(no Entries) Not barred (Add a bar) Female
Eskimo
11/13/1922
923-33-3333
  50 LAST NAME, TEST
ID #389
(no Entries) Not barred (Add a bar) Female
Vietnamese
10/4/2011
555-55-5555
Page 1 of 7 Next 1 2 3 4 5 6 7