About this Dataset

2024 Citywide Retention Audit - Employee Survey Results

The audit team surveyed City staff from January 29th, 2024 to February 14th, 2024. All employees who received the survey link were eligible to respond. See the full audit report at: https://www.austintexas.gov/sites/default/files/files/Auditor/Audit_Reports/Citywide_Retention_August_2024.pdf
Organization: City of Austin
Last updated: 2024-10-25T11:58:42.270174
Tags: audit, audits, employees, human-resources, survey

Tables

Table 1

@usgov.city_of_austin_2024_citywide_retention_audit_employee__0e1b7ce4.table_1

138.31 kB
6,523 rows
29 columns

CREATE TABLE table_1 (
  "survey_response_number" BIGINT,
  "q1_how_many_years_have_you_worked_for_the_city" VARCHAR  -- Q1 How Many Years Have You Worked For The City?,
  "q2_have_you_ever_transferred_departments_within_the_city" VARCHAR  -- Q2 Have You Ever Transferred Departments Within The City?,
  "altq3a_additional_career_advancement_opportunities" VARCHAR,
  "altq3b_attractive_retention_incentives_in_the_new_department" VARCHAR,
  "altq3c_better_compensation_salary" VARCHAR,
  "altq3d_better_management_co_workers_department_culture" VARCHAR  -- AltQ3D Better Management/ Co-workers/ Department Culture,
  "altq3e_dissatisfaction_with_how_i_was_treated_in_my_pr_88a05218" VARCHAR  -- AltQ3E Dissatisfaction With How I Was Treated In My Previous Department,
  "altq3f_more_opportunities_for_telework_flexible_work_hours" VARCHAR  -- AltQ3F More Opportunities For Telework/ Flexible Work Hours,
  "q4a_i_intend_to_be_working_for_the_city_1_year_from_now" VARCHAR  -- Q4A I Intend To Be Working For The City 1 Year From Now.,
  "q4b_i_intend_to_be_working_for_the_city_5_years_from_now" VARCHAR  -- Q4B I Intend To Be Working For The City 5 Years From Now.,
  "q4c_i_intend_to_retire_from_the_city" VARCHAR  -- Q4C I Intend To Retire From The City.,
  "q5_since_becoming_a_city_of_austin_employee_when_was_t_6a6a8bcb" VARCHAR  -- Q5 Since Becoming A City Of Austin Employee, When Was The Last Time You Applied For A Job Outside The City?,
  "q6a_benefits_including_insurance_vacation_etc" VARCHAR  -- Q6A Benefits (including Insurance, Vacation, Etc.),
  "q6b_career_advancement_opportunities" VARCHAR,
  "q6c_commitment_to_public_service" VARCHAR,
  "q6d_compensation_salary" VARCHAR,
  "q6e_fair_and_equitable_treatment" VARCHAR,
  "q6f_management_co_workers_department_culture" VARCHAR  -- Q6F Management/ Co-workers/ Department Culture,
  "q6g_retirement_pension" VARCHAR  -- Q6G Retirement/ Pension,
  "q6h_telework_flexible_work_hours" VARCHAR  -- Q6H Telework/ Flexible Work Hours,
  "q7_do_the_training_and_development_opportunities_offer_8863d16b" VARCHAR  -- Q7 Do The Training And Development Opportunities Offered By Your Department Improve Your Desire To Stay With The City?,
  "q8_do_the_training_and_development_opportunities_offer_d7e69137" VARCHAR  -- Q8 Do The Training And Development Opportunities Offered By The City Improve Your Desire To Stay With The City?,
  "q9a_i_am_satisfied_with_my_current_work_life_balance" VARCHAR  -- Q9A I Am Satisfied With My Current Work/life Balance.,
  "q9b_i_feel_valued_by_my_management" VARCHAR  -- Q9B I Feel Valued By My Management.,
  "q9c_i_would_recommend_my_department_to_a_friend" VARCHAR  -- Q9C I Would Recommend My Department To A Friend.,
  "q9d_i_would_recommend_the_city_as_an_employer_to_a_friend" VARCHAR  -- Q9D I Would Recommend The City As An Employer To A Friend.,
  "q10_what_department_are_you_with" VARCHAR  -- Q10 What Department Are You With?,
  "q11_does_the_retention_program_offered_by_your_departm_8da3935b" VARCHAR  -- Q11 Does The Retention Program Offered By Your Department Improve Your Desire To Stay With The City? Retention Program Refers To Any Monetary Incentives Added To Base Pay.
);